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 
http://forums.bea.com/bea/message.jspa?messageID=200019770&tstart=0
Which database are using... sybase by any chance?

Regards,
Sven

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
>there.
> 
>Brent
>
>  _____  
>
>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
>sometimes:
> 
>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
>partition1}. 
>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
>(RmiDataSource.java:305)
> at
>com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTrans
>action.java:48)
> at
>com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(
>JdbcTransaction.java:89) 
> at
>com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
>ForList(GeneralStatement.java:123)
> at
>com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
>ExecutorDelegate.java:610)
> at
>com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
>ExecutorDelegate.java:584)
> at
>com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessi
>onImpl.java:101)
> at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList
>(SqlMapClientImpl.java:78)
>...
> 
>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.
>
>
>
>  
>


Mime
View raw message