I have expirenced the same problem and I have also gave up and go back to
using Minerva.
----- Original Message -----
From: "Guy Rouillier" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 2:09 PM
Subject: Re: [JBoss-user] Oracle database pool hangs on 2.1
> I don't understand what you are saying. The code works fine under 2.1
with
> Minerva. It does not work with the Oracle XA implementation.
>
> ----- Original Message -----
> From: "Shahar Solomianik" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, March 21, 2001 7:09 AM
> Subject: RE: [JBoss-user] Oracle database pool hangs on 2.1
>
>
> > Its not Oracle problem. the same code works fine under jboss2.0 with
> > minerva.
> > but thanks anyway.
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of Guy
Rouillier
> > Sent: Wednesday, March 21, 2001 7:30 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [JBoss-user] Oracle database pool hangs on 2.1
> >
> >
> > Haven't tried the scrollable results sets. When I tried the Oracle XA
> > implementation, I got all sorts of errors (sorry, don't remember at the
> > moment.) I gave up at the moment and just went with minerva. Did you
> check
> > the Oracle techweb site? Perhaps there is an update to the Oracle
> > implementation.
> >
> > ----- Original Message -----
> > From: Shahar Solomianik <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, March 20, 2001 8:55 AM
> > Subject: RE: [JBoss-user] Oracle database pool hangs on 2.1
> >
> >
> > > Hi.
> > > When I use this configuration (i.e. minerva and not oracle's XA
> > > implementation), I get exceptions when using scrollable result sets.
> > > Do you face the same problem ?
> > >
> > > -----Original Message-----
> > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED]]On Behalf Of Guy
> Rouillier
> > > Sent: Tuesday, March 20, 2001 7:56 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: 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.enhyd
> > > ra.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.XADataSourceImp
> > > l</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
> > >
> > >
> > > _______________________________________________
> > > JBoss-user mailing list
> > > [EMAIL PROTECTED]
> > > http://lists.sourceforge.net/lists/listinfo/jboss-user
> > >
> >
> >
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > http://lists.sourceforge.net/lists/listinfo/jboss-user
> >
> >
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > http://lists.sourceforge.net/lists/listinfo/jboss-user
> >
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
