[Sqlrelay-discussion] SQLRelay hangs with incorrect connection string

[Maciej W. <mac...@co...>]

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