ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: On Before Get Connection
Date Wed, 12 Dec 2007 15:33:31 GMT
You could implement your own transaction manager and do the initiailzation
there before returning the connection to iBATIS.

Jeff Butler



On Dec 12, 2007 4:19 AM, Denis Karpov <denis-karpov@mail.ru> wrote:

> I can't use ping query because i can't specify parameters in it.
>
> > That would be the ping query (to test if the connection is alive)?
> >
> > <transactionManager type="JDBC">
> >
> >     <dataSource type="SIMPLE">
> >
> >       <property value="${driver}" name="JDBC.Driver"/>
> >
> >       <property value="${url}" name="JDBC.ConnectionURL"/>
> >
> >       <property value="${username}" name="JDBC.Username"/>
> >
> >       <property value="${password}" name="JDBC.Password"/>
> >
> >       <property value="15" name="Pool.MaximumActiveConnections"/>
> >
> >       <property value="15" name="Pool.MaximumIdleConnections"/>
> >
> >       <property value="1000" name="Pool.MaximumWait"/>
> >
> > *      <property name="Pool.PingQuery" value="SELECT 1 FROM Company"/>*
> >
> > *      <property name="Pool.PingEnabled" value="true" />*
> >
> > *      <property name="Pool.PingConnectionsOlderThan" value="1000000"
> />*
> >
> >     </dataSource>
> >
> >   </transactionManager>
> >
> >
> >
> > -----Original Message-----
> > From: Denis Karpov [mailto:denis-karpov@mail.ru]
> > Sent: Wednesday, December 12, 2007 12:01 PM
> > To: user-java@ibatis.apache.org
> > Subject: On Before Get Connection
> >
> >
> >
> > When iBatis gets a connection from the pool for processing, how can I
> >
> > execute some initialization SQL before this connection will be used by
> >
> > iBatis?
> >
> > Thanks
> >
>
>

Mime
View raw message