Clinton,
Got it - that seems logical. I'll post my results to this thread
when I get it working.
Thanks!
Diran
Clinton Begin wrote:
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
