Subject | Problem with multiple isql sessions |
---|---|
Author | Gerhard Wiesinger |
Post date | 2007-04-22T07:01:13Z |
Hello!
I'm new to firebird but have experience with other databases (MySQL,
PostgreSQL, Oracle, ...).
Setup worked well but I'm having the following problems:
1.) Other session not updated:
Session 1 with isql:
INSERT & COMMIT
Session 2 with isql after commit of session 1 (isql already open):
SELECT COUNT(*) from tablename; -- Still 0, works only after quitting isql
and restart it.
=> Session 2 with JDBC is updated correctly, also a IB Query remote
session
Any ideas?
Thank you for the answer.
Ciao,
Gerhard
--
http://www.wiesinger.com/
I'm new to firebird but have experience with other databases (MySQL,
PostgreSQL, Oracle, ...).
Setup worked well but I'm having the following problems:
1.) Other session not updated:
Session 1 with isql:
INSERT & COMMIT
Session 2 with isql after commit of session 1 (isql already open):
SELECT COUNT(*) from tablename; -- Still 0, works only after quitting isql
and restart it.
=> Session 2 with JDBC is updated correctly, also a IB Query remote
session
Any ideas?
Thank you for the answer.
Ciao,
Gerhard
--
http://www.wiesinger.com/