[Sqlrelay-discussion] What are cursors and how many do I need?

[Stephen C. <st...@to...>]

I'm new to using sqlrelay to connect to an Oracle 10g database and this 
is the first day in full production.  Every once in a while I get a 
strange error that looks like I have a connection to an instance but I 
canno toproicess any SQL.  From the log generated by DBI:

     -> prepare for DBD::SQLRelay::db (DBI::db=HASH(0x8e24758)~0x8e24a88 
'select
1 from dual') thr#8a610081
     <- FETCH= ( SQLRelay::Connection=SCALAR(0x8e24c08) ) [1 items] 
('driver_connection' from cache) at SQLRelay.pm line 138
     -> STORE for DBD::SQLRelay::st (DBI::st=HASH(0x8e24b78)~0x9179278 
'driver_database_handle' DBI::db=HASH(0x8e24a88)) thr#8a61008
     <- STORE= 1 at SQLRelay.pm line 145
     -> STORE for DBD::SQLRelay::st (DBI::st=HASH(0x8e24b78)~0x9179278 
'NUM_OF_PARAMS' 0) thr#8a61008
     <- STORE= 1 at SQLRelay.pm line 146
     -> STORE for DBD::SQLRelay::st (DBI::st=HASH(0x8e24b78)~0x9179278 
'driver_is_select' 1) thr#8a61008
     <- STORE= 1 at SQLRelay.pm line 147
     -> STORE for DBD::SQLRelay::st (DBI::st=HASH(0x8e24b78)~0x9179278 
'driver_cursor' SQLRelay::Cursor=SCALAR(0x8e24cf8)) thr#8a61008
     <- STORE= 1 at SQLRelay.pm line 148
     -> STORE for DBD::SQLRelay::st (DBI::st=HASH(0x8e24b78)~0x9179278 
'NUM_OF_PARAMS' 0) thr#8a61008
     <- STORE= 1 at SQLRelay.pm line 158
     <- prepare= DBI::st=HASH(0x8e24b78) at sql.pm line 185
     -> execute for DBD::SQLRelay::st 
(DBI::st=HASH(0x8e24b78)~0x9179278) thr#8a610081
<- FETCH= SQLRelay::Cursor=SCALAR(0x8e24cf8) ('driver_cursor' from 
cache) at SQLRelay.pm line 349
     -> $DBI::errstr (&) FETCH from lasth=HASH
     >> DBD::SQLRelay::st::errstr
     <- $DBI::errstr= undef

Looks to me like there is no "driver_cursor" to handle the job.

I've set in sqlrelay.conf:

connections="10"
maxconnections="32"
cursors="32"

Am I barking up the wrong tree here?

-- 
Stephen Carville <st...@to...>
Unix and Network Admin
Nationwide Totalflood
6033 W. Century Blvd
Los Angeles, CA 90045
310-342-3602