Received: by 10.114.88.19 with SMTP id l19mr545300wab.27.1234564078053;
Fri, 13 Feb 2009 14:27:58 -0800 (PST)
Return-Path: <jwgco...@gmail.com>
Received: from rv-out-0708.google.com (rv-out-0708.google.com [209.85.198.242])
by mx.google.com with ESMTP id k19si860waf.0.2009.02.13.14.27.57;
Fri, 13 Feb 2009 14:27:57 -0800 (PST)
Received-SPF: pass (google.com: domain of jwgco...@gmail.com designates 209.85.198.242 as permitted sender) client-ip=209.85.198.242;
Authentication-Results: mx.google.com; spf=pass (google.com: domain of jwgco...@gmail.com designates 209.85.198.242 as permitted sender) smtp.mail=jwgco...@gmail.com; dkim=pass (test mode) header...@gmail.com
Received: by rv-out-0708.google.com with SMTP id c5so790093rvf.48
for <atg_tech@googlegroups.com>; Fri, 13 Feb 2009 14:27:57 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=gamma;
h=domainkey-signature:received:received:message-id:from:to
:in-reply-to:content-type:mime-version:subject:date:references
:x-mailer;
bh=gfdwLzuy2wNM10nWin3LFCp77+OFx4JR+n4A76ABGpI=;
b=SZZjoVPkz2j7MCpplUO8OAE7lHq49FgKZxZCITx+MRfEp6G2hlzV61vdhlA88p2v6a
kKF1rMpbH5ZDlJgTSCD6y74SgV8/IdzqtAlDefiQOdYR2ZmDZlQu4jKQ31TN213CsAGl
FdL/a+vfG0lZaeq0DchLg5+SpLlQjhnU6IxWc=
DomainKey-Signature: a=rsa-sha1; c=nofws;
d=gmail.com; s=gamma;
h=message-id:from:to:in-reply-to:content-type:mime-version:subject
:date:references:x-mailer;
b=Fd1rx9pz+DV74M3wqZWYDr804UDYUIsrzJNBUV2K9NKt1xPkrJlZvksKZ+906u2UlZ
SEtrDwX0LjdZ9eo3GnQqMgnPrf8OquS0WLSmqmiPZLjIgNzO2oZhv19sbiMCHJBbghxL
4gFiWEHSgozR1NrRSF8PXOwrTaRKC8rcsE9Og=
Received: by 10.140.174.20 with SMTP id w20mr351327rve.87.1234564076957;
Fri, 13 Feb 2009 14:27:56 -0800 (PST)
Return-Path: <jwgco...@gmail.com>
Received: from ?192.168.1.193? (c-24-17-188-206.hsd1.wa.comcast.net [24.17.188.206])
by mx.google.com with ESMTPS id b39sm1657064rvf.9.2009.02.13.14.27.55
(version=SSLv3 cipher=RC4-MD5);
Fri, 13 Feb 2009 14:27:56 -0800 (PST)
Message-Id: <AC7A2D45-7949-4718-B73B-AF5254AFD...@gmail.com>
From: Gordon Cooke <jwgco...@gmail.com>
To: atg_tech@googlegroups.com
In-Reply-To: <8E02F8165B86F94593F4AD4BF11B003006324...@MAILSVR.na.ad.atg.com>
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary="Apple-Mail-6-706319858"
Subject: Re: [atg_tech:3024] Re: Problem with Oracle XA data source on JBoss/ATG9
Date: Fri, 13 Feb 2009 14:27:53 -0800
References: <acacc10b0902111450t5c5b763bq4a3b8ce1d462...@mail.gmail.com> <8E02F8165B86F94593F4AD4BF11B003006324...@MAILSVR.na.ad.atg.com> <acacc10b0902121230v68fd987v6332cad587fe...@mail.gmail.com> <8E02F8165B86F94593F4AD4BF11B003006324...@MAILSVR.na.ad.atg.com> <acacc10b0902131332x7fb7e874o68914478d19ed...@mail.gmail.com> <8E02F8165B86F94593F4AD4BF11B003006324...@MAILSVR.na.ad.atg.com>
X-Mailer: Apple Mail (2.930.3)
--Apple-Mail-6-706319858
Content-Type: text/plain
Or simply write a main method that makes a JDBC call. This should be
enough to identify if it is an issue with your DB or the drivers.
From there try running the same code in a web-app in jboss, outside
of ATG. Limit the things that you are actually testing.
gc
On Feb 13, 2009, at 1:53 PM, Belmont, Adam wrote:
> Ok, so just one thread since this is happening at startup like you
> said. So there isn't any contention between processes going on.
> Also this is happening when SQLJMS goes to ask for a connection.
> It hasn't even attempted to build a statement or anything.
>
> If that's the case I'd think that you could reproduce the problem
> with a non-ATG web application that used the same Datasource.
> Just to rule out the basics try a simple non-ATG application that
> just tries to get a connection from your datasource.
> I'd expect that you'd see the same hang on your call to
> "getConnection()".
>
> Not that this helps you solve the problem but it may give you a
> simpler test case to deal with.
>
> Also do you really have two datasources defined that connect to the
> exact database/username combination.
> I assume not, but if so, that could be part of the issue.
> Which one of the datasources is PatchBay (/atg/dynamo/messing/
> MessagingManager component) using for it's datasource?
> Are there other development machines connecting to the exact same
> account elsewhere? Perhaps oracle is complaining because of that.
>
> I saw some interesting info googling on "oracle XA_RETRY JBOSS" but
> nothing stood out. You might find something though.
>
> -- Adam
>
> From: atg_tech@googlegroups.com [mailto:atg_tech@googlegroups.com]
> On Behalf Of Lambert Torres
> Sent: Friday, February 13, 2009 4:33 PM
> To: atg_tech@googlegroups.com
> Subject: [atg_tech:3023] Re: Problem with Oracle XA data source on
> JBoss/ATG9
>
> Thanks for the prompt reply. I've enclosed it.
>
> Lambert
>
> On Fri, Feb 13, 2009 at 11:41 AM, Belmont, Adam <ad...@atg.com> wrote:
> I agree. I don't think the issue is about EAP vs community versions.
> Did you get a stack trace while it was hung (before it times itself
> out) to see what java code was waiting at the time of the problem.
>
> -- Adam
>
> From: atg_tech@googlegroups.com [mailto:atg_tech@googlegroups.com]
> On Behalf Of Lambert Torres
> Sent: Thursday, February 12, 2009 3:30 PM
>
> To: atg_tech@googlegroups.com
> Subject: [atg_tech:3018] Re: Problem with Oracle XA data source on
> JBoss/ATG9
>
> Hi All,
>
> Just wanted to follow up:
>
> We have double and triple checked our ATG database schema, and the
> tables match up with what they should be.
>
> We've made sure that our Java version is the one supported,
> v1.5.0_17, and that our Oracle JDBC driver is the correct one for
> our database: v10.2.0.4. We've tried many permutations of settings
> in the oracle-xa-ds.xml, but every run produces this same behavior:
> The big stack trace in the log after a period of four-five minutes
> of complete unresponsiveness after JBoss startup.
>
> Could this be due to some problem in our database server? Or, does
> this seem like an issue with some other JBoss or ATG9 configuration
> file?
>
> Oh, to comment on the use of JBoss AS 4.2.0GA, we understand that
> only EAS is supported, however another team has explained to us
> that, although we will be running in production and staging with
> EAS, AS should work just fine on developer desktops, and we don't
> have the budget or the need to purchase EAS licenses for every
> developer.
>
> thanks again,
> Lambert
>
>
> On Wed, Feb 11, 2009 at 8:21 PM, Belmont, Adam <ad...@atg.com> wrote:
> Here's what I use:
> <?xml version="1.0" encoding="UTF-8"
> ?>
> <datasources>
> <xa-datasource>
> <jndi-name>atgcore_ds</jndi-name>
> <track-connection-by-tx>false</track-connection-by-tx>
> <isSameRM-override-value>false</isSameRM-override-value>
> <min-pool-size>5</min-pool-size>
> <max-pool-size>100</max-pool-size>
> <blocking-timeout-millis>5000</blocking-timeout-millis>
> <idle-timeout-minutes>15</idle-timeout-minutes>
> <transaction-isolation>TRANSACTION_READ_COMMITTED</
> transaction-isolation>
> <xa-datasource-
> class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
> <xa-datasource-property
> name="URL">jdbc:oracle:thin:@db.company.com:1521:ora10r2</xa-
> datasource-property>
> <xa-datasource-property name="User">scott</xa-datasource-
> property>
> <xa-datasource-property name="Password">tiger</xa-
> datasource-property>
> <!-- Uncomment the following if you are using Oracle 9i
> <xa-datasource-property
> name="oracle.jdbc.V8Compatible">true</xa-datasource-property>
> -->
> <exception-sorter-class-name>
>
> org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
> </exception-sorter-class-name>
> </xa-datasource>
> </datasources>
>
> The "track-connection-by-tx" value looks like it may be different.
> Try getting a thread dump while it's hung to see if multiple java
> threads are involved. If it's just one thread then it could be some
> other process connecting to the db.
> -- Adam
>
> From: atg_tech@googlegroups.com [mailto:atg_tech@googlegroups.com]
> On Behalf Of Lambert Torres
> Sent: Wednesday, February 11, 2009 5:51 PM
> To: atg_tech@googlegroups.com
> Subject: [atg_tech:2998] Problem with Oracle XA data source on JBoss/
> ATG9
>
> Hi again,
>
> Just continuing our migration from atg7 to atg9 and have come up
> with an issue on JBoss with an Oracle XA datasource.
>
> We've configured the oracle-xa-ds.xml as per documentation. The
> system starts up and then hangs unresponsive to requests until 3 or
> 4 minutes later where this gets spit out.
>
> I have included the oracle-xa-ds.xml file below for reference;
> though the host names and ports have been changed, obviously. Any
> help would be much appreciated.
>
> Versions:
> ATG 9.0
> JBoss AS 4.2.0GA
> Oracle 10.2.0.1
> Oracle ojdbc14.jar for 10.2.0.1
> Java 1.5.0_17
> Windows XP SP3
>
> Thanks,
> Lambert
>
>
> 2009-02-11 17:23:14,915 WARN
> [com.arjuna.ats.jta.logging.loggerI18N]
> [com.arjuna.ats.internal.jta.transaction.arjunacore.xastart]
> [com.arjuna.ats.internal.jta.transaction.arjunacore.xastart]
> TransactionImple.enlistResource - xa_start - caught:
> XAException.XA_RETRY for < 131075, 26, 24, 1-ac1b82d:9b3:49934e5c:
> 1c5ac1b82d:9b3:49934e5c:36f
> 2009-02-11 17:23:14,915 ERROR [STDERR]
> oracle.jdbc.xa.OracleXAException
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1101)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:
> 237)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> org
> .jboss
> .resource
> .adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:
> 121)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> org
> .jboss
> .resource
> .connectionmanager
> .xa.JcaXAResourceWrapper.start(JcaXAResourceWrapper.java:113)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> com
> .arjuna
> .ats
> .internal
> .jta
> .transaction
> .arjunacore.TransactionImple.enlistResource(TransactionImple.java:775)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> com
> .arjuna
> .ats
> .internal
> .jta
> .transaction
> .arjunacore.TransactionImple.enlistResource(TransactionImple.java:446)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> org.jboss.resource.connectionmanager.TxConnectionManager
> $TxConnectionEventListener
> $TransactionSynchronization.enlist(TxConnectionManager.java:773)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> org.jboss.resource.connectionmanager.TxConnectionManager
> $TxConnectionEventListener.enlist(TxConnectionManager.java:564)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> org
> .jboss
> .resource
> .connectionmanager
> .TxConnectionManager
> .managedConnectionReconnected(TxConnectionManager.java:337)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> org
> .jboss
> .resource
> .connectionmanager
> .BaseConnectionManager2
> .reconnectManagedConnection(BaseConnectionManager2.java:518)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> org
> .jboss
> .resource
> .connectionmanager
> .BaseConnectionManager2
> .allocateConnection(BaseConnectionManager2.java:399)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> org
> .jboss
> .resource
> .connectionmanager
> .BaseConnectionManager2
> $
> ConnectionManagerProxy
> .allocateConnection(BaseConnectionManager2.java:842)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> org
> .jboss
> .resource
> .adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:
> 88)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> atg.adapter.gsa.GSATransaction.getConnection(GSATransaction.java:725)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> atg
> .adapter.gsa.GSAItemDescriptor.getConnection(GSAItemDescriptor.java:
> 2314)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> atg
> .adapter.gsa.GSAItemDescriptor.executeQuery(GSAItemDescriptor.java:
> 7261)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> atg.adapter.gsa.GSAView.executeUncachedQuery(GSAView.java:317)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> atg.adapter.gsa.GSAView.executeUncachedQuery(GSAView.java:417)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> atg
> .repository.RepositoryViewImpl.executeQuery(RepositoryViewImpl.java:
> 346)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> atg.adapter.gsa.GSAView.executeQuery(GSAView.java:266)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> atg
> .repository.RepositoryViewImpl.executeQuery(RepositoryViewImpl.java:
> 323)
> 2009-02-11 17:23:14,915 ERROR [STDERR] at
> atg
> .repository.RepositoryViewImpl.executeQuery(RepositoryViewImpl.java:
> 246)
> 2009-02-11 17:23:14,931 ERROR [STDERR] at
> atg
> .process
> .ProcessManagerService.findAllMigrations(ProcessManagerService.java:
> 5239)
> 2009-02-11 17:23:14,931 ERROR [STDERR] at
> atg
> .process
> .ProcessManagerService
> .completeAllPendingMigrations(ProcessManagerService.java:10290)
> 2009-02-11 17:23:14,931 ERROR [STDERR] at
> atg
> .process
> .ProcessManagerService
> .initializeProcesses(ProcessManagerService.java:7189)
> 2009-02-11 17:23:14,931 ERROR [STDERR] at
> atg
> .process
> .ProcessManagerService.startMessageSource(ProcessManagerService.java:
> 14388)
> 2009-02-11 17:23:14,931 ERROR [STDERR] at
> atg
> .dms.patchbay.ElementManager.startMessageSource(ElementManager.java:
> 882)
> 2009-02-11 17:23:14,931 ERROR [STDERR] at
> atg
> .dms
> .patchbay.PatchBayManager.startMessageSources(PatchBayManager.java:
> 1941)
> 2009-02-11 17:23:14,931 ERROR [STDERR] at
> atg.dms.patchbay.PatchBayManager.doStartService(PatchBayManager.java:
> 601)
> 2009-02-11 17:23:14,931 ERROR [STDERR] at
> atg.nucleus.GenericService.startService(GenericService.java:496)
>
>
>
>
>
>
>
>
> >
--Apple-Mail-6-706319858
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<html><body style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; -webk=
it-line-break: after-white-space; ">Or simply write a main method that make=
s a JDBC call. This should be enough to identify if it is an issue wi=
th your DB or the drivers. From there try running the same code in a =
web-app in jboss, outside of ATG. Limit the things that you are actua=
lly testing.<div><br></div><div>gc</div><div><br><div><div>On Feb 13, 2009,=
at 1:53 PM, Belmont, Adam wrote:</div><br class=3D"Apple-interchange-newli=
ne"><blockquote type=3D"cite"> <div> <div dir=3D"ltr" align=3D"left"><span =
class=3D"108274121-13022009"><font face=3D"Arial" color=3D"#0000ff" size=3D=
"2">Ok, so just one thread since this is happening at startup like you said=
. So there isn't any contention between processes going on.</font></span></=
div> <div dir=3D"ltr" align=3D"left"><span class=3D"108274121-13022009"><fo=
nt face=3D"Arial" color=3D"#0000ff" size=3D"2">Also this is happening when =
SQLJMS goes to ask for a connection. </font></span></div> <div dir=3D"ltr" =
align=3D"left"><span class=3D"108274121-13022009"><font face=3D"Arial" colo=
r=3D"#0000ff" size=3D"2">It hasn't even attempted to build a statement or a=
nything.</font></span></div> <div dir=3D"ltr" align=3D"left"><span class=3D=
"108274121-13022009"><font face=3D"Arial" color=3D"#0000ff" size=3D"2"></fo=
nt></span> </div> <div dir=3D"ltr" align=3D"left"><span class=3D"10827=
4121-13022009"><font face=3D"Arial" color=3D"#0000ff" size=3D"2">If that's =
the case I'd think that you could reproduce the problem with a non-ATG web =
application that used the same Datasource.</font></span></div> <div dir=3D"=
ltr" align=3D"left"><span class=3D"108274121-13022009"><font face=3D"Arial"=
color=3D"#0000ff" size=3D"2">Just to rule out the basics try a simple non-=
ATG application that just tries to get a connection from your datasource.</=
font></span></div> <div dir=3D"ltr" align=3D"left"><span class=3D"108274121=
-13022009"><font face=3D"Arial" color=3D"#0000ff" size=3D"2">I'd expect tha=
t you'd see the same hang on your call to "getConnection()". </font></span>=
</div> <div dir=3D"ltr" align=3D"left"><span class=3D"108274121-13022009"><=
font face=3D"Arial" color=3D"#0000ff" size=3D"2"></font></span> </div>=
<div dir=3D"ltr" align=3D"left"><span class=3D"108274121-13022009"><font f=
ace=3D"Arial" color=3D"#0000ff" size=3D"2">Not that this helps you solve th=
e problem but it may give you a simpler test case to deal with.</font></spa=
n></div> <div dir=3D"ltr" align=3D"left"><span class=3D"108274121-13022009"=
><font face=3D"Arial" color=3D"#0000ff" size=3D"2"></font></span> </di=
v> <div dir=3D"ltr" align=3D"left"><span class=3D"108274121-13022009"><font=
face=3D"Arial" color=3D"#0000ff" size=3D"2">Also do you really have two da=
tasources defined that connect to the exact database/username combination.<=
/font></span></div> <div dir=3D"ltr" align=3D"left"><span class=3D"10827412=
1-13022009"><font face=3D"Arial" color=3D"#0000ff" size=3D"2">I assume not,=
but if so, that could be part of the issue.</font></span></div> <div dir=
=3D"ltr" align=3D"left"><span class=3D"108274121-13022009"><font face=3D"Ar=
ial" color=3D"#0000ff" size=3D"2">Which one of the datasources is PatchBay =
(/atg/dynamo/messing/MessagingManager component) using for it's datasource?=
</font></span></div> <div dir=3D"ltr" align=3D"left"><span class=3D"1082741=
21-13022009"><font face=3D"Arial" color=3D"#0000ff" size=3D"2">Are there ot=
her development machines connecting to the exact same account elsewhere? Pe=
rhaps oracle is complaining because of that.</font></span></div> <div dir=
=3D"ltr" align=3D"left"><span class=3D"108274121-13022009"><font face=3D"Ar=
ial" color=3D"#0000ff" size=3D"2"></font></span> </div> <div dir=3D"lt=
r" align=3D"left"><span class=3D"108274121-13022009"><font face=3D"Arial" c=
olor=3D"#0000ff" size=3D"2">I saw some interesting info googling on "oracle=
XA_RETRY JBOSS" but nothing stood out. You might find something though.</f=
ont></span></div> <div dir=3D"ltr" align=3D"left"><span class=3D"108274121-=
13022009"><font face=3D"Arial" color=3D"#0000ff" size=3D"2"></font></span>&=
nbsp;</div> <div dir=3D"ltr" align=3D"left"><span class=3D"108274121-130220=
09"><font face=3D"Arial" color=3D"#0000ff" size=3D"2"> -- Adam</font><=
/span></div><br> <div class=3D"OutlookMessageHeader" lang=3D"en-us" dir=3D"=
ltr" align=3D"left"> <hr tabindex=3D"-1"> <font face=3D"Tahoma" size=3D"2">=
<b>From:</b> atg_tech@googlegroups.com [<a href=3D"mailto:atg_tech@googlegr=
oups.com">mailto:atg_tech@googlegroups.com</a>] <b>On Behalf Of </b>Lambert=
Torres<br><b>Sent:</b> Friday, February 13, 2009 4:33 PM<br><b>To:</b> <a =
href=3D"mailto:atg_tech@googlegroups.com">atg_tech@googlegroups.com</a><br>=
<b>Subject:</b> [atg_tech:3023] Re: Problem with Oracle XA data source on J=
Boss/ATG9<br></font><br></div> <div></div>Thanks for the prompt reply. =
; I've enclosed it. <br><br>Lambert<br><br> <div class=3D"gmail_quote=
">On Fri, Feb 13, 2009 at 11:41 AM, Belmont, Adam <span dir=3D"ltr"><<a =
href=3D"mailto:ad...@atg.com">ad...@atg.com</a>></span> wrote:<br> <blockqu=
ote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0=
.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid"> <div> <div dir=3D"ltr" al=
ign=3D"left"><span><font face=3D"Arial" color=3D"#0000ff" size=3D"2">I agre=
e. I don't think the issue is about EAP vs community versions. Did you ge=
t a stack trace while it was hung (before it times itself out) to see wha=
t java code was waiting at the time of the problem.</font></span></div> =
<div dir=3D"ltr" align=3D"left"><span><font face=3D"Arial" color=3D"#0000ff=
" size=3D"2"></font></span> </div> <div dir=3D"ltr" align=3D"left"><s=
pan><font face=3D"Arial" color=3D"#0000ff" size=3D"2">-- Adam</font></spa=
n></div><br> <div lang=3D"en-us" dir=3D"ltr" align=3D"left"> <hr> <font =
face=3D"Tahoma" size=3D"2"> <div class=3D"Ih2E3d"><b>From:</b> <a href=3D"=
mailto:atg_tech@googlegroups.com" target=3D"_blank">atg_t...@googlegroups.c=
om</a> [mailto:<a href=3D"mailto:atg_tech@googlegroups.com" target=3D"_blan=
k">atg_tech@googlegroups.com</a>] <b>On Behalf Of </b>Lambert Torres<br><=
/div><b>Sent:</b> Thursday, February 12, 2009 3:30 PM <div class=3D"Ih2E3d=
"><br><b>To:</b> <a href=3D"mailto:atg_tech@googlegroups.com" target=3D"_bl=
ank">atg_tech@googlegroups.com</a><br></div><b>Subject:</b> [atg_tech:301=
8] Re: Problem with Oracle XA data source on JBoss/ATG9<br></font><br></d=
iv> <div> <div></div> <div class=3D"Wj3C7c"> <div></div>Hi All,<br><br>=
Just wanted to follow up:<br><br><p>We have double and triple checked our A=
TG database schema, and the tables match up with what they should be.</p>=
<p> We've made sure that our Java version is the one supported, v1.5=
.0_17, and that our Oracle JDBC driver is the correct one for our databas=
e: v10.2.0.4. We've tried many permutations of settings in the oracle-xa-=
ds.xml, but every run produces this same behavior: The big stack trace in=
the log after a period of four-five minutes of complete unresponsiveness=
after JBoss startup.</p><p>Could this be due to some problem in our databa=
se server? Or, does this seem like an issue with some other JBoss or ATG9=
configuration file?</p><p> Oh, to comment on the use of JBoss AS 4.2.=
0GA, we understand that only EAS is supported, however another team has e=
xplained to us that, although we will be running in production and stagin=
g with EAS, AS should work just fine on developer desktops, and we don't =
have the budget or the need to purchase EAS licenses for every developer.=
</p>thanks again,<br>Lambert<br><br><br> <div class=3D"gmail_quote">On W=
ed, Feb 11, 2009 at 8:21 PM, Belmont, Adam <span dir=3D"ltr"><<a href=3D=
"mailto:ad...@atg.com" target=3D"_blank">ad...@atg.com</a>></span> wrote:<b=
r> <blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0=
pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid"> <div> <di=
v dir=3D"ltr" align=3D"left"><span><font face=3D"Arial" color=3D"#0000ff" s=
ize=3D"2">Here's what I use:</font></span></div> <div dir=3D"l=
tr" align=3D"left"><span><pre><div><?xml version=3D<span>"1.0"</span> en=
coding=3D<span>"UTF-8"</span></div>?>
<datasources>
<xa-datasource>
<jndi-name>atgcore_ds</jndi-name>
<track-connection-by-tx><span>false</span></track-connectio=
n-by-tx>
<isSameRM-override-value><span>false</span></isSameRM-overr=
ide-value>
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transact=
ion-isolation>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource&=
lt;/xa-datasource-class>
<xa-datasource-property name=3D<span>"URL"</span>>jdbc:oracle:=
thin:@db.company.com:1521:ora10r2</xa-datasource-property>
<xa-datasource-property name=3D<span>"User"</span>>scott</x=
a-datasource-property>
<xa-datasource-property name=3D<span>"Password"</span>>tiger&l=
t;/xa-datasource-property>
<!-- Uncomment the following <span>if</span> you are using Ora=
cle 9i
<xa-datasource-property name=3D<span>"oracle.jdbc.V8Compatible=
"</span>><span>true</span></xa-datasource-property>
-->
<exception-sorter-class-name>
org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
</exception-sorter-class-name>
</xa-datasource>
</datasources></pre><pre> </pre><pre>The "track-connection-by-tx" v=
alue looks like it may be different.</pre><pre>Try getting a thread dump wh=
ile it's hung to see if multiple java threads are involved. If it's just on=
e thread then it could be some other process connecting to the db.</pre><pr=
e> -- Adam</pre></span></div><br> <div lang=3D"en-us" dir=3D"ltr" align=
=3D"left"> <hr> <font face=3D"Tahoma" size=3D"2"><b>From:</b> <a href=
=3D"mailto:atg_tech@googlegroups.com" target=3D"_blank">atg_tech@googlegrou=
ps.com</a> [mailto:<a href=3D"mailto:atg_tech@googlegroups.com" target=3D"_=
blank">atg_tech@googlegroups.com</a>] <b>On Behalf Of </b>Lambert Torre=
s<br><b>Sent:</b> Wednesday, February 11, 2009 5:51 PM<br><b>To:</b> <a hre=
f=3D"mailto:atg_tech@googlegroups.com" target=3D"_blank">atg_tech@googlegro=
ups.com</a><br><b>Subject:</b> [atg_tech:2998] Problem with Oracle XA d=
ata source on JBoss/ATG9<br></font><br></div> <div> <div></div> =
<div> <div></div>Hi again,<br><br>Just continuing our migration from a=
tg7 to atg9 and have come up with an issue on JBoss with an Oracle XA =
datasource.<br><br>We've configured the oracle-xa-ds.xml as per docu=
mentation. The system starts up and then hangs unresponsive to re=
quests until 3 or 4 minutes later where this gets spit out.<br><br>I have =
included the oracle-xa-ds.xml file below for reference; though the host =
names and ports have been changed, obviously. Any help would be much =
appreciated.<br><br>Versions:<br>ATG 9.0<br>JBoss AS 4.2.0GA<br>Oracle =
10.2.0.1<br>Oracle ojdbc14.jar for 10.2.0.1<br>Java 1.5.0_17<br>Windows X=
P SP3<br><br>Thanks,<br>Lambert<br><br><br>2009-02-11 17:23:14,915 WARN=
[com.arjuna.ats.jta.logging.loggerI18N] [com.arjuna.ats.inte=
rnal.jta.transaction.arjunacore.xastart] [com.arjuna.ats.internal.jta.t=
ransaction.arjunacore.xastart] TransactionImple.enlistResource - xa_sta=
rt - caught: XAException.XA_RETRY for < 131075, 26, 24, 1-=
ac1b82d:9b3:49934e5c:1c5ac1b82d:9b3:49934e5c:36f<br>2009-02-11 17:23:14=
,915 ERROR [STDERR] oracle.jdbc.xa.OracleXAException<br>2009-02-11 17:2=
3:14,915 ERROR [STDERR] at oracle.jdbc.xa.OracleXARe=
source.checkError(OracleXAResource.java:1101)<br>2009-02-11 17:23:14,91=
5 ERROR [STDERR] at oracle.jdbc.xa.client.OracleXARe=
source.start(OracleXAResource.java:237)<br>2009-02-11 17:23:14,915 ERRO=
R [STDERR] at org.jboss.resource.adapter.jdbc.xa.XAM=
anagedConnection.start(XAManagedConnection.java:121)<br>2009-02-11 17:2=
3:14,915 ERROR [STDERR] at org.jboss.resource.connec=
tionmanager.xa.JcaXAResourceWrapper.start(JcaXAResourceWrapper.java:113)<br=
>2009-02-11 17:23:14,915 ERROR [STDERR] at com.a=
rjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResour=
ce(TransactionImple.java:775)<br>2009-02-11 17:23:14,915 ERROR [STDERR]=
at com.arjuna.ats.internal.jta.transaction.arjunaco=
re.TransactionImple.enlistResource(TransactionImple.java:446)<br>2009-02-11=
17:23:14,915 ERROR [STDERR] at org.jboss.resour=
ce.connectionmanager.TxConnectionManager$TxConnectionEventListener$Transact=
ionSynchronization.enlist(TxConnectionManager.java:773)<br>2009-02-11 1=
7:23:14,915 ERROR [STDERR] at org.jboss.resource.con=
nectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConne=
ctionManager.java:564)<br>2009-02-11 17:23:14,915 ERROR [STDERR] =
at org.jboss.resource.connectionmanager.TxConnectionManage=
r.managedConnectionReconnected(TxConnectionManager.java:337)<br>2009-02-11 =
17:23:14,915 ERROR [STDERR] at org.jboss.resourc=
e.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseC=
onnectionManager2.java:518)<br>2009-02-11 17:23:14,915 ERROR [STDERR] &=
nbsp; at org.jboss.resource.connectionmanager.BaseConnectio=
nManager2.allocateConnection(BaseConnectionManager2.java:399)<br>2009-02-11=
17:23:14,915 ERROR [STDERR] at org.jboss.resour=
ce.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocate=
Connection(BaseConnectionManager2.java:842)<br>2009-02-11 17:23:14,915 =
ERROR [STDERR] at org.jboss.resource.adapter.jdbc.Wr=
apperDataSource.getConnection(WrapperDataSource.java:88)<br>2009-02-11 =
17:23:14,915 ERROR [STDERR] at atg.adapter.gsa.GSATr=
ansaction.getConnection(GSATransaction.java:725)<br>2009-02-11 17:23:14=
,915 ERROR [STDERR] at atg.adapter.gsa.GSAItemDescri=
ptor.getConnection(GSAItemDescriptor.java:2314)<br>2009-02-11 17:23:14,=
915 ERROR [STDERR] at atg.adapter.gsa.GSAItemDescrip=
tor.executeQuery(GSAItemDescriptor.java:7261)<br>2009-02-11 17:23:14,91=
5 ERROR [STDERR] at atg.adapter.gsa.GSAView.executeU=
ncachedQuery(GSAView.java:317)<br>2009-02-11 17:23:14,915 ERROR [STDERR=
] at atg.adapter.gsa.GSAView.executeUncachedQuery(GS=
AView.java:417)<br>2009-02-11 17:23:14,915 ERROR [STDERR] &=
nbsp; at atg.repository.RepositoryViewImpl.executeQuery(RepositoryViewI=
mpl.java:346)<br>2009-02-11 17:23:14,915 ERROR [STDERR] &nb=
sp; at atg.adapter.gsa.GSAView.executeQuery(GSAView.java:266)<br>2009-0=
2-11 17:23:14,915 ERROR [STDERR] at atg.reposito=
ry.RepositoryViewImpl.executeQuery(RepositoryViewImpl.java:323)<br>2009-02-=
11 17:23:14,915 ERROR [STDERR] at atg.repository=
.RepositoryViewImpl.executeQuery(RepositoryViewImpl.java:246)<br>2009-02-11=
17:23:14,931 ERROR [STDERR] at atg.process.Proc=
essManagerService.findAllMigrations(ProcessManagerService.java:5239)<br>200=
9-02-11 17:23:14,931 ERROR [STDERR] at atg.proce=
ss.ProcessManagerService.completeAllPendingMigrations(ProcessManagerService=
.java:10290)<br>2009-02-11 17:23:14,931 ERROR [STDERR] &nbs=
p; at atg.process.ProcessManagerService.initializeProcesses(ProcessMana=
gerService.java:7189)<br>2009-02-11 17:23:14,931 ERROR [STDERR] &=
nbsp; at atg.process.ProcessManagerService.startMessageSource(Pro=
cessManagerService.java:14388)<br>2009-02-11 17:23:14,931 ERROR [STDERR=
] at atg.dms.patchbay.ElementManager.startMessageSou=
rce(ElementManager.java:882)<br>2009-02-11 17:23:14,931 ERROR [STDERR] =
at atg.dms.patchbay.PatchBayManager.startMessageSour=
ces(PatchBayManager.java:1941)<br>2009-02-11 17:23:14,931 ERROR [STDERR=
] at atg.dms.patchbay.PatchBayManager.doStartService=
(PatchBayManager.java:601)<br>2009-02-11 17:23:14,931 ERROR [STDERR] &n=
bsp; at atg.nucleus.GenericService.startService(GenericServ=
ice.java:496)<br><br><br></div></div> <div><br></div></div></blockquote>=
</div><br><br></div></div></div></blockquote></div><br><br><br> <br> <br></=
div></blockquote></div><br></div></body></html>
--Apple-Mail-6-706319858--
Message from discussion Problem with Oracle XA data source on JBoss/ATG9
| Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy |
| ©2013 Google |