Hi,
I looked at the ic2 code and think there may be a problem with setting
blobs on prepared statement input parameters, however all my tests so far
work fine.  If you can identify the statements used I would like to see
them, perhaps we can find out if there is an interclient bug. (I think this
may be an interclient bug because interclient is a jdbc 1 driver,
everything is always in a transaction)

There is a debug flag for jaws, but I do not remember how to set it.  You
can probably find it in documentation or by searching the archives.

david jencks

On 2001.06.17 12:07:44 -0400 Lewis Henderson wrote:
> Hi all,
> 
> I have an application working well under MSSQL7 but ported to InterBase 5
> I
> get the following...
> 
> I am calling an EJB method on a Stateful Session Bean with Tx Attr =
> 'Required'. It calls a findByPrimaryKey(key) on a BMP Entity Bean. It
> looks
> as though the ejbStore() is being called outside a Tx!!??
> 
> Is there any way of logging the 'EXACT' sql statements that are being
> called
> here to find out where the problem is?
> 
> Are does InterBase have any 'special needs' ?
> 
> Thx
> 
> Lewis
> 
> interbase.interclient.SQLException: [interclient][interbase] invalid
> transaction handle (expecting explicit transaction start)
> 
>         at interbase.interclient.RecvMessage.createSQLException(Unknown
> Source)
>         at interbase.interclient.RecvMessage.makeSQLException(Unknown
> Source)
>         at interbase.interclient.RecvMessage._$m21(Unknown Source)
>         at interbase.interclient.BlobInput.<init>(Unknown Source)
>         at interbase.interclient.JDBCNet.setBlobString(Unknown Source)
>         at interbase.interclient.PreparedStatement.setString(Unknown
> Source)
>         at
> org.opentools.minerva.jdbc.PreparedStatementInPool.setString(PreparedStateme
> ntInPool.java:182)
>         at com.cf.rt.work.WorkitemBean._$293730(WorkitemBean.java:507)
>         at com.cf.rt.work.WorkitemBean.ejbStore(WorkitemBean.java:162)
>         at java.lang.reflect.Method.invoke(Native Method)
>         at
> org.jboss.ejb.plugins.BMPPersistenceManager.storeEntity(BMPPersistenceManage
> r.java:331)
>         at
> org.jboss.ejb.plugins.EntitySynchronizationInterceptor$InstanceSynchronizati
> on.beforeCompletion(EntitySynchronizationInterceptor.java:342)
>         at org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1228)
>         at org.jboss.tm.TxCapsule.commit(TxCapsule.java:322)
>         at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76)
>         at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
> java:418)
>         at
> org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
>         at
> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
>         at
> org.jboss.ejb.StatefulSessionContainer.invoke(StatefulSessionContainer.java:
> 326)
>         at
> org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI
> nvoker.java:482)
>         at
> org.jboss.ejb.plugins.jrmp.interfaces.StatefulSessionProxy.invoke(StatefulSe
> ssionProxy.java:150)
>         at $Proxy17.readWorkitem(Unknown Source)
>         at
> com.cf.rt.client.WfoWorkflowHelper.readWorkitem(WfoWorkflowHelper.java:127)
>         at
> com.cf.rt.struts.WorkflowAquireAction.perform(WorkflowAquireAction.java:84)
>         at
> org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.ja
> va:1726)
>         at
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1536)
>         at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:491)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>         at
> org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
>         at org.apache.tomcat.core.Handler.service(Handler.java:287)
>         at
> org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
>         at
> org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
> 7)
>         at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
>         at
> org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
> onnectionHandler.java:213)
>         at
> org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
>         at
> org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
>         at java.lang.Thread.run(Thread.java:484)
> 
> 
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
> 


_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to