ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clinton Begin" <clinton.be...@gmail.com>
Subject Re: [Fwd: Passing a connection to ibatis.]
Date Fri, 10 Aug 2007 20:07:07 GMT
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 <Adediran.Ayandele@sun.com> 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 <Adediran.Ayandele@sun.com> 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
> >>
> >>
> >>
>

Mime
View raw message