File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JBoss/WildFly and the fly likes UNmanaged JBoss Connection Pool wanted! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "UNmanaged JBoss Connection Pool wanted!" Watch "UNmanaged JBoss Connection Pool wanted!" New topic
Author

UNmanaged JBoss Connection Pool wanted!

Jon Powell
Greenhorn

Joined: Aug 05, 2009
Posts: 2
Hi,

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.

Best regards,

Jon
Jon Powell
Greenhorn

Joined: Aug 05, 2009
Posts: 2
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.

Thanks again for any help!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: UNmanaged JBoss Connection Pool wanted!