Subject | Can't estabilish more than one connection at a time to a read-only database |
---|---|
Author | Fabiano Bonin |
Post date | 2008-07-05T19:17:07Z |
Hi all,
When i put a database in read-only state, i'm not able to estabilish
more than one connection at a time to it.
TEST CASE:
FB CS 2.1 on Linux Fedora Core 5
isql
SET SQL DIALECT 3;
SET NAMES NONE;
CREATE DATABASE '127.0.0.1:/tst/db.fdb' USER 'SYSDBA' PASSWORD
'masterkey' PAGE_SIZE 8192 DEFAULT CHARACTER SET NONE;
exit;
cd /tst/
gfix -mode read_only db.fdb
If i try to connect to it using the command below, the second
connection hangs until the first disconnects:
isql 127.0.0.1:/tst/db.fdb -user sysdba -pass masterkey
Regards,
Fabiano
When i put a database in read-only state, i'm not able to estabilish
more than one connection at a time to it.
TEST CASE:
FB CS 2.1 on Linux Fedora Core 5
isql
SET SQL DIALECT 3;
SET NAMES NONE;
CREATE DATABASE '127.0.0.1:/tst/db.fdb' USER 'SYSDBA' PASSWORD
'masterkey' PAGE_SIZE 8192 DEFAULT CHARACTER SET NONE;
exit;
cd /tst/
gfix -mode read_only db.fdb
If i try to connect to it using the command below, the second
connection hangs until the first disconnects:
isql 127.0.0.1:/tst/db.fdb -user sysdba -pass masterkey
Regards,
Fabiano