[jboss-user] [Installation, Configuration & DEPLOYMENT] - Re: mapped-name is required for jdbc

[neelesh.parulkar]

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