Re: Error invoking method (IndirectionHandler)
Lemke, Wesley wrote: Anyone have any luck setting up p6spy with Websphere 5.1? This is kind of on-topic because Thomas suggested I try it for debugging the OJB issue. Anyone familiar with this error: [4/15/05 10:07:48:319 CDT] 68779cc2 FreePool E J2CA0046E: Method createManagedConnctionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/AffinityDS, throwing ResourceAllocationException. Original exception: com.ibm.ws.exception.WsException: DSRA8101E: DataSource class cannot be used as one-phase: ClassCastException: com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource I can provide the full stack trace if needed. P6Spy, Jakarta Commons DBCP and similar products that will wrap an existing Connection object in it's own connection wrappers will usually surface these kind of exotic issues in managed environments. This is because managed environments will also try to wrap the Connection object so that global transaction/auto-commit handling etc can be enforced by the management container. We were struggling with this in OJB a while ago where combinations of WebLogic/JBoss/Oracle 10 JDBC driver/P6Spy/DBCP had to be dealt with in X number of ways, where X1 and is somewhat annoyingly high... Your specific exception is thrown when WebSphere is trying to wrap the existing Connection object into a ManagedConnection. Unfortunately I can't help you with any WebSpehere-specifics, but as general hints: * try to disable any caching/optimisations on the JDBC level that WebSphere tries to set on the Connection/DataSource * try different auto-commit and transaction settings in WebSpehere and OJB Hope this gives you some leads as to where to start... If you succeed, please report back to the list as we could put this in the FAQ. P6Spy is really useful when debugging OJB problems. Regards, Martin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Error invoking method (IndirectionHandler)
Anyone have any luck setting up p6spy with Websphere 5.1? This is kind of on-topic because Thomas suggested I try it for debugging the OJB issue. Anyone familiar with this error: [4/15/05 10:07:48:319 CDT] 68779cc2 FreePool E J2CA0046E: Method createManagedConnctionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/AffinityDS, throwing ResourceAllocationException. Original exception: com.ibm.ws.exception.WsException: DSRA8101E: DataSource class cannot be used as one-phase: ClassCastException: com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource I can provide the full stack trace if needed. -Original Message- From: Thomas Dudziak [mailto:[EMAIL PROTECTED] Sent: Thursday, April 14, 2005 2:37 PM To: OJB Users List Subject: Re: Error invoking method (IndirectionHandler) On 4/14/05, Lemke, Wesley [EMAIL PROTECTED] wrote: We are trying to use the dynamic proxy for some of our collections. However, I am getting an error and am unable to tell exactly what the problem is. The invoke method of IndirectHandlerDefaultImpl is saying that it can not invoke a particular method. However, in looking the stack trace, I can not figure out why it is unable to invoke the getSubGroup method. Can someone point me in the correct direction? The relevant portion of our model: ClientRelationship has a collection of NewClientGroups which have a collection of Subgroups. The error is getting created when we are trying to retrieve one subgroup (by it's unique Id) from the NewClientGroup with the getSubGroup(int id) method call. snip Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExcep ti onGenerator.java:270) This is the interesting part. AFAIK it occurs when a SQL statement failed and the jdbc driver tries to disconnect without a rollback. You might want to check the DB2 manuals, and perhaps turn on SQL statement logging (P6Spy or in the DB2 database) to see which SQL statement failed. Tom - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Error invoking method (IndirectionHandler)
On 4/14/05, Lemke, Wesley [EMAIL PROTECTED] wrote: We are trying to use the dynamic proxy for some of our collections. However, I am getting an error and am unable to tell exactly what the problem is. The invoke method of IndirectHandlerDefaultImpl is saying that it can not invoke a particular method. However, in looking the stack trace, I can not figure out why it is unable to invoke the getSubGroup method. Can someone point me in the correct direction? The relevant portion of our model: ClientRelationship has a collection of NewClientGroups which have a collection of Subgroups. The error is getting created when we are trying to retrieve one subgroup (by it's unique Id) from the NewClientGroup with the getSubGroup(int id) method call. snip Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExcepti onGenerator.java:270) This is the interesting part. AFAIK it occurs when a SQL statement failed and the jdbc driver tries to disconnect without a rollback. You might want to check the DB2 manuals, and perhaps turn on SQL statement logging (P6Spy or in the DB2 database) to see which SQL statement failed. Tom - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]