On Wed, Apr 18, 2001 at 09:40:51AM +0200, Jose Ramon Diaz wrote:
> Hi Toby!
>
> Thanks a lot! You were right...
Excellent. I'm responsible for adding some SQLJ to the product at work, so
I'm glad to see it working for other people.
> If anybody is interested the code looks like:
>
> DataSource ds = (DataSource) ctx.lookup("java:/OraclePool");
> c = ds.getConnection();
> DefaultContext cc = new DefaultContext(c);
>
> #sql [cc] { begin... select... }
>
> In this way the connections are not shared beetweten calls to the EJB.
I'm still concerned about this variable "c". It's not declared in that
bit of code, so it looks like it's a member field of the bean class. I'd
make it a local variable unless you have a really good reason.
Toby.
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
