aspose file tools
The moose likes JBoss/WildFly and the fly likes how to get multiple data sources in jboss Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Products » JBoss/WildFly
Reply Bookmark "how to get multiple data sources in jboss" Watch "how to get multiple data sources in jboss" New topic
Author

how to get multiple data sources in jboss

prash sape
Greenhorn

Joined: Jun 17, 2008
Posts: 2
hi all,

i am using jboss 4.2 with oracle 10g.
my application needs connections to two different database.

I tried to configure database different datasources in ./server/default/deploy/oracle-ds.xml as follows


oracle-ds.xml
-------------


can you help me resolve the issue?
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 8212
    
  72

2008-06-17 18:53:35,049 WARN [com.arjuna.ats.jta.logging.loggerI18N] [com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.disallow] [com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.disallow] Adding multiple last resources is disallowed. Current resource is org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@12a801


You probably are using more than one non-XA resource in the same transaction. Are you using the 2 (non-XA) datasources as part of the same transaction?


[My Blog] [JavaRanch Journal]
Binit Kumar
Greenhorn

Joined: Aug 22, 2010
Posts: 9
Hi All,
Even i am facing the same problem and found a solution on the net while googling to tackle this that put a property in the conf/jbossjta-properties.xml as follows:


This works wonder and problem vanishes but My problem is that, my application was working fine earlier with Jboss 4.0.03SP1 but why suddenly this is happening?

I did some Research (Well Almost! ) and i found that it generally happens when you try to access two DataSources simultaneously.
But in my application i am using it but one after another i.e. i am calling the first one taking the data closing the resultset and statement and then calling the second dataSource but still the error.

Can anyone please clarify on this and provide me a solution that i can include in my code.
Or is it okay to just supress the error by including the above property line in the properties file.

Thanks in advance.


AWADHAMBIKA(I)
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: how to get multiple data sources in jboss
 
Similar Threads
JBilling trowing exception with JBoss3.x
EJB3 entity bean
EJB 3.0 : Could not enlist in transaction on entering meta-aware object
Two-Phase commit using CMT on JBoss and Oracle XE
Requesting help in connecting a DataSource(DSSDEV)