dcsimg
can't start a cloned connection....
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   zhebin_cong
Posted On:   Wednesday, March 13, 2002 07:46 PM

hello i use combination of jbuilder6 and bes5 to develop ejb,i write a session bean as facade to call a entity bean that map to a table(named "jobs") in my database(sqlserver2000),then use the "test client wizard" of jb6 to generate a test client,in the client,i call a method of the session bean to retrieve a field from the table through the entity bean. my entity bean:com.mansion.ejb.entity.jobs my session bean:com.mansion.ejb.session.TableViewer but throw follow exception: Throwing TransactionRolledbackException for the method: public abstract com.mansion.ejb.entity.JobsRemote com.mansion.ejb.entity.JobsRemoteH   More>>

hello


i use combination of jbuilder6 and bes5 to develop ejb,i write a session
bean as facade to call a entity bean that map to a table(named "jobs") in my
database(sqlserver2000),then use the "test client wizard" of jb6 to generate
a test client,in the client,i call a method of the session bean to retrieve
a field from the table through the entity bean.



my entity bean:com.mansion.ejb.entity.jobs
my session bean:com.mansion.ejb.session.TableViewer


but throw follow exception:



Throwing TransactionRolledbackException for the method: public abstract
com.mansion.ejb.entity.JobsRemote
com.mansion.ejb.entity.JobsRemoteHome.findByPrimaryKey(java.lang.Integer)
throws java.rmi.RemoteException,javax.ejb.FinderException
java.rmi.ServerException: Could not execute query using SQL: SELECT
job_desc, job_id, max_lvl, min_lvl FROM jobs WHERE job_id=?; nested
exception is: java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't
start a cloned connection while in manual transaction mode.; nested
exception is:
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't start a
cloned connection while in manual transaction mode.
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't start a
cloned connection while in manual transaction mode.
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.getImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.getImplStatement(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.preProcessSQL(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement. (Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
at
com.inprise.visitransact.jdbc2.PreparedStatementCache.getPreparedStatement(P
reparedStatementCache.java:112)
at
com.inprise.visitransact.jdbc2.ConnectionProxy.prepareStatement(ConnectionPr
oxy.java:157)
at
com.inprise.visitransact.jdbc2.PreparedStatementCache.getPreparedStatement(P
reparedStatementCache.java:112)
at
com.inprise.visitransact.jdbc2.ConnectionProxy.prepareStatement(ConnectionPr
oxy.java:157)
at com.borland.ejb.pm.JdbcResourceContext.prepareStatement(Unknown Source)
at com.borland.ejb.pm.l.a(Unknown Source)
at com.borland.ejb.pm.JdbcTableManager.findByPrimaryKey(Unknown Source)
at com.borland.ejb.pm.JdbcEntityManager.findByTrustedPrimaryKey(Unknown
Source)
at com.borland.ejb.pm.JdbcEntityManager.findByPrimaryKey(Unknown Source)
at
com.mansion.ejb.entity.JobsBean_PM.ejbFindByPrimaryKey(JobsBean_PM.java:51)
at java.lang.reflect.Method.invoke(Native Method)
at com.inprise.ejb.ConcreteMethod.invoke(ConcreteMethod.java:29)
at com.inprise.ejb.EJBContext.invoke(EJBContext.java:161)
at com.inprise.ejb.Dispatcher.doInvoke(Dispatcher.java:1293)
at com.inprise.ejb.Dispatcher.invokeSecurityCheck(Dispatcher.java:1055)
at com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:850)
at com.inprise.ejb.Dispatcher.find(Dispatcher.java:765)
at com.inprise.ejb.EntityHome.doFind(EntityHome.java:158)
at com.inprise.ejb.EntityHome.find(EntityHome.java:182)
at com.inprise.ejb.EJBHome.invoke(EJBHome.java:279)
at com.inprise.ejb.EJBHome.access$400(EJBHome.java:6)
at com.inprise.ejb.EJBHome$RemoteStrategyImpl.invoke(EJBHome.java:665)
at
com.mansion.ejb.entity.JobsRemoteHomePOAInvokeHandler.findByPrimaryKey(JobsR
emoteHomePOAInvokeHandler.java:36)
at
com.mansion.ejb.entity.JobsRemoteHomePOAInvokeHandler.findByPrimaryKey(JobsR
emoteHomePOAInvokeHandler.java:88)
at
com.mansion.ejb.entity._JobsRemoteHome_Stub.findByPrimaryKey(_JobsRemoteHome
_Stub.java:55)
at
com.mansion.ejb.session.TableViewerBean.recieveField(TableViewerBean.java:42
)
at java.lang.reflect.Method.invoke(Native Method)
at com.inprise.ejb.ConcreteMethod.invoke(ConcreteMethod.java:29)
at com.inprise.ejb.EJBContext.invoke(EJBContext.java:161)
at com.inprise.ejb.Dispatcher.doInvoke(Dispatcher.java:1293)
at com.inprise.ejb.Dispatcher.invokeSecurityCheck(Dispatcher.java:1055)
at com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:850)
at com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:665)
at com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:417)
at
com.mansion.ejb.session.TableViewerPOAInvokeHandler.recieveField(TableViewer
POAInvokeHandler.java:34)
at
com.mansion.ejb.session.TableViewerPOAInvokeHandler.recieveField(TableViewer
POAInvokeHandler.java:71)
at com.mansion.ejb.session.TableViewerPOA._invoke(TableViewerPOA.java:61)
at com.mansion.ejb.session.TableViewerPOA._invoke(TableViewerPOA.java:43)
at com.inprise.vbroker.poa.POAImpl.invoke(POAImpl.java:2597)
at
com.inprise.vbroker.poa.ActivationRecord.invoke(ActivationRecord.java:105)
at
com.inprise.vbroker.poa.ServerInterceptorManager$ARWrapper.invoke(ServerInte
rceptorManager.java:95)
at
com.inprise.vbroker.GIOP.GiopProtocolAdapter.doRequest(GiopProtocolAdapter.j
ava:621)
at
com.inprise.vbroker.IIOP.ServerProtocolAdapter.doRequest(ServerProtocolAdapt
er.java:68)
at
com.inprise.vbroker.GIOP.GiopProtocolAdapter.dispatchMessage(GiopProtocolAda
pter.java:833)
at
com.inprise.vbroker.orb.TPDispatcherImpl$TPDispatcher.run(TPDispatcherImpl.j
ava:99)
at com.inprise.vbroker.orb.ThreadPool$PoolWorker.run(ThreadPool.java:76)
< < < < EJB LOG < < < <
>>>> EJB LOG >>>>
Throwing System exception for the container-started transaction for method:
public abstract java.lang.String
com.mansion.ejb.session.TableViewer.recieveField() throws
java.rmi.RemoteException,java.lang.Exception
javax.transaction.TransactionRolledbackException: java.rmi.ServerException:
Could not execute query using SQL: SELECT job_desc, job_id, max_lvl, min_lvl
FROM jobs WHERE job_id=?; nested exception is: java.sql.SQLException:
[Microsoft][SQLServer JDBC Driver]Can't start a cloned connection while in
manual transaction mode.; nested exception is:
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't start a
cloned connection while in manual transaction mode.; nested exception is:
java.rmi.ServerException: Could not execute query using SQL: SELECT
job_desc, job_id, max_lvl, min_lvl FROM jobs WHERE job_id=?; nested
exception is: java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't
start a cloned connection while in manual transaction mode.; nested
exception is:
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't start a
cloned connection while in manual transaction mode.
java.rmi.ServerException: Could not execute query using SQL: SELECT
job_desc, job_id, max_lvl, min_lvl FROM jobs WHERE job_id=?; nested
exception is: java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't
start a cloned connection while in manual transaction mode.; nested
exception is:
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't start a
cloned connection while in manual transaction mode.
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't start a
cloned connection while in manual transaction mode.
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.getImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.getImplStatement(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.preProcessSQL(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement. (Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
at
com.inprise.visitransact.jdbc2.PreparedStatementCache.getPreparedStatement(P
reparedStatementCache.java:112)
at
com.inprise.visitransact.jdbc2.ConnectionProxy.prepareStatement(ConnectionPr
oxy.java:157)
at
com.inprise.visitransact.jdbc2.PreparedStatementCache.getPreparedStatement(P
reparedStatementCache.java:112)
at
com.inprise.visitransact.jdbc2.ConnectionProxy.prepareStatement(ConnectionPr
oxy.java:157)
at com.borland.ejb.pm.JdbcResourceContext.prepareStatement(Unknown Source)
at com.borland.ejb.pm.l.a(Unknown Source)
at com.borland.ejb.pm.JdbcTableManager.findByPrimaryKey(Unknown Source)
at com.borland.ejb.pm.JdbcEntityManager.findByTrustedPrimaryKey(Unknown
Source)
at com.borland.ejb.pm.JdbcEntityManager.findByPrimaryKey(Unknown Source)
at
com.mansion.ejb.entity.JobsBean_PM.ejbFindByPrimaryKey(JobsBean_PM.java:51)
at java.lang.reflect.Method.invoke(Native Method)
at com.inprise.ejb.ConcreteMethod.invoke(ConcreteMethod.java:29)
at com.inprise.ejb.EJBContext.invoke(EJBContext.java:161)
at com.inprise.ejb.Dispatcher.doInvoke(Dispatcher.java:1293)
at com.inprise.ejb.Dispatcher.invokeSecurityCheck(Dispatcher.java:1055)
at com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:850)
at com.inprise.ejb.Dispatcher.find(Dispatcher.java:765)
at com.inprise.ejb.EntityHome.doFind(EntityHome.java:158)
at com.inprise.ejb.EntityHome.find(EntityHome.java:182)
at com.inprise.ejb.EJBHome.invoke(EJBHome.java:279)
at com.inprise.ejb.EJBHome.access$400(EJBHome.java:6)
at com.inprise.ejb.EJBHome$RemoteStrategyImpl.invoke(EJBHome.java:665)
at
com.mansion.ejb.entity.JobsRemoteHomePOAInvokeHandler.findByPrimaryKey(JobsR
emoteHomePOAInvokeHandler.java:36)
at
com.mansion.ejb.entity.JobsRemoteHomePOAInvokeHandler.findByPrimaryKey(JobsR
emoteHomePOAInvokeHandler.java:88)
at
com.mansion.ejb.entity._JobsRemoteHome_Stub.findByPrimaryKey(_JobsRemoteHome
_Stub.java:55)
at
com.mansion.ejb.session.TableViewerBean.recieveField(TableViewerBean.java:42
)
at java.lang.reflect.Method.invoke(Native Method)
at com.inprise.ejb.ConcreteMethod.invoke(ConcreteMethod.java:29)
at com.inprise.ejb.EJBContext.invoke(EJBContext.java:161)
at com.inprise.ejb.Dispatcher.doInvoke(Dispatcher.java:1293)
at com.inprise.ejb.Dispatcher.invokeSecurityCheck(Dispatcher.java:1055)
at com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:850)
at com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:665)
at com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:417)
at
com.mansion.ejb.session.TableViewerPOAInvokeHandler.recieveField(TableViewer
POAInvokeHandler.java:34)
at
com.mansion.ejb.session.TableViewerPOAInvokeHandler.recieveField(TableViewer
POAInvokeHandler.java:71)
at com.mansion.ejb.session.TableViewerPOA._invoke(TableViewerPOA.java:61)
at com.mansion.ejb.session.TableViewerPOA._invoke(TableViewerPOA.java:43)
at com.inprise.vbroker.poa.POAImpl.invoke(POAImpl.java:2597)
at
com.inprise.vbroker.poa.ActivationRecord.invoke(ActivationRecord.java:105)
at
com.inprise.vbroker.poa.ServerInterceptorManager$ARWrapper.invoke(ServerInte
rceptorManager.java:95)
at
com.inprise.vbroker.GIOP.GiopProtocolAdapter.doRequest(GiopProtocolAdapter.j
ava:621)
at
com.inprise.vbroker.IIOP.ServerProtocolAdapter.doRequest(ServerProtocolAdapt
er.java:68)
at
com.inprise.vbroker.GIOP.GiopProtocolAdapter.dispatchMessage(GiopProtocolAda
pter.java:833)
at
com.inprise.vbroker.orb.TPDispatcherImpl$TPDispatcher.run(TPDispatcherImpl.j
ava:99)
at com.inprise.vbroker.orb.ThreadPool$PoolWorker.run(ThreadPool.java:76)



thank you1    <<Less

Re: can't start a cloned connection....

Posted By:   Michael_Lapinski  
Posted On:   Wednesday, April 24, 2002 12:40 PM

try to set the property
SelectMethod=cursor
in the jdbc URL
this way you can have multiple statments out of one connection
About | Sitemap | Contact