This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan 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 Android Security Essentials Live Lessons this week in the Android 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
Author

connection pooling Jboss 3.0

Arijit Ghosh
Ranch Hand

Joined: Feb 01, 2002
Posts: 174
Hi,
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 ?

oracle-service.xml
<?xml version="1.0" encoding="UTF-8"?>
<server>
<mbean code="org.jboss.resource.connectionmanager.LocalTxConnectionManager"
name="jboss.jca:service=LocalTxCM,name=OracleDS">
<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">
<properties>
<config-property name="ConnectionURL"
type="java.lang.String">jdbc racle:thin:@192.168.0.124:2000 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>
</properties>
</attribute>
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC
Wrapper</depends>
</mbean>
</depends>

<depends optional-attribute-name="ManagedConnectionPool">
<mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool"
name="jboss.jca:service=LocalTxPool,name=OracleDS">
<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>
</mbean>
</depends>
<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager</depends>
<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:name=JaasSecurityManager</depends>
<attribute name="TransactionManager">java:/TransactionManager</attribute>
<depends>jboss.jca:service=RARDeployer</depends>
</mbean>
</server>

Thanks in advance.


Regards,<br /> Arijit
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: connection pooling Jboss 3.0
 
Similar Threads
Jboss and Oracle
No 'jboss' MBeanServer found !
Jboss-interbase error
MS Access in JBoss 3.0.8
Problem in putting a dataSource for the Oracle 9i database on JBoss for entity beans