ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sven Boden <list...@pandora.be>
Subject RE: reset jdbc connection
Date Fri, 27 Jan 2006 17:38:35 GMT

It looks a bit like 
Which database are using... sybase by any chance?


Brent Ryan wrote:

>I don't believe this is an iBatis problem since you're letting your
>application server manage your transaction.  Your application server
>needs to validate the connections before handing them over so I'd check
>  _____  
>From: Scott Zhu [mailto:scottzhu@gmail.com] 
>Sent: Friday, January 27, 2006 10:18 AM
>To: user-java@ibatis.apache.org
>Subject: reset jdbc connection
>   I'm using weblogic 8.1 in this case and transaction is managed by the
>application server. Here's my configuration for the sql map:
>   <transactionManager commitRequired="true" type="JDBC">
>     <dataSource type="JNDI">
>        <property name="DataSource" value="${dataSourceName}"/> 
>     </dataSource>
>   </transactionManager>
>If I shutdown the database and bring it back, then click on some links
>that requires database access, I'd get the following exception
>java.sql.SQLException: Cannot obtain connection: driverURL =
>jdbc:weblogic:pool:Campaign Barcelona, props =
>{enableTwoPhaseCommit=false, connectionPoolID=Campaign Barcelona,
>jdbcTxDataSource=true, dataSourceName=Campaign Data Source for
>Nested Exception: java.lang.RuntimeException: Failed to setAutoCommit to
>true for pool connection.
> at weblogic.jdbc.wrapper.PoolConnection.init(PoolConnection.java:47)
> at weblogic.jdbc.pool.Driver.allocateConnection (Driver.java:254)
> at weblogic.jdbc.pool.Driver.connect(Driver.java:164)
> at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:509)
> at weblogic.jdbc.jts.Driver.connect(Driver.java:139)
> at weblogic.jdbc.common.internal.RmiDataSource.getConnection
> at
> at
> at
> at
> at
> at
> at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList
>It seemed like it's trying to use an old connection which is not valid
>any more. I think I can try to enable " Test Reserved Connections" in
>weblogic to test the connections periodically to avoid this. But this
>problem doesn't seem to happen on raw jdbc access calls (not thru
>ibatis). So I wonder if there's some setting in ibatis I need to do to
>fix this. Thanks for any help. 
>BbWorld '06
>New Client-Centered Program, Peers Aplenty, Party on Deck
>San Diego, CA February 28-March 2, 2006
>Register today! Visit: http://www.blackboard.com/company/events/bbworld/ to learn more.
>This e-mail is intended only for the personal and confidential use of the recipient(s)
named above. 
>It may include Blackboard confidential and proprietary information, and is not for redistribution.

View raw message