[jboss-user] [Beginner's Corner] - JDBC inside CMT

[Wolf-Dieter Fink]

Wolf-Dieter Fink [http://community.jboss.org/people/wdfink] replied to the discussion

"JDBC inside CMT"

To view the discussion, visit: http://community.jboss.org/message/557826#557826

--------------------------------------------------------------
How do you connect?
Do you use a connection out of JBoss connection pool?

If you use plain JDBC, JDBC-connection-parameter and connection handling within the MDB, the DB access will be commited directly after the SQL-statement.
This is without respect whether the MDB call is successful or not (and might not what you want).

If you have to use plain JDBC, use a DataSource and set the MDB CMT to REQUIRED.
In this case the action is only commited if the MDB return without an exception.

--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/557826#557826]

Start a new discussion in Beginner's Corner at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2075]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100818/6b9ca3b9/attachment.html