In that case, you could set up a ping/validation query. Either in SimpleDataSource, DBCP or your app server. No need to do it yourself.
Cheers, Clinton On 8/10/07, Diran Ayandele <[EMAIL PROTECTED]> wrote: > Clinton, > Option A - it always fails when first requested or else succeeds. I > run several (6 I think) queries per cycle and once connected never have > a problem. Here is the jdbc url for giggles. > JDBC.ConnectionURL=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES) > (ADDRESS=(PROTOCOL=tcp)(HOST=fqdn1.domain.sun.com)(PORT=1521)) > (ADDRESS=(PROTOCOL=tcp)(HOST=fqdn2.domain.sun.com)(PORT=1521)) > (ADDRESS=(PROTOCOL=tcp)(HOST=fqdn3.domain.sun.com)(PORT=1521)) > (ADDRESS=(PROTOCOL=tcp)(HOST=fqdn4.domain.sun.com)(PORT=1521)) > (CONNECT_DATA=(SERVICE_NAME=MYSERVICENAME))) > > It always works fine when I am testing it in netbeans and regularly > fails when I excute it from the jar not that it should make any difference. > > Diran > > Clinton Begin wrote: > > >Does the driver always fail fast upon requesting it from the data > >source? Or is it possible that even after executing 3 of 5 statements > >successfully, it could fail on the 4th? > > > >Clinton > > > >On 8/10/07, Diran Ayandele <[EMAIL PROTECTED]> wrote: > > > > > >> Hi, I have a flaky oracle 11i grid db that I have to connect to. > >>Sometimes it works and sometimes not. I think this is a problem with > >>the tns setup on some of the nodes, but I have no control over any of > >>that. So, I've written a looping connector for the database which > >>returns a jdbc Connection when it's finished. Is there a way I can pass > >>this to iBatis? I'm only using sqlMaps and have no DAO to speak of. > >>I'd like to be able to plug this into a SqlMapClient object. > >> > >>Thanks for any assistance guys! > >>Diran > >> > >> > >> >
