Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

UNmanaged JBoss Connection Pool wanted!

 
Jon Powell
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic