Hi,
I would to know if i can put two different database configuration in the same
datasource file.
For example
<local-tx-datasource>
<jndi-name>BS_DB</jndi-name>
<connection-url>jdbc:oracle:oci8:@xxxx</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>BS</user-name>
BS
<max-pool-size>100</max-pool-size>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>
<local-tx-datasource>
<jndi-name>AS_DB</jndi-name>
<connection-url>jdbc:oracle:oci8:@xxxx</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>BBS</user-name>
BBS
<max-pool-size>100</max-pool-size>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>
My jboss is 3.2.1 and Oracle 8i.
Because sometimes i receive this error in starting mode:
2008-02-20 03:41:06,849 ERROR [org.jboss.mq.pm.jdbc2.PersistenceManager]
Starting failed
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions.
Message recovery may not be accurate; - nested throwable:
(org.jboss.util.NestedSQLException: Could not create connection; - nested
throwable: (java.sql.SQLException: Connection is broken: Connection refused); -
nested throwable: (org.jboss.resource.JBossResourceException: Could not create
connection; - nested throwable: (java.sql.SQLException: Connection is broken:
Connection refused)))
Thanks
Davide
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4132951#4132951
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4132951
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
