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