Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Error configuring the Oracle 8.1.7 XA Thin driver with WLS 6.1 SP1

0 views
Skip to first unread message

Steve Schaber

unread,
Apr 5, 2002, 2:37:47 PM4/5/02
to

I am trying to configure the Oracle 8.1.7.0 thin driver and am getting an SystemException
when the pool tries to test the connection at server startup. It looks like the
start() method is failing. I have put Oracle's Classes12.zip, jndi.zip, and the
jta.zip on the classpath immediately after the weblogic.jar entry. Is this a
classpath issue? Can someone that has this working please help me. Thanks in
advance. Steve

The following is the JDBC Pool entry in the config.xml file:

<JDBCConnectionPool
DriverName="oracle.jdbc.xa.client.OracleXADataSource"
InitialCapacity="0" LoginDelaySeconds="1" MaxCapacity="20"
Name="oraclePoolSun3500XAThin" Properties="user=sschaber;url=jdbc:oracle:thin:@199.191.94.4:1521:ORCLT;password=sschaber;dataSourceName=oraclePoolSun3500XAThin"
RefreshMinutes="5" ShrinkPeriodMinutes="30"
Targets="memphisserver" TestConnectionsOnRelease="true"
TestConnectionsOnReserve="true" TestTableName="Dual" URL="jdbc:oracle:thin:@199.191.94.4:1521:ORCLT"/>

Also, here is the entire exception being thrown:

<Apr 5, 2002 1:33:08 PM CST> <Info> <JDBC Pool oraclePoolSun3500XAThin> <javax.transaction.SystemException:
start() failed on resource 'oracle.jdbc.xa.client.Or
acleXAResource' null
at weblogic.transaction.internal.ServerResourceInfo.xaStart(ServerResourceInfo.java:998)
at weblogic.transaction.internal.ServerResourceInfo.enlist(ServerResourceInfo.java:234)
at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:374)
at weblogic.jdbc.common.internal.ConnectionEnv.test(ConnectionEnv.java:915)
at weblogic.common.internal.ResourceAllocator.trigger(ResourceAllocator.java:1114)
at weblogic.time.common.internal.ScheduledTrigger.executeLocally(ScheduledTrigger.java:238)
at weblogic.time.common.internal.ScheduledTrigger.execute(ScheduledTrigger.java:229)
at weblogic.time.server.ScheduledTrigger.execute(ScheduledTrigger.java:65)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
>
<Apr 5, 2002 1:33:08 PM CST> <Info> <JDBC Pool oraclePoolSun3500XAThin> <This
connection will now be refreshed.>
<Apr 5, 2002 1:33:10 PM CST> <Info> <JDBC> <Connection for XA pool "oraclePoolSun3500XAThin"
refreshed.>
<Apr 5, 2002 1:33:10 PM CST> <Info> <JDBC Pool oraclePoolSun3500XAThin> <A connection
from pool oraclePoolSun3500XAThin was tested during reserve with a select
count(*) from Dual and failed:>
<Apr 5, 2002 1:33:10 PM CST> <Info> <JDBC Pool oraclePoolSun3500XAThin> <javax.transaction.SystemException:
start() failed on resource 'oracle.jdbc.xa.client.Or
acleXAResource' null at weblogic.transaction.internal.ServerResourceInfo.xaStart(ServerResourceInfo.java:998)
at weblogic.transaction.internal.ServerResourceInfo.enlist(ServerResourceInfo.java:234)
at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:374)
at weblogic.jdbc.common.internal.ConnectionEnv.test(ConnectionEnv.java:915)
at weblogic.common.internal.ResourceAllocator.reserve(ResourceAllocator.java:465)
at weblogic.common.internal.ResourceAllocator.reserveUnused(ResourceAllocator.java:376)
at weblogic.common.internal.ResourceAllocator.trigger(ResourceAllocator.java:1103)
at weblogic.time.common.internal.ScheduledTrigger.executeLocally(ScheduledTrigger.java:238)
at weblogic.time.common.internal.ScheduledTrigger.execute(ScheduledTrigger.java:229)
at weblogic.time.server.ScheduledTrigger.execute(ScheduledTrigger.java:65)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
>
<Apr 5, 2002 1:33:10 PM CST> <Info> <JDBC Pool oraclePoolSun3500XAThin> <This
connection will now be refreshed.>

Sree Bodapati

unread,
Apr 5, 2002, 3:20:11 PM4/5/02
to
Put the classes12.zip and other zip files before the weblogic.jar file in
the classpath. ensure that you have the latest classes12.zip file from
oracle.


/
sree

"Steve Schaber" <ssch...@ahslink.com> wrote in message
news:3cadfd0b$1...@newsgroups.bea.com...

Steve Schaber

unread,
Apr 5, 2002, 3:51:39 PM4/5/02
to

I made sure that we have the latest version of the classes12.zip file (8.1.7).
Also, moved the classes12.zip, jndi.zip, and the jta.zip file before the weblogic.jar
file in the classpath. I am still getting the same error.

Steve

Sree Bodapati

unread,
Apr 5, 2002, 4:58:45 PM4/5/02
to
Hi Steve,

I see the initial capacity is set to zero , can you push it up to atleast
few connections and see if it helps, and Let me know.

thanks
/
sree

"Steve Schaber" <ssch...@ahslink.com> wrote in message

news:3cae0e5b$1...@newsgroups.bea.com...

Steve Schaber

unread,
Apr 10, 2002, 11:32:04 AM4/10/02
to

This still does not work for me. I must be missing something here. Any help would
be appreciated.

Thanks,
Steve

>..

>..

0 new messages