2 Replies Latest reply on Mar 31, 2005 6:55 AM by David Webb

    JBoss Clustered and Oracle Clustered

    Pieter Jacobs Newbie

      Hi all,

      We have a problem at the moment, for we are clustering JBoss as well as Oracle10g. We have created an MBean that are dropped in "deploy" on each of the JBoss clusters :

      <?xml version="1.0" encoding="UTF-8"?>

      <local-tx-datasource>
      <jndi-name>TestDS</jndi-name>
      <connection-url>jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=AORA1A)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=AORA1B)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=QT)))
      </connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>ausername</user-name>
      apassword
      <min-pool-size>0</min-pool-size>
      <max-pool-size>50</max-pool-size>
      <idle-timeout-minutes>2</idle-timeout-minutes>
      <track-statements>false</track-statements>
      </local-tx-datasource>


      The above mentioned works, but every now and again we get the following error; or let me give you the error from the log file :

      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection)

      (Please say if you would like to see the complete stack trace.)
      Now; the above mentioned error comes up as well, as soon as I start up JBoss with <min-pool-size> greater than 0.

      PS : We actually do know why we are getting this (or a theory from our side), but we need to know ho to get around this problem.

      If there is too little information in this Message, please let me know and I'll try and explain it better.

      Thanks all !!

      Pieter