Hi,
This is a general question. Can I use SQLJ with
JBoss? Specifically, can I create SQLJ DefaultContext
using a connection created from JBoss DataSource
and use it to perfoem SQLJ statements? Is it too
much overhead because I suppose to close the
connection after each usage in EJB, which
implies that I have to create DefaultContext
each time I get a connection. Another issue
is the potential conflict of transaction
management between JBoss and SQLJ. I prefer to have
JBoss, not SQLJ, to handle all the transactions.

Or, should I just give up the idea using SQLJ?

Thanks.

hctu