<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
From Tomcat 6 Spring/JPA/JTA to JBoss EAP 5.1.0
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/fstani">Fabio Schmitz Tani</a> in <i>Beginner's Corner</i> - <a href="http://community.jboss.org/message/563821#563821">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>First of all I'd like to introduce myself, I'm new to posting in this community although I have worked with JBoss AS in the past, in versions 3 and 4, and more recently with Mobicents Sip Servlet with JBoss 4.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>For the past month I've had my first contacts with JBoss AS 5, I was given the task of researching and documenting migration paths from applications deployed in Tomcat 6 to the JBoss AS 5, since the company I'm working for is planning on moving applications from some other application servers including Tomcat 6 (which I know it is not a valid JEE 5 container) and Oracle WebLogic.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Most of their applications so far didn't have the need of a JEE 5 application server, but recently some applications have been leveraging third party libraries to emulate a JEE 5 environment inside tomcat, so the decision was made to instead try to put everything in a more homogeneous environment.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>So far I've been able to overcome most of my problems with some research and testing of environments, but I'm still not there. I am trying to migrate the most recent application that was developed, trying to change mostly the xml configurations and the environment, in order not to generate re-work to the source code of this applications, at least not in an initial phase anyways.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>So getting to the questions, I have had some success configuring some various steps, such as ClassLoading, VFS, Weaving with Snowdrop, TransactionManagement (sort of) with JBoss and JTA.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I think I've covered a lot of ground getting information that was already answered and reading historic links here and there, but I think I'm getting to a point where I would really need to interact with the people who know JBoss the most, since I've been getting to a point where the information I'm getting is either old or outdated. And I'm stumbling on documentation and examples that are probably still linked by google but are probably not the current information on the subject.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>So, right now what I'm trying to solve is working with multiple datasources in a transactional environment with two phase commit.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The basic application background is:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>JBoss As 5.1.0</p><p>Hibernate 3.3.1 - using ClassLoad isolation</p><p>Spring 2.5.6 + Snowdrop 1.0.1 GA - to fix VFS and Weaving</p><p>JTA (In Tomcat was done using JoTM, in JBoss 5 switched to JBossTS)</p><p>MyFaces 1.2.6 + RichFaces 3.0.0 - using the JSF implementation from the WAR, configured in web.xml</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>From what I've been able to dig up so far, JBoss 5, which uses JBossTS, does not support using multiple local-tx-datasources in a war, this being because the old method is broken and does not guarantee ACID, so basically, in the past it was possible to use it like this but it would result in errors, so now it is blocked from being possible to even do this type of configuration.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span>Ok, so the solution that is pointed is to use XA, luckily for me the underlying database is Oracle 10g, so we are able to switch to Oracle XA drivers, so with this I've looked up how to properly set up XA Datasources with Oracle, unfortunately the documentation and the examples include some hints, which appear to be old or not longer needed (You can see it here in this thread: </span><a class="jive-link-thread-small" href="http://community.jboss.org/thread/156044" target="_blank">http://community.jboss.org/thread/156044</a><span>).</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>And I think that's where I'm hitting a wall, I'll post the code for the old local-tx-datasources that would start the application ok, but would throw the two phase commit problem:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre class="jive-pre"><code class="jive-code jive-xml"><span class="jive-xml-tag"><?xml version="1.0" encoding="UTF-8" standalone="yes"?></span>
<span class="jive-xml-tag"><datasources></span>
    <span class="jive-xml-tag"><local-tx-datasource></span>
        <span class="jive-xml-tag"><jndi-name></span>jdbc/Datasource1DS<span class="jive-xml-tag"></jndi-name></span>
        <span class="jive-xml-tag"><rar-name></span>jboss-local-jdbc.rar<span class="jive-xml-tag"></rar-name></span>
        <span class="jive-xml-tag"><use-java-context></span>true<span class="jive-xml-tag"></use-java-context></span>
        <span class="jive-xml-tag"><connection-definition></span>javax.sql.DataSource<span class="jive-xml-tag"></connection-definition></span>
        <span class="jive-xml-tag"><jmx-invoker-name></span>jboss:service=invoker,type=jrmp<span class="jive-xml-tag"></jmx-invoker-name></span>
        <span class="jive-xml-tag"><min-pool-size></span>5<span class="jive-xml-tag"></min-pool-size></span>
        <span class="jive-xml-tag"><max-pool-size></span>20<span class="jive-xml-tag"></max-pool-size></span>
        <span class="jive-xml-tag"><blocking-timeout-millis></span>30000<span class="jive-xml-tag"></blocking-timeout-millis></span>
        <span class="jive-xml-tag"><idle-timeout-minutes></span>30<span class="jive-xml-tag"></idle-timeout-minutes></span>
        <span class="jive-xml-tag"><prefill></span>false<span class="jive-xml-tag"></prefill></span>
        <span class="jive-xml-tag"><background-validation></span>false<span class="jive-xml-tag"></background-validation></span>
        <span class="jive-xml-tag"><background-validation-millis></span>0<span class="jive-xml-tag"></background-validation-millis></span>
        <span class="jive-xml-tag"><validate-on-match></span>true<span class="jive-xml-tag"></validate-on-match></span>
        <span class="jive-xml-tag"><statistics-formatter></span>org.jboss.resource.statistic.pool.JBossDefaultSubPoolStatisticFormatter<span class="jive-xml-tag"></statistics-formatter></span>
        <span class="jive-xml-tag"><isSameRM-override-value></span>false<span class="jive-xml-tag"></isSameRM-override-value></span>
        <span class="jive-xml-tag"><allocation-retry></span>0<span class="jive-xml-tag"></allocation-retry></span>
        <span class="jive-xml-tag"><allocation-retry-wait-millis></span>5000<span class="jive-xml-tag"></allocation-retry-wait-millis></span>
        <span class="jive-xml-tag"><span><security-domain-and-application xsi:type="securityMetaData" xmlns:xsi="</span><a class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a><span>"/></span></span>
        <span class="jive-xml-tag"><metadata></span>
            <span class="jive-xml-tag"><type-mapping></span>Oracle9i<span class="jive-xml-tag"></type-mapping></span>
        <span class="jive-xml-tag"></metadata></span>
        <span class="jive-xml-tag"><local-transaction/></span>
        <span class="jive-xml-tag"><transaction-isolation></span>TRANSACTION_READ_COMMITTED<span class="jive-xml-tag"></transaction-isolation></span>
        <span class="jive-xml-tag"><user-name></span>userName<span class="jive-xml-tag"></user-name></span>
        <span class="jive-xml-tag"><password></span>passWd<span class="jive-xml-tag"></password></span>
        <span class="jive-xml-tag"><check-valid-connection-sql></span>SELECT * FROM DUAL<span class="jive-xml-tag"></check-valid-connection-sql></span>
        <span class="jive-xml-tag"><exception-sorter-class-name></span>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter<span class="jive-xml-tag"></exception-sorter-class-name></span>
        <span class="jive-xml-tag"><prepared-statement-cache-size></span>0<span class="jive-xml-tag"></prepared-statement-cache-size></span>
        <span class="jive-xml-tag"><share-prepared-statements></span>false<span class="jive-xml-tag"></share-prepared-statements></span>
        <span class="jive-xml-tag"><set-tx-query-timeout></span>false<span class="jive-xml-tag"></set-tx-query-timeout></span>
        <span class="jive-xml-tag"><query-timeout></span>0<span class="jive-xml-tag"></query-timeout></span>
        <span class="jive-xml-tag"><use-try-lock></span>60000<span class="jive-xml-tag"></use-try-lock></span>
        <span class="jive-xml-tag"><driver-class></span>oracle.jdbc.driver.OracleDriver<span class="jive-xml-tag"></driver-class></span>
        <span class="jive-xml-tag"><connection-url></span>jdbc:oracle:thin:@oracle-db:1521:schema<span class="jive-xml-tag"></connection-url></span>
    <span class="jive-xml-tag"></local-tx-datasource></span>
<span class="jive-xml-tag"></datasources></span></code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I have two other datasources which have a similar configuration with different schema / username and passwords, and JNDI name.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>So from that I converted it, according to documentation and other threads to:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre class="jive-pre"><code class="jive-code jive-xml"><span class="jive-xml-tag"><?xml version="1.0" encoding="UTF-8" standalone="yes"?></span>
<span class="jive-xml-tag"><datasources></span>
     <span class="jive-xml-tag"><xa-datasource></span>
        <span class="jive-xml-tag"><jndi-name></span>jdbc/Datasource1DS<span class="jive-xml-tag"></jndi-name></span>
        <span class="jive-xml-tag"><track-connection-by-tx></span>true<span class="jive-xml-tag"></track-connection-by-tx></span>
        <span class="jive-xml-tag"><isSameRM-override-value></span>false<span class="jive-xml-tag"></isSameRM-override-value></span>
        <span class="jive-xml-tag"><xa-datasource-class></span>oracle.jdbc.xa.client.OracleXADataSource<span class="jive-xml-tag"></xa-datasource-class></span>
        <span class="jive-xml-tag"><xa-datasource-property name="URL"></span>
            jdbc:oracle:thin:@oracle-db:1521:schema
        <span class="jive-xml-tag"></xa-datasource-property></span>
        <span class="jive-xml-tag"><xa-datasource-property name="User"></span>userName<span class="jive-xml-tag"></xa-datasource-property></span>
        <span class="jive-xml-tag"><xa-datasource-property name="Password"></span>pwd<span class="jive-xml-tag"></xa-datasource-property></span>
        <span class="jive-xml-tag"><exception-sorter-class-name></span>
            org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
        <span class="jive-xml-tag"></exception-sorter-class-name></span>
        <span class="jive-xml-tag"><no-tx-separate-pools/></span>
    <span class="jive-xml-tag"><metadata></span>
            <span class="jive-xml-tag"><type-mapping></span>Oracle9i<span class="jive-xml-tag"></type-mapping></span>
        <span class="jive-xml-tag"></metadata></span>
    <span class="jive-xml-tag"></xa-datasource></span>
    <span class="jive-xml-tag"><xa-datasource></span>
        <span class="jive-xml-tag"><jndi-name></span>jdbc/Datasource2DS<span class="jive-xml-tag"></jndi-name></span>
        <span class="jive-xml-tag"><track-connection-by-tx></span>true<span class="jive-xml-tag"></track-connection-by-tx></span>
        <span class="jive-xml-tag"><isSameRM-override-value></span>false<span class="jive-xml-tag"></isSameRM-override-value></span>
        <span class="jive-xml-tag"><xa-datasource-class></span>oracle.jdbc.xa.client.OracleXADataSource<span class="jive-xml-tag"></xa-datasource-class></span>
        <span class="jive-xml-tag"><xa-datasource-property name="URL"></span>
            jdbc:oracle:thin:@oracle-db:1521:schema
        <span class="jive-xml-tag"></xa-datasource-property></span>
        <span class="jive-xml-tag"><xa-datasource-property name="User"></span>userName2<span class="jive-xml-tag"></xa-datasource-property></span>
        <span class="jive-xml-tag"><xa-datasource-property name="Password"></span>pwd2<span class="jive-xml-tag"></xa-datasource-property></span>
        <span class="jive-xml-tag"><exception-sorter-class-name></span>
            org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
        <span class="jive-xml-tag"></exception-sorter-class-name></span>
        <span class="jive-xml-tag"><no-tx-separate-pools/></span>
    <span class="jive-xml-tag"><metadata></span>
            <span class="jive-xml-tag"><type-mapping></span>Oracle9i<span class="jive-xml-tag"></type-mapping></span>
        <span class="jive-xml-tag"></metadata></span>
    <span class="jive-xml-tag"></xa-datasource></span>
    <span class="jive-xml-tag"><xa-datasource></span>
        <span class="jive-xml-tag"><jndi-name></span>jdbc/Datasource3DS<span class="jive-xml-tag"></jndi-name></span>
        <span class="jive-xml-tag"><track-connection-by-tx></span>true<span class="jive-xml-tag"></track-connection-by-tx></span>
        <span class="jive-xml-tag"><isSameRM-override-value></span>false<span class="jive-xml-tag"></isSameRM-override-value></span>
        <span class="jive-xml-tag"><xa-datasource-class></span>oracle.jdbc.xa.client.OracleXADataSource<span class="jive-xml-tag"></xa-datasource-class></span>
        <span class="jive-xml-tag"><xa-datasource-property name="URL"></span>
            jdbc:oracle:thin:@oracle-db:1521:schema
        <span class="jive-xml-tag"></xa-datasource-property></span>
        <span class="jive-xml-tag"><xa-datasource-property name="User"></span>userName3<span class="jive-xml-tag"></xa-datasource-property></span>
        <span class="jive-xml-tag"><xa-datasource-property name="Password"></span>pwd3<span class="jive-xml-tag"></xa-datasource-property></span>
        <span class="jive-xml-tag"><exception-sorter-class-name></span>
            org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
        <span class="jive-xml-tag"></exception-sorter-class-name></span>
        <span class="jive-xml-tag"><no-tx-separate-pools/></span>
    <span class="jive-xml-tag"><metadata></span>
            <span class="jive-xml-tag"><type-mapping></span>Oracle9i<span class="jive-xml-tag"></type-mapping></span>
        <span class="jive-xml-tag"></metadata></span>
    <span class="jive-xml-tag"></xa-datasource></span>
    <span class="jive-xml-tag"><mbean code="org.jboss.resource.adapter.jdbc.vendor.OracleXAExceptionFormatter" name="jboss.jca:service=OracleXAExceptionFormatter"></span>
        <span class="jive-xml-tag"><depends optional-attribute-name="TransactionManagerService"></span>
            jboss:service=TransactionManager
        <span class="jive-xml-tag"></depends></span>
    <span class="jive-xml-tag"></mbean></span>
<span class="jive-xml-tag"></datasources></span>
</code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I've added all the DS in a single file because of the mbean declaration, which JBoss would complain to be duplicated if I had multiple *-ds.xml files.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Anyways, what happens is that when the application tries to get a connection from the pool, an execption is thrown:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre class="jive-pre"><code class="jive-code jive-java">Caused by: javax.resource.ResourceException: Unable to get managed connection <font color="navy"><b>for</b></font> jdbc/DataSource1DS                                                                                                                                             
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)                                                                                                               
        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:413)                                                                                                                     
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)                                                                                                                 
        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)                                                                                          
        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)                                                                                                                                      
        ... 129 more                                                                                                                                                                                                                       
Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Invalid argument(s) in call)                                                                                
        at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:465)                                                                                                       
        at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:409)                                                                                                      
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:633)                                                                                        
        at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:267)                                                                                                        
        at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:690)                                                                                                     
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)                                                                                                               
        ... 133 more                                                                                                                                                                                                                       
Caused by: java.sql.SQLException: Invalid argument(s) in call                                                                                                                                                                              
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)                                                                                                                                                      
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)                                                                                                                                                      
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)                                                                                                                                                      
        at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:96)                                                                                                                                            
        at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:449)                                                                                                       
        ... 138 more
</code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I've searched a little for solutions but no answer still, the documentation recommends adding a property called Pad = true, on a mbean which appears not to exist on jboss-service.xml, this appears to be stale documentation, I've read somewhere that now it is already set as true by default, but I don't remember where exactly I've read it.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Anyways what I aim is to be able to discuss this issue with the community, and as it goes on I could post the solutions I've found over here, they may be particular to my application or they may be general enough as to help someone else, as some countless others I've found have helped.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Anyone who can throw in their two cents is welcome.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thanks in advance,</p><p>And sorry for doing a long post <span> :D </span></p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/563821#563821">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in Beginner's Corner at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2075">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>