I also have problem with my DS Configuration...it picks up the teh first settigns from
the mySqldb-ds.xml file..(this is even after changing the classloader settings to
false)
My DS xml file looks like this:
<local-tx-datasource>
<!-- remove this depends tag if you are not using the tcp connection url -->
<jndi-name>fmsDS</jndi-name>
<!-- for tcp connection, allowing other processes to use the hsqldb database -->
<connection-url>jdbc:mysql://172.16.40.9/fms</connection-url>
<!-- for totally in-memory db, not saved when jboss stops. hsql mbean is
unnecessary-->
<!--connection-url>jdbc:hsqldb:.</connection-url-->
<!-- for in-process db, saved when jboss stops. hsql mbean is unnecessary-->
<!--connection-url>jdbc:hsqldb:default-db-name</connection-url-->
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<!--example of how to specify class that determines if exception means
connection should be destroyed-->
<!--exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.DummyExceptionSorter</exception-sorter-class-name-->
<min-pool-size>1</min-pool-size>
<max-pool-size>50</max-pool-size>
</local-tx-datasource>
<local-tx-datasource>
<!-- remove this depends tag if you are not using the tcp connection url -->
<jndi-name>posDS</jndi-name>
<!-- for tcp connection, allowing other processes to use the hsqldb database
-->
<connection-url>jdbc:mysql://172.16.40.9/pos</connection-url>
<!-- for totally in-memory db, not saved when jboss stops. hsql mbean is
unnecessary-->
<!--connection-url>jdbc:hsqldb:.</connection-url-->
<!-- for in-process db, saved when jboss stops. hsql mbean is unnecessary-->
<!--connection-url>jdbc:hsqldb:default-db-name</connection-url-->
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>pos</user-name>
pos
<!--example of how to specify class that determines if exception means
connection should be destroyed-->
<!--exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.DummyExceptionSorter</exception-sorter-class-name-->
<min-pool-size>1</min-pool-size>
<max-pool-size>50</max-pool-size>
</local-tx-datasource>
I am trying to connect to the 2nd Datasource settings
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3845974#3845974
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3845974
-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
