[Sqlrelay-discussion] "Too many listeners" error

[Andrew L <akl...@ya...>]

Hi,

I'm using rudiments-0.32 and sqlrelay-0.39.4  .

I have the following Perl code:

    1 ....
    2 $stmt = 'begin :cursor := my_func; end;';
    3 $curs->prepareQuery ($stmt);
    4 $curs->defineOutputBindCursor("cursor");
    5 $curs->executeQuery() || die "Can't retrieve data from database: " . $curs->errorMessage();
    7 ....

The script dies at line 5 with "Can't retrieve data from database: Too many listeners" error message.

Here's what I have in my sqlrelay.conf file:

 <instance id="my_id"                 port="9000"          dbase="oracle8"           
            connections="5"           maxconnections="30"  maxqueuelength="5"             
            growby="1"                ttl="600"            endofsession="rollback"    sessiontimeout="600"           
            runasuser="spock"         runasgroup="vulcan"               cursors="10"                   
            authtier="listener"       handoff="pass"                    deniedips=""  allowedips=""                  
            debug="listener_and_connection"   maxquerysize="65536"      maxstringbindvaluelength="4000"
            maxlobbindvaluelength="71680"  idleclienttimeout="5"          
            maxlisteners="10"         listenertimeout="0"            
            reloginatstart="false">   
            
What settings do i need to change to fix the error?


Thanks 
--Andrew