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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...