Thanks for any help
Tristan Bane
>>>> EJB LOG >>>>
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: java.sql.SQLException: Invalid
handle
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6203)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterInteger(JdbcOdbc.java:890)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
sun.jdbc.odbc.JdbcOdbcPreparedStatement.setInt(JdbcOdbcPreparedStatement.jav
a:539)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.visitransact.jdbc2.PreparedStatementProxy.setInt(PreparedStateme
ntProxy.java:121)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.cmp.JdbcAccessers$11.set(JdbcAccessers.java:267)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.cmp.JdbcManager.findWhatever(JdbcManager.java:936)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.cmp.JdbcManager.findSingle(JdbcManager.java:1059)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.cmp.OneToManyManager.findSingle(OneToManyManager.java:225)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.cmp.CompoundManager.findSingle(CompoundManager.java:632)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.cmp.FieldManager.findSingle(FieldManager.java:357)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.cmp.DefaultManager.findSingle(DefaultManager.java:78)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.cmp.FinderMethod.invoke(FinderMethod.java:37)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.EJBContext.invoke(EJBContext.java:129)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.doInvoke(Dispatcher.java:1055)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:572)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.find(Dispatcher.java:485)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.EntityHome.doFind(EntityHome.java:189)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.EntityHome.find(EntityHome.java:201)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.EJBHome.invoke(EJBHome.java:168)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.GenProduct.NSCLookupInputHomePOAInvokeHandler.findByTrans
Id(NSCLookupInputHomePOAInvokeHandler.java:91)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.GenProduct.NSCLookupInputHomePOAInvokeHandler.findByTrans
Id(NSCLookupInputHomePOAInvokeHandler.java:181)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.GenProduct._NSCLookupInputHome_Stub.findByTransId(_NSCLoo
kupInputHome_Stub.java:177)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.GenProduct.GeneralProductOps.doNSCLookup(GeneralProductOp
s.java:429)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
java.lang.reflect.Method.invoke(Native Method)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.common.SDIMethodInvoker.invoke(SDIMethodInvoker.java:172)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.GenProduct.GeneralProductBean.process(GeneralProductBean.
java:34)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
java.lang.reflect.Method.invoke(Native Method)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.ConcreteMethod.invoke(ConcreteMethod.java:25)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.EJBContext.invoke(EJBContext.java:129)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.doInvoke(Dispatcher.java:1055)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:572)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:548)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:242)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.common.ISDIProductPOAInvokeHandler.process(ISDIProductPOA
InvokeHandler.java:38)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.GenProduct.GeneralProductPOAInvokeHandler.process(General
ProductPOAInvokeHandler.java:32)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.common._ISDIProduct_Stub.process(_ISDIProduct_Stub.java:5
8)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.Delegator.SDIDelegatorBean.process(SDIDelegatorBean.java:
77)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
java.lang.reflect.Method.invoke(Native Method)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.ConcreteMethod.invoke(ConcreteMethod.java:25)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.EJBContext.invoke(EJBContext.java:129)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.doInvoke(Dispatcher.java:1055)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:572)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:548)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:242)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.Delegator.SDIDelegatorPOAInvokeHandler.process(SDIDelegat
orPOAInvokeHandler.java:40)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.Delegator.SDIDelegatorPOAInvokeHandler.process(SDIDelegat
orPOAInvokeHandler.java:88)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.Delegator.SDIDelegatorPOA._invoke(SDIDelegatorPOA.java:67
)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.Delegator.SDIDelegatorPOA._invoke(SDIDelegatorPOA.java:44
)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.vbroker.poa.POAImpl.invoke(POAImpl.java:2355)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.vbroker.poa.ActivationRecord.invoke(ActivationRecord.java:104)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.vbroker.poa.ServerInterceptorManager$ARWrapper.invoke(ServerInte
rceptorManager.java:64)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.vbroker.GIOP.GiopProtocolAdapter.doRequest(GiopProtocolAdapter.j
ava:492)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.vbroker.IIOP.ServerProtocolAdapter.doRequest(ServerProtocolAdapt
er.java:64)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.vbroker.GIOP.GiopProtocolAdapter.dispatchMessage(GiopProtocolAda
pter.java:653)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.vbroker.orb.TPDispatcherImpl$TPDispatcher.run(TPDispatcherImpl.j
ava:99)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.vbroker.orb.ThreadPool$PoolWorker.run(ThreadPool.java:76)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: <<<< EJB LOG <<<<
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: >>>> EJB LOG >>>>
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: Throwing
TransactionRolledbackException for the method: public abstract
com.kainos.SDI.EJB.GenProduct.NSCLookupInput
com.kainos.SDI.EJB.GenProduct.NSCLookupInputHome.findByTransId(int) throws
javax.ejb.FinderException,java.rmi.RemoteException
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: java.rmi.RemoteException:
Could not execute method: findByTransId(int arg1) args: [270] using SQL:
SELECT id, "transId", "max_rows", "nsc", "branchName", "phoneNumber",
"suffix", "organisation", "property", "houseNumber", "locality", "street",
"postTown", "postCode", "county", "createdOn" FROM "ksi_NSCLookup" WHERE
transId = ?; nested exception is:
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: java.sql.SQLException:
Invalid handle
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: java.sql.SQLException: Invalid
handle
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6203)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterInteger(JdbcOdbc.java:890)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
sun.jdbc.odbc.JdbcOdbcPreparedStatement.setInt(JdbcOdbcPreparedStatement.jav
a:539)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.visitransact.jdbc2.PreparedStatementProxy.setInt(PreparedStateme
ntProxy.java:121)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.cmp.JdbcAccessers$11.set(JdbcAccessers.java:267)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.cmp.JdbcManager.findWhatever(JdbcManager.java:936)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.cmp.JdbcManager.findSingle(JdbcManager.java:1059)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.cmp.OneToManyManager.findSingle(OneToManyManager.java:225)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.cmp.CompoundManager.findSingle(CompoundManager.java:632)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.cmp.FieldManager.findSingle(FieldManager.java:357)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.cmp.DefaultManager.findSingle(DefaultManager.java:78)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.cmp.FinderMethod.invoke(FinderMethod.java:37)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.EJBContext.invoke(EJBContext.java:129)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.doInvoke(Dispatcher.java:1055)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:572)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.find(Dispatcher.java:485)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.EntityHome.doFind(EntityHome.java:189)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.EntityHome.find(EntityHome.java:201)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.EJBHome.invoke(EJBHome.java:168)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.GenProduct.NSCLookupInputHomePOAInvokeHandler.findByTrans
Id(NSCLookupInputHomePOAInvokeHandler.java:91)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.GenProduct.NSCLookupInputHomePOAInvokeHandler.findByTrans
Id(NSCLookupInputHomePOAInvokeHandler.java:181)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.GenProduct._NSCLookupInputHome_Stub.findByTransId(_NSCLoo
kupInputHome_Stub.java:177)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.GenProduct.GeneralProductOps.doNSCLookup(GeneralProductOp
s.java:429)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
java.lang.reflect.Method.invoke(Native Method)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.common.SDIMethodInvoker.invoke(SDIMethodInvoker.java:172)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.GenProduct.GeneralProductBean.process(GeneralProductBean.
java:34)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
java.lang.reflect.Method.invoke(Native Method)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.ConcreteMethod.invoke(ConcreteMethod.java:25)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.EJBContext.invoke(EJBContext.java:129)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.doInvoke(Dispatcher.java:1055)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:572)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:548)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:242)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.common.ISDIProductPOAInvokeHandler.process(ISDIProductPOA
InvokeHandler.java:38)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.GenProduct.GeneralProductPOAInvokeHandler.process(General
ProductPOAInvokeHandler.java:32)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.common._ISDIProduct_Stub.process(_ISDIProduct_Stub.java:5
8)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.Delegator.SDIDelegatorBean.process(SDIDelegatorBean.java:
77)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
java.lang.reflect.Method.invoke(Native Method)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.ConcreteMethod.invoke(ConcreteMethod.java:25)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.EJBContext.invoke(EJBContext.java:129)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.doInvoke(Dispatcher.java:1055)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:572)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:548)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.ejb.Dispatcher.invoke(Dispatcher.java:242)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.Delegator.SDIDelegatorPOAInvokeHandler.process(SDIDelegat
orPOAInvokeHandler.java:40)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.Delegator.SDIDelegatorPOAInvokeHandler.process(SDIDelegat
orPOAInvokeHandler.java:88)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.Delegator.SDIDelegatorPOA._invoke(SDIDelegatorPOA.java:67
)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.kainos.SDI.EJB.Delegator.SDIDelegatorPOA._invoke(SDIDelegatorPOA.java:44
)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.vbroker.poa.POAImpl.invoke(POAImpl.java:2355)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.vbroker.poa.ActivationRecord.invoke(ActivationRecord.java:104)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.vbroker.poa.ServerInterceptorManager$ARWrapper.invoke(ServerInte
rceptorManager.java:64)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.vbroker.GIOP.GiopProtocolAdapter.doRequest(GiopProtocolAdapter.j
ava:492)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.vbroker.IIOP.ServerProtocolAdapter.doRequest(ServerProtocolAdapt
er.java:64)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.vbroker.GIOP.GiopProtocolAdapter.dispatchMessage(GiopProtocolAda
pter.java:653)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.vbroker.orb.TPDispatcherImpl$TPDispatcher.run(TPDispatcherImpl.j
ava:99)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: at
com.inprise.vbroker.orb.ThreadPool$PoolWorker.run(ThreadPool.java:76)
[Tue Oct 23 12:56:52 GMT+01:00 2001] stderr: <<<< EJB LOG <<<<