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

[Artec]

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