Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 cloned connection

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-01-24 : 09:20:01
Priyank writes "I am using SQL Server JDBC Driver from Microsoft...
[driver=com.microsoft.jdbc.sqlserver.SQLServerDriver]

I am able to deploy the application on Pramati Application Server... The connection pool maintains a pool of connection with autoCommit=true... When a connection is enlisted as part of a transaction its autoCommit is set to false...

so i try to start a transaction I get an Exception when the server tries to connecitonWrapper.autoCommit(false).. and I get a message "Can't start manual transaction mode because there are cloned connections."

Please let me know what "cloned connection" means...

The stack trace is below...

java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't start manual transaction mode because there are cloned connections.
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.setAutoCommit(Unknown Source)
at com.pramati.resource.jdbc.xa.PramatiXAResource.start(PramatiXAResource.java:204)
at com.pramati.jta.PramatiTransaction.enlistResource(PramatiTransaction.java:425)
at com.pramati.resource.jdbc.xa.TxnConnHolder.enlistConnWithCurrentTransaction(TxnConnHolder.java:114)
at com.pramati.resource.jdbc.ClientConnectionWrapper.enlistWithCurrentTx(ClientConnectionWrapper.java:393)
at com.pramati.resource.jdbc.ClientConnectionWrapper.prepareStatement(ClientConnectionWrapper.java:125)
at proton.bank.CheckingImpl_1238730670._ejbLoad(CheckingImpl_1238730670.java:666)
at com.pramati.ejb.core.CMPEntityBeanHandler.activate(CMPEntityBeanHandler.java:133)
at com.pramati.ejb.core.CMPEntityBeanHandler.lockEJB(CMPEntityBeanHandler.java:288)
at com.pramati.ejb.core.BeanHandlerImplBase.preInvokeRemote(BeanHandlerImplBase.java:347)
at com.pramati.ejb.core.BeanHandlerImplBase.preInvokeRemote(BeanHandlerImplBase.java:333)
at proton.bank.CheckingImpl_1238730670._pramati_impl_credit(CheckingImpl_1238730670.java:138)
at proton.bank.CheckingImpl_1238730670$1.run(CheckingImpl_1238730670.java:118)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:437)
at com.pramati.security.util.JAASSecurityHelper.doAs(JAASSecurityHelper.java:281)
at java.lang.reflect.Method.invoke(Native Method)
at com.pramati.services.security.spi.SecurityHelper.doAs(SecurityHelper.java:169)
at proton.bank.CheckingImpl_1238730670.credit(CheckingImpl_1238730670.java:116)
at proton.bank.TransferBean.transfer(TransferBean.java:56)
at proton.bank.TransferImpl_1125017281._pramati_impl_transfer(TransferImpl_1125017281.java:129)
at proton.bank.TransferImpl_1125017281$1.run(TransferImpl_1125017281.java:107)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:437)
at com.pramati.security.util.JAASSecurityHelper.doAs(JAASSecurityHelper.java:281)
at java.lang.reflect.Method.invoke(Native Method)
at com.pramati.services.security.spi.SecurityHelper.doAs(SecurityHelper.java:169)
at proton.bank.TransferImpl_1125017281.transfer(TransferImpl_1125017281.java:105)
at com.pramati.jsp.generated.transfer_pmt_0._jspService(transfer_pmt_0.java:111)
at com.pramati.jsp.runtime.HttpJspSuper.service(HttpJspSuper.java:87)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.pramati.web.interceptors.ServiceInterceptor$ServiceAction.run(ServiceInterceptor.java:246)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:437)
at com.pramati.security.util.JAASSecurityHelper.doAs(JAASSecurityHelper.java
   

- Advertisement -