This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
The moose likes EJB and other Java EE Technologies and the fly likes connection pooling Jboss 3.0 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Introducing JavaFX 8 Programming this week in the JavaFX forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "connection pooling Jboss 3.0" Watch "connection pooling Jboss 3.0" New topic

connection pooling Jboss 3.0

Arijit Ghosh
Ranch Hand

Joined: Feb 01, 2002
Posts: 174
I am using Jboss 3.0 with Castor JDO. Struts -> Stateless Session Bean --> Castor JDO
I am using container managed transaction and trying to impement connection pooling. I have included the oracle-service.xml file.
Everytime I am connecting to the database, a new conneciton is being created. If I set the MaxSize to 3 then after 3 successful
connections, it gives an error ---
"No Managed Connection"
Any suggestions ? Any other file that needs to be changed ?

<?xml version="1.0" encoding="UTF-8"?>
<mbean code="org.jboss.resource.connectionmanager.LocalTxConnectionManager"
<depends optional-attribute-name="ManagedConnectionFactoryName">
<mbean code="org.jboss.resource.connectionmanager.RARDeployment" name="jboss.jca:service=LocalTxDS,name=OracleDS">
<attribute name="JndiName">OracleDS</attribute>
<attribute name="ManagedConnectionFactoryProperties">
<config-property name="ConnectionURL"
type="java.lang.String">jdbc racle:thin:@ RCL</config-property>
<config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>
<!--set these only if you want only default logins, not through JAAS -->
<config-property name="UserName" type="java.lang.String">overseer2</config-property>
<config-property name="Password" type="java.lang.String">overseer</config-property>
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC

<depends optional-attribute-name="ManagedConnectionPool">
<mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool"
<attribute name="MinSize">0</attribute>
<attribute name="MaxSize">3</attribute>
<attribute name="BlockingTimeoutMillis">5000</attribute>
<attribute name="IdleTimeoutMinutes">15</attribute>
<attribute name="Criteria">ByContainer</attribute>
<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager</depends>
<depends optional-attribute-name="JaasSecurityManagerService"></depends>
<attribute name="TransactionManager">java:/TransactionManager</attribute>

Thanks in advance.

Regards,<br /> Arijit
I agree. Here's the link:
subject: connection pooling Jboss 3.0
It's not a secret anymore!