-
1. Re: How do get Oracle Callable Statement?
jonlee Aug 21, 2003 6:36 PM (in response to joshlam)WrappedCallableStatement does not allow access to the underlying CallableStatement object. You would need to get the underlying Oracle connection from the WrappedConnection object - there is a recent post on getting the Oracle specific connection. You would then use this OracleConnection object to create your OracleCallableStatement. There may be transactional ramifications from doing this. YMMV. Use with care.
-
2. Re: How do get Oracle Callable Statement?
joshlam Aug 21, 2003 10:15 PM (in response to joshlam)Thanks. That did the trick.
Where can I find a discussion regarding the WrappedConnection and the transactional ramifications of using the underlying connection?
I bought the jBoss 3.2.1 book but could not find it there. -
3. Re: How do get Oracle Callable Statement?
jonlee Aug 21, 2003 11:03 PM (in response to joshlam)There is no specific discussion on the use of the underlying connection. The wrapped connection is used since EJBs, particularly entity beans work with datasource connections and are themselves transactional.
Say for example you have an EJB call another EJB and both work with writing datasource data. The actions they perform are designed intentionally to be atomic - if either one fails, nothing is committed. If a bean method fails in this EJB transactional chain, the datasource transactions spread throughout that chain are rolled back. The wrapped connection and the wrapped statements, et al perform underlying work to ensure the atomicity.
By using the underlying connection directly, you bypass these controls. -
4. Re: How do get Oracle Callable Statement?
rgk Aug 25, 2003 9:28 AM (in response to joshlam)Interesting.
We implemented this same solution when upgrading from Jboss 2.4 to 3.1 - but have been worried about the use of the underlying connection.
Is there a recommend way to call getCursor without using the underlying connection in jboss 3? -
5. Re: How do get Oracle Callable Statement?
rgk Aug 25, 2003 10:30 AM (in response to joshlam)Sorry,
I found it here: http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=