Hi,
I found this thread and that´s exactly the error I am getting.
But, besides all possible fixes discussed here, I cannot understand why JBoss
is using XA if I only have local-tx datasources.
Somebody can give me some info on that?
Thanks in advance.
Marcelo
View the original post :
maralcbr wrote : I cannot understand why JBoss is using XA if I only have
local-tx datasources.
|
What do you mean by this , elaborate the question?
Also raise a separate post for this , don't bloat the post with unrelated query
, it will not help others who might try to search the forums .
hi Vicky,
Follow the link to the new elaborated post:
http://www.jboss.org/index.html?module=bbop=viewtopicp=4137760#4137760
Thanks,
Marcelo
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4137763#4137763
Reply to the post :
UPDATE:
MySQl does support XA now
You have to use mysql-connector-java-5.1.5 or newer for successful XA
integration.
I have copied the example script from docs\examples\jca\oracle-xa-ds.xml
and adapted it to my needs.
Now XA is running perfectly. Besides mysql we are using Oracle XE in our
My results so far:
Oracle XE (Express) can not do XA
Oracle9i will be configured as described above.
With MySql i have not succeded in using XA together with Seam and Jboss AS:-(
So we have decided to set the com.arjuna.ats.jta.allowMultipleLastResources to
true
which is not quite optimal:-(
baz wrote :
| So my next task is to learn how to enable xa for these oracle versions.
| Ciao
| Carsten
All right , but make sure that you update the forums or proabably the JCA wiki
if things do work :)
View the original post :
Now totally clueless.
Found the example definition of an oracle XA datasource in the
docs\examples\jca folder of JBOss As and adapted it:
xa-datasource
| jndi-nameOracle/jndi-name
| track-connection-by-tx/
| isSameRM-override-valuefalse/isSameRM-override-value
|
Try setting pad=true in the jboss-service.xml file , refer to this
http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpAOracleDatasource
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4064845#4064845
Reply to the post :
Thanks for the answer.
After setting pad= true, ithe same(?) exception is raised:
08:59:38,133 INFO [ExperimentSiteList] ExperimentSiteList instantiated by SEAM
| 08:59:38,508 INFO [STDOUT] Hibernate: select experiment0_.ExperimentID as
Experime1_76_, experiment0_.Size as Size76_,
6_, experiment0_.Replications as Replica17_76_ from EXPERIMENT experiment0_
limit ?
| 16:17:17,984 WARN [loggerI18N]
[com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.dis
|
| allow]
[com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.disallow]
Adding
baz wrote : Any help is very appreciated.
| Why does it work with 4.05GA but not with 4.2.0GA?
|
Look at the TransactionManager implementation in the jboss-service.xml it is
configured differently.
Enabling multiple last resource could be configured in the
jbossjta-properties.xml .
Thanks for your time.
When JBoss start a schema validation takes place. This is fully functional
| 10:01:10,643 INFO [SchemaValidator] Running schema validator
| 10:01:10,643 INFO [SchemaValidator] fetching database metadata
| 10:01:10,752 INFO [TableMetadata] table found:
1. The schema validation succeeds. Everytime a transaction comes in play the
error occurs:-(
2. setting com.arjuna.ats.jta.allowMultipleLastResources to true and using two
local-tx-datasource has helped for the moment. But after reading all the docs
vickyk gently pointed, i do want to use xa
baz wrote : For now i do not know why the exception occur.
Which exception are you referring to ?
Are you still getting the exception
Vicky
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4064911#4064911
Reply to the post :
Sorry, The exception is this
baz wrote : Thanks for the answer.
| After setting pad= true, ithe same(?) exception is raised:
| 08:59:38,133 INFO [ExperimentSiteList] ExperimentSiteList instantiated by
SEAM
| | 08:59:38,508 INFO [STDOUT] Hibernate: select experiment0_.ExperimentID
as
baz wrote :
oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1157)
| at
oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:295)
| at
This looks to be appearing from the missing Oracle DB server settings.
Look at the similar issues at here
Thanks for your time.
The links are helpful.
But i can not use the information directly
Have to discover how to enable XA transactions in our oracle databases.
One is Oracle Express (here i can not find the script initxa.sql)
The other is oracle 9i :-( where i do not find either of the scripts.
Any help is very appreciated.
Why does it work with 4.05GA but not with 4.2.0GA?
If a XA-Datasource is relly needed with 4.2.0 how is it configured.
This page: http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigDataSources does not
help me in this context:-(
View the original post :
18 matches
Mail list logo
