"Artec" wrote : 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. |
Yes , you can do that . "Artec" wrote : | 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 | Looks like you have broken connection this might happen due because of 1) DB is down for some time .(DB restarts) http://wiki.jboss.org/wiki/Wiki.jsp?page=WhatHappensToJBossIfIRestartTheDatabase 2) Internal DB issue . These broken connections can be resolved by configuring check-valid-connection-sql/exception-sorter-class-name in -ds.xml file Check this http://docs.jboss.org/jbossas/jboss4guide/r5/html/ch7.chapt.html View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4133051#4133051 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4133051 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user