I am struggling to put an "unmanaged" (in CMP terms) alongside a managed datasource in our JBoss 4.2.2GA, (Hibernate) SEAM 2.1 application. I want to do plain vanilla JDBC without interference from the JBoss connection manager and will thus take responsbility for managing/closing logical connections retrieved from the JNDI pool. The tables handled by each datasource will be isolated and should not interfere with each other, even though they are on the same database and use the same connection parameters (but different JNDI names).
The DS configuration is as follows:
I am perfectly content to let 'java:/ds1' be managed by SEAM & JBoss, but want to have complete control over 'jdbc/ds2'. In the console I can see ds2 being registered, I can start a JNDI context using 'jdbc/ds2', but get the following errors when trying to set autocommit or do a commit on a connection:
Note that I have carefully wrapped the connection retrieved from the datasource so as to have access to the physical Oracle connection but only close the logical connection.
expresses it really well!
Any help is much appreciated.
Joined: Aug 05, 2009
To add more:
Yes, I have tried the typical SEAM annotations to signify to the container that I will handle transaction management via
at both the calling action class level and down in the class that handles the alternate persistence scheme.