[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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 : http://www.jboss.com/index.html?module=bbop=viewtopicp=4137735#4137735 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4137735 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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 . View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4137752#4137752 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4137752 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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 : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4137763 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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 developing environment. This db does not support XA. For production and Testing we can use a full orace server which does support XA. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4135209#4135209 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4135209 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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:-( View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4072317#4072317 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4072317 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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 : http://www.jboss.com/index.html?module=bbop=viewtopicp=4065284#4065284 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4065284 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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 | xa-datasource-classoracle.jdbc.xa.client.OracleXADataSource/xa-datasource-class | xa-datasource-property name=URLjdbc:oracle:thin:@172.31.10.32:1521:xe/xa-datasource-property | xa-datasource-property name=Usereadb/xa-datasource-property | xa-datasource-property name=Passwordoracle/xa-datasource-property | !-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -- | !--valid-connection-checker-class-nameorg.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker/valid-connection-checker-class-name-- | !-- Oracles XA datasource cannot reuse a connection outside a transaction once enlisted in a global transaction and vice-versa -- | no-tx-separate-pools/ |!-- Checks the Oracle error codes and messages for fatal errors -- | exception-sorter-class-nameorg.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter/exception-sorter-class-name | | !-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -- | metadata | type-mappingOracle9i/type-mapping | /metadata | /xa-datasource | | mbean code=org.jboss.resource.adapter.jdbc.vendor.OracleXAExceptionFormatter | name=jboss.jca:service=OracleXAExceptionFormatter | depends optional-attribute-name=TransactionManagerServicejboss:service=TransactionManager/depends | /mbean | but this results in this exception: 08:20:32,745 INFO [STDOUT] Hibernate: select experiment0_.ExperimentID as Experime1_76_, experiment0_.Size as Size76_, experiment0_.SowingYear as SowingYear76_, experiment0_.Description as Descript4_76_, experiment0_.HarvestYear as HarvestY5_76_, experiment0_.SowingDate as SowingDate76_, experiment0_.AddressCode as AddressC7_76_, experiment0_.AddressFAOCode as AddressF8_76_, experiment0_.PartnerCode as PartnerC9_76_, experiment0_.ProjectCode as Project10_76_, experiment0_.ExperimentCode as Experim11_76_, experiment0_.ExperimentName as Experim12_76_, experiment0_.SiteID as SiteID76_, experiment0_.HarvestDate as Harvest14_76_, experiment0_.Design as Design76_, experiment0_.Samples as Samples76_, experiment0_.Replications as Replica17_76_ from EXPERIMENT experiment0_ limit ? | 08:20:32,916 ERROR [XAManagedConnectionFactory] Start transaction failed for [EMAIL PROTECTED] | 08:20:32,916 WARN [TxConnectionManager] Connection error occured: [EMAIL PROTECTED] [EMAIL PROTECTED] handles=0 lastUse=1184653232885 permit=true trackByTx=true [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] txSync=null] | oracle.jdbc.xa.OracleXAException | at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1157) | at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:295) | at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:121) | at org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper.start(JcaXAResourceWrapper.java:113) | at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:701) | at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:446) | at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.enlist(TxConnectionManager.java:773) | at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:564) | at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:337) | at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:518) | at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:399) | at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842) | at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88) | at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47) | at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423) | at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144) | at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) | Can anyone tell me what is wrong? And given the fact that XA is necessary, where to find
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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 : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4064845 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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_, experiment0_.SowingYear as SowingYear76_, experiment0_.Description as Descript4_76_, experiment0_.HarvestYear as HarvestY5_76_, experiment0_.SowingDate as SowingDate76_, experiment0_.AddressCode as AddressC7_76_, experiment0_.AddressFAOCode as AddressF8_76_, experiment0_.PartnerCode as PartnerC9_76_, experiment0_.ProjectCode as Project10_76_, experiment0_.ExperimentCode as Experim11_76_, experiment0_.ExperimentName as Experim12_76_, experiment0_.SiteID as SiteID76_, experiment0_.HarvestDate as Harvest14_76_, experiment0_.Design as Design76_, experiment0_.Samples as Samples76_, experiment0_.Replications as Replica17_76_ from EXPERIMENT experiment0_ limit ? | 08:59:38,680 ERROR [XAManagedConnectionFactory] Start transaction failed for [EMAIL PROTECTED] | 08:59:38,680 WARN [TxConnectionManager] Connection error occured: [EMAIL PROTECTED] [EMAIL PROTECTED] handles=0 lastUse=1184655578649 permit=true trackByTx=true [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] txSync=null] | oracle.jdbc.xa.OracleXAException | at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1157) | at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:295) | at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:121) | at org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper.start(JcaXAResourceWrapper.java:113) | at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:701) | at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:446) | at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.enlist(TxConnectionManager.java:773) | at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:564) | at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:337) | at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:518) | at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:399) | at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842) | at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88) | at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47) | at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423) | at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144) | at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) | View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4064851#4064851 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4064851 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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 multiple la | | st resources is disallowed Do you still get this exception ? Read this http://wiki.jboss.org/wiki/Wiki.jsp?page=Multiple1PC Can you write a plain jsp application which would do 1) Get the XA oracle ds 2) Obtain the connection 3) Perform simple select on it . Let me now if that works . I am not sure what you are doing in seam related code . View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4064857#4064857 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4064857 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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 . View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4064859#4064859 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4064859 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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: EADB.DESCRIPTOR | 10:01:10,752 INFO [TableMetadata] columns: [descriptorid, descriptor, referenceid, lastsuggestedstage, descriptorcode, genus, bgrccode, firstsuggestedstage, traitcode] | When the url or user/password is changed to an faulty value an connection error is thrown. So i conclude that the datasource is correctly configured. My exception must come from an other reason:-( By now i can not use LRCO. So i am going to set com.arjuna.ats.jta.allowMultipleLastResources to true and try again with two local-tx-datasource. Thanks again. Ciao, Carsten View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4064876#4064876 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4064876 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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 datasources. For now i do not know why the exception occur. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4064886#4064886 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4064886 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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 : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4064911 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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 Experime1_76_, experiment0_.Size as Size76_, experiment0_.SowingYear as SowingYear76_, experiment0_.Description as Descript4_76_, experiment0_.HarvestYear as HarvestY5_76_, experiment0_.SowingDate as SowingDate76_, experiment0_.AddressCode as AddressC7_76_, experiment0_.AddressFAOCode as AddressF8_76_, experiment0_.PartnerCode as PartnerC9_76_, experiment0_.ProjectCode as Project10_76_, experiment0_.ExperimentCode as Experim11_76_, experiment0_.ExperimentName as Experim12_76_, experiment0_.SiteID as SiteID76_, experiment0_.HarvestDate as Harvest14_76_, experiment0_.Design as Design76_, experiment0_.Samples as Samples76_, experiment0_.Replications as Replica17_76_ from EXPERIMENT experiment0_ limit ? | | 08:59:38,680 ERROR [XAManagedConnectionFactory] Start transaction failed for [EMAIL PROTECTED] | | 08:59:38,680 WARN [TxConnectionManager] Connection error occured: [EMAIL PROTECTED] [EMAIL PROTECTED] handles=0 lastUse=1184655578649 permit=true trackByTx=true [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] txSync=null] | | oracle.jdbc.xa.OracleXAException | | at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1157) | | at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:295) | | at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:121) | | at org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper.start(JcaXAResourceWrapper.java:113) | | at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:701) | | at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:446) | | at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.enlist(TxConnectionManager.java:773) | | at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:564) | | at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:337) | | at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:518) | | at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:399) | | at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842) | | at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88) | | at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47) | | at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423) | | at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144) | | at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) | | When i understand it correctly, the connection is reused and should be enlisted in a transaction. This step fails. But why? The sentence you quote belongs to 1.) sorry for the fault:-( View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4064926#4064926 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4064926 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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 http://www-1.ibm.com/support/docview.wss?uid=swg21215890 http://www.atomikos-support.com/forums/viewtopic.php?t=38 Please let me know if this works for you :) View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4065129#4065129 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4065129 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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. So my next task is to learn how to enable xa for these oracle versions. Ciao Carsten View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4065252#4065252 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4065252 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
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 : http://www.jboss.com/index.html?module=bbop=viewtopicp=4064824#4064824 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4064824 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user