I'm 2.4.4 with MySQL (non-transactional) and everytime I close a connection I simply get the log message
'[INFO,DefaultDS] No transaction right now.'
which makes me think we're not putting connections back into the pool correctly.
The root problem is that we're overloading the DB pool much too easily.
I've placed the jboss.jcml section below. Can anybody please help with this, or is more info needed?
You give the wrong class as JDBC driver in your configuration file.
If you use the two phase commit, your dbfile must be journalized or set as read-only.