Re: [JBoss-user] Oracle database pool hangs on 2.1

[Guy Rouillier]

Title: RE: [JBoss-user] Oracle database pool hangs on 2.1

I followed other suggestions on this mailing list and got it to work.  Here are my entries from jboss.jcml.  The first is an addition to an existing entry to add the Oracle driver, while the second is a new one for the pooled connection to Oracle (adjust entries to match your database - "userid" and "password" should not be these literals, but the actual userid and password.)     <!-- JDBC -->   <mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">      <attribute name="Drivers">oracle.jdbc.driver.OracleDriver,org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver</attribute>   </mbean>   <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=OracleDB">     <attribute name="PoolName">OracleDB</attribute>     <attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>     <attribute name="URL">jdbc:oracle:thin:@localhost:1521:homedb</attribute>     <attribute name="JDBCUser">userid</attribute>     <attribute name="Password">password</attribute>   </mbean>   Make sure classes12.zip is in your classpath.  When you start jboss you should see the following (amongst everything else).  The first group are the drivers loading, while the second group is the Oracle pooled connection being set up.   [JDBC provider] Initializing [JDBC provider] Loaded JDBC-driver:oracle.jdbc.driver.OracleDriver [JDBC provider] Loaded JDBC-driver:org.hsql.jdbcDriver [JDBC provider] Loaded JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver [JDBC provider] Initialized [Hypersonic] Initializing [Hypersonic] Initialized [InstantDB] Initializing [InstantDB] Initialized [DefaultDS] Initializing [DefaultDS] Initialized [OracleDB] Initializing [OracleDB] Initialized   [OracleDB] Starting [OracleDB] XA Connection pool OracleDB bound to java:/OracleDB [OracleDB] Started   What are you seeing or not seeing? ----- Original Message ----- From: Bolt, Dave To: [EMAIL PROTECTED] Sent: Monday, March 19, 2001 7:30 PM Subject: RE: [JBoss-user] Oracle database pool hangs on 2.1 I have the drivers in my jboss.jcml file and I get the message that the driver was loaded. But it still hangs. I can connect to the Oracle server from the same machine that I'm running JBoss from (of course I'm using OCI vs. a thin driver) as well. Any other ideas on getting a 2.1 connection pool unstuck? Dave -----Original Message----- From: Bill Burke [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 7:05 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Oracle database pool hangs on 2.1 Make sure you have the oracle drivers in the JdbcProvider section in jboss.jcml.  Also make sure that you have the jdbc jar file in your ClassPathExtension defined in jboss.conf.  Look in ../log/server.log for the message "2001-03-19 02:46:49 [JDBC provider] Loaded JDBC-driver:oracle.jdbc.driver.OracleDriver". Bill Bolt, Dave wrote: > I'm trying to get the 2.1 binary to run with Tomcat and Oracle. The > server boots fine until it tries to start the Oracle connection pool. > Is there any documentation, specific to JBoss 2.1, that describes how > to configure an Oracle connection pool. Most of the stuff on the web > site is for 2.0. > > Dave Bolt > There is always plenty of bandwidth, just none for you. > _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user