I am using a JBoss 4.2.2.GA server using WebServices. In my WebService, I am required to
connect to a relational Database (Oracle 9i), get some data, change some of the existing
data in the Database and then invoke another WebService. A failure to do any of these
things implies that the entire thing should be rolled back i.e., this whole thing is one
atomic transaction.
Since I am a newbie to the server management, I have used JDBC to connect to a database
using :
| Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
|
connection=DriverManager.getConnection("jdbc:oracle:thin:@STD43S28:1521:cdot1","user","pwd");
|
and I am 'COMMIT'ing the transaction only when I get a successful response from
the WebService I invoke.
This approach works but I would like to delegate the responsibility of getting a
connection to the JBoss server and also would like to know if my transaction can be
demarcated by using any JBoss specific feature (like JCA or something) or actually any
server level thing that I have to activate.
I've just found the use of Connection pooling and started to read about the JCA but
was confused when I read that anonymous wrote : JCA is a resource manager integration API
whose goal is to standardize access to non-relational resources
Please inform me of what all I need to know i.e., if JCA will actually help me out in my
quest or is there something else, some MBean that I need to know about. It would be great
if you can suggest a possible framework for my WebService.
Thank you.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4175210#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...