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
