ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Denis Karpov <denis-kar...@mail.ru>
Subject Re: On Before Get Connection
Date Wed, 12 Dec 2007 10:19:52 GMT
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