Exception occurred. Internal error: Cannot obtain XAConnection Creation of XAConnection for pool....

Goutam

unread,

Mar 31, 2003, 11:07:56 AM3/31/03

to

From: Goutam <gou...@hotmail.com>
Newsgroups: weblogic.developer.interest.jdbc
Subject: Exception occurred. Internal error: Cannot obtain XAConnection Creation of XAConnection for pool....
References:
NNTP-Posting-Host: 216.148.48.151
X-Original-NNTP-Posting-Host: 216.148.48.151
Message-ID: <3e8867dc$1...@newsgroups.bea.com>
Date: 31 Mar 2003 08:07:56 -0800
X-Trace: newsgroups.bea.com 1049126876 216.148.48.151 (31 Mar 2003 08:07:56 -0800)
X-Original-Trace: 31 Mar 2003 08:07:56 -0800, 216.148.48.151
Organization: BEA NEWS SITE
Lines: 8
XPident: Unknown
Path: newsgroups.bea.com!not-for-mail
Xref: newsgroups.bea.com weblogic.developer.interest.jdbc:16547

Weblogic Server 6.1 SP2 is running fine. But unable to get XAConnections! I am getting following error
java.sql.SQLException: Internal error: Cannot obtain XAConnection Creation of XAConnection for pool ibesXaConnection Pool failed after waitSecs:300
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1063)
at weblogic.jdbc.jta.Connection.getXAConn(Connection.java:148)
at weblogic.jdbc.jta.Connection.prepareStatement(Connection.java:236)
at weblogic.jdbc.rmi.internal.ConnectionImpl.prepareStatement(ConnectionImpl.java:135)
at weblogic.jdbc.rmi.SerialConnection.prepareStatement(SerialConnection.java:76)
-GoutamG

Mitesh Patel

unread,

Mar 31, 2003, 12:02:43 PM3/31/03

to Goutam

Hi Gautam!

Please make sure your refresh minutes is turned off in config.xml. You should put very large value like 999999 for RefreshMinutes parameter for
defination of connectionpool in config.xml instead of 0.

Thanks,
Mitesh

Mitesh Patel

unread,

Mar 31, 2003, 12:15:29 PM3/31/03

to Goutam

Yes you need to specify test table name. If you are using oracle please specify dual.
Thanks,
Mitesh

Goutam wrote:

> Hi Mitesh,
> If I set refreshminutes to some large number, do I need to setup TestTableName too.
> According to Weblogic Help, If TestTableName is not set then the test will not be performed.
> Please let me know.
> Thanks in advance..!

Goutam

unread,

Mar 31, 2003, 11:50:56 AM3/31/03

to

Goutam

unread,

Mar 31, 2003, 12:36:52 PM3/31/03

to

Mitesh,
Thanks! Let me try it. Just a quicky, where do I need to specify dual with regards to Oracle?
-G

goutam

unread,

Mar 31, 2003, 12:58:50 PM3/31/03

to

Mitesh
I would like to know why we need to set RefreshTime interval and how it will solve the problem. Just curious.
Thanks once again!
-Goutam

Mitesh Patel

unread,

Mar 31, 2003, 1:03:53 PM3/31/03

to Goutam

I am showing you example of defination of connection pool in config.xml file.

Properties="oracleXATrace=false;user=samperf1sd;password=xxx;server=tstp817"
RefreshMinutes="5" ShrinkPeriodMinutes="15"
ShrinkingEnabled="true" SupportsLocalTransaction="false"
Targets="smpdomain_4_server" TestConnectionsOnRelease="false"
TestConnectionsOnReserve="false" TestTableName="dual" URL="jdbc:weblogic:oracle"/>

As defined TestTableName="dual" do the same.
You can also do the same thing using weblogic console also.

Thanks,
Mitesh

Mitesh Patel

unread,

Mar 31, 2003, 1:54:37 PM3/31/03

to goutam

If you have refreshminutes to 0, by default weblogic sets it to 5 minutes. So, refreshMinutes kicks off every 5
minutes, at this time if any ideal connection will be grabbed and all will be refreshed one by one. No
connections will be available until all of them are refeshed. That might cause the problem you are seeing.
Thanks,
Mitesh