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

Dismiss

Problem when refreshing connection after network/DB goes down

17 views

Skip to first unread message

Benoit Campeau

unread,

Jul 24, 2002, 2:54:50 PM7/24/02

Hi,

We are using WL 6.1 Sp2 with two XADatasource pointing on two MS SQL DB. (We
use JSQLConnect driver).

Before we split the database we were using regular Datasource and when the network
or the DB went down... WL restored the connections perfeclty after we put them
up again. (with the testconnection set to true..)

But now, with the XADatasource it doesnt work anymore... if the network or DB
crash.. we cant access our application.. The only way to restore everything is
to restart WL, witch is not acceptable... ;(

We tried to install the SP3 but it doesnt fix the problem...

So, we dont know what to do now....

Any help would be very appreciated....

Benoit Campeau
JE22 Developer

Sree Bodapati

unread,

Jul 24, 2002, 4:46:15 PM7/24/02

Do you see any exceptions in the shell where you have started the server or
in the logs?

/
sree

"Benoit Campeau" <campeau...@hotmail.com> wrote in message
news:3d3ef7fa$1...@newsgroups.bea.com...

Benoit Campeau

unread,

Jul 25, 2002, 10:29:17 AM7/25/02

Yes, i put the txt file in att.

you will see that WL says that the connections have been refreshed... but they
are NOT... there is an error saying that the select from the testConnection failed...!!!

Benoit Campeau

unread,

Jul 25, 2002, 10:33:15 AM7/25/02

Sorry.. tha attachment didnt work...
here is the full text ..

BEGIN------------------------------------------------------------
javax.ejb.EJBException
- with nested exception:
[javax.transaction.HeuristicMixedException]
at weblogic.ejb20.internal.BaseEJBLocalObject.postInvoke(BaseEJBLocalObject.java:214)
at com.labtronix.components.ejb.logon.LogonBean_17tfr7_ELOImpl.checkBlackList(LogonBean_17tfr7_ELOImpl.java:236)
at com.labtronix.components.servlet.logon.LogonServlet.checkBlackList(LogonServlet.java:507)
at com.labtronix.components.servlet.logon.LogonServlet.doPost(LogonServlet.java:151)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:265)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2495)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2204)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException: Connection
reset by peer: socket write error
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.aq.a(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.int(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.sendStartTran(Unknown Source)
at com.jnetdirect.jsql.JSQLXAResource.start(Unknown Source)
at weblogic.transaction.internal.ServerResourceInfo.start(ServerResourceInfo.java:1032)
at weblogic.transaction.internal.ServerResourceInfo.xaStart(ServerResourceInfo.java:975)
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:937)
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)
com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException: Connection
reset by peer: socket write error
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.aq.a(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.int(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.sendStartTran(Unknown Source)
at com.jnetdirect.jsql.JSQLXAResource.start(Unknown Source)
at weblogic.transaction.internal.ServerResourceInfo.start(ServerResourceInfo.java:1032)
at weblogic.transaction.internal.ServerResourceInfo.xaStart(ServerResourceInfo.java:975)
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:937)
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)<Jul
25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool
GSConnectionPool> <A connection from pool GSConnectionPool was tested during
reserve with a select count(*) from casinos and failed:
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool> <javax.transaction.SystemException:
start() failed on resource 'com.jnetd
irect.jsql.JSQLXAResource' com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException:
Connection reset by peer: socket wri
te error
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:937)
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)
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool> <This connection
will now be refreshed.>

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)
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool MSConnectionPool> <A connection
from pool MSConnectionPool was tested during reserve with a
select count(*) from casinos and failed:
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool MSConnectionPool> <javax.transaction.SystemException:
start() failed on resource 'com.jnetd
irect.jsql.JSQLXAResource' com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException:
Connection reset by peer: socket wri
te error
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:937)
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)
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool MSConnectionPool> <This connection
will now be refreshed.>
com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException: Connection
reset by peer: socket write error
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.aq.a(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.new(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.close(Unknown Source)
at com.jnetdirect.jsql.JSQLPooledConnection.close(Unknown Source)
at weblogic.jdbc.jta.XAConnection.close(XAConnection.java:361)
at weblogic.jdbc.common.internal.XAConnectionEnvFactory.refreshResource(XAConnectionEnvFactory.java:87)
at weblogic.jdbc.common.internal.ConnectionEnv.refresh(ConnectionEnv.java:893)
at weblogic.common.internal.ResourceAllocator.resetThisOne(ResourceAllocator.java:863)
at weblogic.common.internal.ResourceAllocator.reserve(ResourceAllocator.java:481)
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)
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC> <Connection for XA pool "GSConnectionPool"
refreshed.>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC> <Connection for XA pool "MSConnectionPool"
refreshed.>
com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException: Connection
reset by peer: socket write error
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.aq.a(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.int(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.sendStartTran(Unknown Source)
at com.jnetdirect.jsql.JSQLXAResource.start(Unknown Source)
at weblogic.transaction.internal.ServerResourceInfo.start(ServerResourceInfo.java:1032)
at weblogic.transaction.internal.ServerResourceInfo.xaStart(ServerResourceInfo.java:975)
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:937)
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)
com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException: Connection
reset by peer: socket write error
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.aq.a(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.int(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.sendStartTran(Unknown Source)
at com.jnetdirect.jsql.JSQLXAResource.start(Unknown Source)
at weblogic.transaction.internal.ServerResourceInfo.start(ServerResourceInfo.java:1032)
at weblogic.transaction.internal.ServerResourceInfo.xaStart(ServerResourceInfo.java:975)
at weblogic.transaction.internal.ServerResourceInfo.enlist(ServerResourceInfo.java:234)
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool MSConnectionPool> <A connection
from pool MSConnectionPool was tested during reserve with a
select count(*) from casinos and failed:
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool MSConnectionPool> <javax.transaction.SystemException:
start() failed on resource 'com.jnetd
irect.jsql.JSQLXAResource' com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException:
Connection reset by peer: socket wri
te error
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:937)
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)
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool MSConnectionPool> <This connection
will now be refreshed.>
at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:374)
at weblogic.jdbc.common.internal.ConnectionEnv.test(ConnectionEnv.java:937)
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)
com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException: Connection
reset by peer: socket write error
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.aq.a(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.new(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.close(Unknown Source)
at com.jnetdirect.jsql.JSQLPooledConnection.close(Unknown Source)
at weblogic.jdbc.jta.XAConnection.close(XAConnection.java:361)
at weblogic.jdbc.common.internal.XAConnectionEnvFactory.refreshResource(XAConnectionEnvFactory.java:87)
at weblogic.jdbc.common.internal.ConnectionEnv.refresh(ConnectionEnv.java:893)
at weblogic.common.internal.ResourceAllocator.resetThisOne(ResourceAllocator.java:863)
at weblogic.common.internal.ResourceAllocator.reserve(ResourceAllocator.java:481)
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)<Jul 25, 2002
10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool> <A co
nnection from pool GSConnectionPool was tested during reserve with a select count(*)
from casinos and failed:
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool> <javax.transaction.SystemException:
start() failed on resource 'com.jnetd
irect.jsql.JSQLXAResource' com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException:
Connection reset by peer: socket wri
te error
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:937)
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)
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool> <This connection
will now be refreshed.>

<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC> <Connection for XA pool "GSConnectionPool"
refreshed.>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC> <Connection for XA pool "MSConnectionPool"
refreshed.>
com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException: Connection
reset by peer: socket write error
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.aq.a(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.int(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.sendStartTran(Unknown Source)
at com.jnetdirect.jsql.JSQLXAResource.start(Unknown Source)
at weblogic.transaction.internal.ServerResourceInfo.start(ServerResourceInfo.java:1032)
at weblogic.transaction.internal.ServerResourceInfo.xaStart(ServerResourceInfo.java:975)
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:937)
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)
com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException: Connection
reset by peer: socket write error
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.aq.a(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.int(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.sendStartTran(Unknown Source)
at com.jnetdirect.jsql.JSQLXAResource.start(Unknown Source)
at weblogic.transaction.internal.ServerResourceInfo.start(ServerResourceInfo.java:1032)
at weblogic.transaction.internal.ServerResourceInfo.xaStart(ServerResourceInfo.java:975)
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:937)<Jul
25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnec
tionPool> <A connection from pool GSConnectionPool was tested during reserve with
a select count(*) from casinos and failed:
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool> <javax.transaction.SystemException:
start() failed on resource 'com.jnetd
irect.jsql.JSQLXAResource' com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException:
Connection reset by peer: socket wri
te error
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:937)
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)
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool> <This connection
will now be refreshed.>

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)
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool MSConnectionPool> <A connection
from pool MSConnectionPool was tested during reserve with a
select count(*) from casinos and failed:
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool MSConnectionPool> <javax.transaction.SystemException:
start() failed on resource 'com.jnetd
irect.jsql.JSQLXAResource' com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException:
Connection reset by peer: socket wri
te error
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:937)
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)
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool MSConnectionPool> <This connection
will now be refreshed.>
com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException: Connection
reset by peer: socket write error
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.aq.a(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.new(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.close(Unknown Source)
at com.jnetdirect.jsql.JSQLPooledConnection.close(Unknown Source)
at weblogic.jdbc.jta.XAConnection.close(XAConnection.java:361)
at weblogic.jdbc.common.internal.XAConnectionEnvFactory.refreshResource(XAConnectionEnvFactory.java:87)
at weblogic.jdbc.common.internal.ConnectionEnv.refresh(ConnectionEnv.java:893)
at weblogic.common.internal.ResourceAllocator.resetThisOne(ResourceAllocator.java:863)
at weblogic.common.internal.ResourceAllocator.reserve(ResourceAllocator.java:481)
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)
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC> <Connection for XA pool "GSConnectionPool"
refreshed.>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC> <Connection for XA pool "MSConnectionPool"
refreshed.>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool MSConnectionPool> <A connection
from pool MSConnectionPool was tested during reserve with a
select count(*) from casinos and failed:
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool MSConnectionPool> <javax.transaction.SystemException:
start() failed on resource 'com.jnetd
irect.jsql.JSQLXAResource' Unexpected Exception for XAResource 'com.jnetdirect.jsql.JSQLXAResource':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:937)
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)
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool MSConnectionPool> <This connection
will now be refreshed.>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC> <Connection for XA pool "MSConnectionPool"
refreshed.>
com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException: Connection
reset by peer: socket write error
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.aq.a(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.int(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.sendStartTran(Unknown Source)
at com.jnetdirect.jsql.JSQLXAResource.start(Unknown Source)
at weblogic.transaction.internal.ServerResourceInfo.start(ServerResourceInfo.java:1032)
at weblogic.transaction.internal.ServerResourceInfo.xaStart(ServerResourceInfo.java:975)
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:937)
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)
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool> <A connection
from pool GSConnectionPool was tested during reserve with a
select count(*) from casinos and failed:
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool> <javax.transaction.SystemException:
start() failed on resource 'com.jnetd
irect.jsql.JSQLXAResource' com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException:
Connection reset by peer: socket wri
te error
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:937)
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)
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool> <This connection
will now be refreshed.>
com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException: Connection
reset by peer: socket write error
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.aq.a(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.new(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.close(Unknown Source)
at com.jnetdirect.jsql.JSQLPooledConnection.close(Unknown Source)
at weblogic.jdbc.jta.XAConnection.close(XAConnection.java:361)
at weblogic.jdbc.common.internal.XAConnectionEnvFactory.refreshResource(XAConnectionEnvFactory.java:87)
at weblogic.jdbc.common.internal.ConnectionEnv.refresh(ConnectionEnv.java:893)
at weblogic.common.internal.ResourceAllocator.resetThisOne(ResourceAllocator.java:863)
at weblogic.common.internal.ResourceAllocator.reserve(ResourceAllocator.java:481)
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)
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC> <Connection for XA pool "GSConnectionPool"
refreshed.>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool> <A connection
from pool GSConnectionPool was tested during reserve with a
select count(*) from casinos and failed:
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool> <javax.transaction.SystemException:
start() failed on resource 'com.jnetd
irect.jsql.JSQLXAResource' Unexpected Exception for XAResource 'com.jnetdirect.jsql.JSQLXAResource':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:937)
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)
>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool> <This connection
will now be refreshed.>
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC> <Connection for XA pool "GSConnectionPool"
refreshed.>
com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException: Connection
reset by peer: socket write error
at com.jnetdirect.jsql.h.a(Unknown Source)
at com.jnetdirect.jsql.aq.a(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.int(Unknown Source)
at com.jnetdirect.jsql.JSQLConnection.sendCommit(Unknown Source)
at com.jnetdirect.jsql.JSQLXAResource.commit(Unknown Source)
at weblogic.jdbc.jta.DataSource.commit(DataSource.java:783)
at weblogic.transaction.internal.ServerResourceInfo.commit(ServerResourceInfo.java:1180)
at weblogic.transaction.internal.ServerResourceInfo.commit(ServerResourceInfo.java:419)
at weblogic.transaction.internal.ServerSCInfo.startCommit(ServerSCInfo.java:233)
at weblogic.transaction.internal.ServerTransactionImpl.localCommit(ServerTransactionImpl.java:1397)
at weblogic.transaction.internal.ServerTransactionImpl.globalRetryCommit(ServerTransactionImpl.java:1940)
at weblogic.transaction.internal.ServerTransactionImpl.globalCommit(ServerTransactionImpl.java:1886)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:221)
at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:190)
at weblogic.ejb20.internal.BaseEJBLocalObject.postInvoke(BaseEJBLocalObject.java:207)
at com.labtronix.components.ejb.logon.LogonBean_17tfr7_ELOImpl.checkBlackList(LogonBean_17tfr7_ELOImpl.java:236)
at com.labtronix.components.servlet.logon.LogonServlet.checkBlackList(LogonServlet.java:507)
at com.labtronix.components.servlet.logon.LogonServlet.doPost(LogonServlet.java:151)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:265)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2495)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2204)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
<Jul 25, 2002 10:19:54 AM EDT> <Error> <JTA> <Name=[EJB com.labtronix.components.ejb.logon.LogonBean.checkBlackList(java.lang.String)],Xid=2
14:dbaa105b7f28edb9(2025328),Status=Committed,HeuristicErrorCode=XA_HEURHAZ,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds
since begin=0,
seconds left=120,activeThread=Thread[ExecuteThread: '8' for queue: 'default',5,Thread
Group for Queue: 'default'],ServerResourceInfo[MSConne
ctionPool]=(state=committed,assigned=myserver),SCInfo[mydomain+myserver]=(state=committed),properties=({weblogic.transaction.name=[EJB
com.l
abtronix.components.ejb.logon.LogonBean.checkBlackList(java.lang.String)]}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(Co
ordinatorURL=myserver+10.1.0.201:7001+mydomain+, Resources={})],CoordinatorURL=myserver+10.1.0.201:7001+mydomain+)
completed heuristically:
null>
<Jul 25, 2002 10:19:54 AM EDT> <Error> <EJB> <Exception during commit of transaction
Name=[EJB com.labtronix.components.ejb.logon.LogonBean.
checkBlackList(java.lang.String)],Xid=214:dbaa105b7f28edb9(2025328),Status=Committed,HeuristicErrorCode=XA_HEURHAZ,numRepliesOwedMe=0,numRep
liesOwedOthers=0,seconds since begin=0,seconds left=120,ServerResourceInfo[MSConnectionPool]=(state=committed,assigned=myserver),SCInfo[mydo
main+myserver]=(state=committed),properties=({weblogic.transaction.name=[EJB com.labtronix.components.ejb.logon.LogonBean.checkBlackList(jav
a.lang.String)]}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=myserver+10.1.0.201:7001+mydomain+,
Resources
={})],CoordinatorURL=myserver+10.1.0.201:7001+mydomain+): javax.transaction.HeuristicMixedException
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:237)
at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:190)
at weblogic.ejb20.internal.BaseEJBLocalObject.postInvoke(BaseEJBLocalObject.java:207)
at com.labtronix.components.ejb.logon.LogonBean_17tfr7_ELOImpl.checkBlackList(LogonBean_17tfr7_ELOImpl.java:236)
at com.labtronix.components.servlet.logon.LogonServlet.checkBlackList(LogonServlet.java:507)
at com.labtronix.components.servlet.logon.LogonServlet.doPost(LogonServlet.java:151)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:265)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2495)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2204)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
>
javax.transaction.HeuristicMixedException
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:237)
at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:190)
at weblogic.ejb20.internal.BaseEJBLocalObject.postInvoke(BaseEJBLocalObject.java:207)
at com.labtronix.components.ejb.logon.LogonBean_17tfr7_ELOImpl.checkBlackList(LogonBean_17tfr7_ELOImpl.java:236)
at com.labtronix.components.servlet.logon.LogonServlet.checkBlackList(LogonServlet.java:507)
at com.labtronix.components.servlet.logon.LogonServlet.doPost(LogonServlet.java:151)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:265)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2495)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2204)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
--------------- nested within: ------------------
javax.ejb.EJBException
- with nested exception:
[javax.transaction.HeuristicMixedException]
at weblogic.ejb20.internal.BaseEJBLocalObject.postInvoke(BaseEJBLocalObject.java:214)
at com.labtronix.components.ejb.logon.LogonBean_17tfr7_ELOImpl.checkBlackList(LogonBean_17tfr7_ELOImpl.java:236)
at com.labtronix.components.servlet.logon.LogonServlet.checkBlackList(LogonServlet.java:507)
at com.labtronix.components.servlet.logon.LogonServlet.doPost(LogonServlet.java:151)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:265)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2495)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2204)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
END--------------------------------------------------------------

Sree Bodapati

unread,

Jul 25, 2002, 11:32:39 AM7/25/02

Hi Benoit,

If you look at this stack of messages the connection does seem to
refresh!!!!!!! the last message will have not showed up unless the test
passed. This might be someother problem you are facing.

What seems interesting is you have a HeuristicMixedException , I think you
should post this to the JTA newsgroup as well.
Contact support and see if some patch is available for this, you may quote
CR064232 and see if they can help get you a patch that will resolve sporadic
javax.transaction.HeuristicMixedException at commit.

<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool> <A
connection from pool GSConnectionPool was tested during reserve with a
select count(*) from casinos and failed: >
<Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool>
<javax.transaction.SystemException:

start() failed on resource 'com.jnetdirect.jsql.JSQLXAResource' Unexpected

Exception for XAResource 'com.jnetdirect.jsql.JSQLXAResource':null at
weblogic.transaction.internal.ServerResourceInfo.xaStart(ServerResourceInfo.

java:998)................>

also see

hth
/
sree

"Benoit Campeau" <campeau...@hotmail.com> wrote in message

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

er.java:238)
> at
weblogic.time.common.internal.ScheduledTrigger.execute(ScheduledTrigger.java
:229)<Jul
> 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool
> GSConnectionPool> <A connection from pool GSConnectionPool was tested
during
> reserve with a select count(*) from casinos and failed:
> >
> <Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool>
<javax.transaction.SystemException:
> start() failed on resource 'com.jnetd
> irect.jsql.JSQLXAResource' com.jnetdirect.jsql.u: DBComms::transmit
exception:java.net.SocketException:
> Connection reset by peer: socket wri
> te error
> at
weblogic.transaction.internal.ServerResourceInfo.xaStart(ServerResourceInfo.
java:998)
> at
weblogic.transaction.internal.ServerResourceInfo.enlist(ServerResourceInfo.j
ava:234)
> at
weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTra

nsactionImpl.java:374)
> at
weblogic.jdbc.common.internal.ConnectionEnv.test(ConnectionEnv.java:937)
> at
weblogic.common.internal.ResourceAllocator.reserve(ResourceAllocator.java:46
5)
> at
weblogic.common.internal.ResourceAllocator.reserveUnused(ResourceAllocator.j
ava:376)
> at
weblogic.common.internal.ResourceAllocator.trigger(ResourceAllocator.java:11
03)
> at
weblogic.time.common.internal.ScheduledTrigger.executeLocally(ScheduledTrigg

ava:234)
> <Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool MSConnectionPool> <A
connection
> from pool MSConnectionPool was tested during reserve with a
> select count(*) from casinos and failed:
> >
> <Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool MSConnectionPool>
<javax.transaction.SystemException:
> start() failed on resource 'com.jnetd
> irect.jsql.JSQLXAResource' com.jnetdirect.jsql.u: DBComms::transmit
exception:java.net.SocketException:
> Connection reset by peer: socket wri
> te error
> at
weblogic.transaction.internal.ServerResourceInfo.xaStart(ServerResourceInfo.
java:998)
> at
weblogic.transaction.internal.ServerResourceInfo.enlist(ServerResourceInfo.j
ava:234)
> at
weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTra

er.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)
> com.jnetdirect.jsql.u: DBComms::transmit
exception:java.net.SocketException: Connection
> reset by peer: socket write error
> at com.jnetdirect.jsql.h.a(Unknown Source)
> at com.jnetdirect.jsql.aq.a(Unknown Source)
> at com.jnetdirect.jsql.JSQLConnection.new(Unknown Source)
> at com.jnetdirect.jsql.JSQLConnection.close(Unknown Source)
> at com.jnetdirect.jsql.JSQLPooledConnection.close(Unknown Source)
> at weblogic.jdbc.jta.XAConnection.close(XAConnection.java:361)
> at
weblogic.jdbc.common.internal.XAConnectionEnvFactory.refreshResource(XAConne

ctionEnvFactory.java:87)
> at
weblogic.jdbc.common.internal.ConnectionEnv.refresh(ConnectionEnv.java:893)
> at
weblogic.common.internal.ResourceAllocator.resetThisOne(ResourceAllocator.ja
va:863)
> at
weblogic.common.internal.ResourceAllocator.reserve(ResourceAllocator.java:48
1)
> at
weblogic.common.internal.ResourceAllocator.reserveUnused(ResourceAllocator.j
ava:376)
> at
weblogic.common.internal.ResourceAllocator.trigger(ResourceAllocator.java:11
03)
> at
weblogic.time.common.internal.ScheduledTrigger.executeLocally(ScheduledTrigg

nsactionImpl.java:374)
> at
weblogic.jdbc.common.internal.ConnectionEnv.test(ConnectionEnv.java:937)<Jul
> 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnec
> tionPool> <A connection from pool GSConnectionPool was tested during
reserve with
> a select count(*) from casinos and failed:
> >
> <Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool>
<javax.transaction.SystemException:
> start() failed on resource 'com.jnetd
> irect.jsql.JSQLXAResource' com.jnetdirect.jsql.u: DBComms::transmit
exception:java.net.SocketException:
> Connection reset by peer: socket wri
> te error
> at
weblogic.transaction.internal.ServerResourceInfo.xaStart(ServerResourceInfo.
java:998)
> at
weblogic.transaction.internal.ServerResourceInfo.enlist(ServerResourceInfo.j
ava:234)
> at
weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTra

er.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)
> >
> <Jul 25, 2002 10:19:40 AM EDT> <Info> <JDBC Pool GSConnectionPool> <This
connection
> will now be refreshed.>
> com.jnetdirect.jsql.u: DBComms::transmit
exception:java.net.SocketException: Connection
> reset by peer: socket write error
> at com.jnetdirect.jsql.h.a(Unknown Source)
> at com.jnetdirect.jsql.aq.a(Unknown Source)
> at com.jnetdirect.jsql.JSQLConnection.new(Unknown Source)
> at com.jnetdirect.jsql.JSQLConnection.close(Unknown Source)
> at com.jnetdirect.jsql.JSQLPooledConnection.close(Unknown Source)
> at weblogic.jdbc.jta.XAConnection.close(XAConnection.java:361)
> at
weblogic.jdbc.common.internal.XAConnectionEnvFactory.refreshResource(XAConne

let.java:507)
> at
com.labtronix.components.servlet.logon.LogonServlet.doPost(LogonServlet.java
:151)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:265)
> at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:200)
> at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo

ntext.java:2495)
> at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:2204)
> at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
> at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
> >
> javax.transaction.HeuristicMixedException
> at
weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTra
nsactionImpl.java:237)
> at
weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransaction
Impl.java:190)
> at
weblogic.ejb20.internal.BaseEJBLocalObject.postInvoke(BaseEJBLocalObject.jav
a:207)
> at
com.labtronix.components.ejb.logon.LogonBean_17tfr7_ELOImpl.checkBlackList(L
ogonBean_17tfr7_ELOImpl.java:236)
> at
com.labtronix.components.servlet.logon.LogonServlet.checkBlackList(LogonServ

ntext.java:2495)
> at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:2204)
> at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
> at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
> --------------- nested within: ------------------
> javax.ejb.EJBException
> - with nested exception:
> [javax.transaction.HeuristicMixedException]
> at
weblogic.ejb20.internal.BaseEJBLocalObject.postInvoke(BaseEJBLocalObject.jav
a:214)
> at
com.labtronix.components.ejb.logon.LogonBean_17tfr7_ELOImpl.checkBlackList(L
ogonBean_17tfr7_ELOImpl.java:236)
> at
com.labtronix.components.servlet.logon.LogonServlet.checkBlackList(LogonServ

0 new messages