[jboss-user] [JCA/JBoss] - Re: Oracle DS

[vickyk]

"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