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#4175210
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4175210
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
