[Sqlrelay-discussion] SQLRelay hangs with incorrect connection string
Brought to you by:
mused
|
From: Maciej W. <mac...@co...> - 2005-08-31 08:51:33
|
Hi
I've just ecountered one problem with connection parameters to SQLRelay
. In sqlrelay.conf I have:
<instance id="xadm" port="9004"
socket="/tmp/xadm.socket"
dbase="oracle7" connections="3" maxconnections="5"
maxqueuelength="0"
growby="1" ttl="60" endofsession="commit"
sessiontimeout="600" runasuser="nobody"
runasgroup="nobody" cursors="5"
authtier="listener" handoff="pass"
debug="None">
<users>
<user user="test" password="test"/>
</users>
<connections>
<connection connectionid="xadm"
string="user=xadm;password=xadm;oracle_sid=devz" metric="1"/>
</connections>
</instance>
when using script like this:
// ------------------------------------------------------------
from SQLRelay import PySQLRClient
from SQLRelay import PySQLRDB
con=PySQLRDB.connect('localhost',9004,'','test','test',0,1)
cur=PySQLRClient.sqlrcursor(con)
res = cur.sendQuery('select * from xxx')
// ------------------------------------------------------------
everything is OK (ORA exception is thrown (table xxx not known)
and res == 0)
but changing connection string to:
con=PySQLRDB.connect('localhost',9004,'','test','testx',0,1)
(here is incorrect password: testx) causes script to
hang waiting for response...
This is PythonAPI and SQLRelay 0.36.4.
Is this a bug or my config file or script is wrong?
--
Maciej Wisniowski
|