Here is snippet from web.xml and -ds.xml respectively:

web.xml:

<resource-ref>
        DB Connection
        <res-ref-name>jdbc/LOYALTY</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
</resource-ref>



hsqldb-ds.xml:

<local-tx-datasource>
               
                     <!-- The jndi name of the DataSource, it is prefixed with 
java:/ -->
                     <!-- Datasources are not available outside the virtual 
machine -->
                     <jndi-name>jdbc/LOYALTY</jndi-name>      
                          
<connection-url>jdbc:mysql://192.168.1.109:3306/LOYALTY</connection-url> 
               
                     <!-- The driver class -->
                     <driver-class>com.mysql.jdbc.Driver</driver-class>
                     <!-- The login and password -->
                     <user-name>root</user-name>
                     root
                     <!-- The maximum connections in a pool/sub-pool -->
                     <max-pool-size>5</max-pool-size>
                     <!-- track unclosed statements -->
                     <track-statements>true</track-statements>
               
                  <!-- REQUIRED IN JBOSS 4.0.5GA; TRYING IN JBOSS 3.2.5 FOR 
CONSISTENCY -->
                
                        <type-mapping>mySQL</type-mapping>
                                 
   </local-tx-datasource>


I am facing same problem with Jboss 5.1.0 GA. However I am able to deploy the 
war on 4.2.3 GA successfully. Only change in web.xml being a wrapper tag around 
resource-ref as <jboss-web>. This is not required in Jboss 5.x.x as this gives 
invalid schema related errors.











View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4243654#4243654

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4243654
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to