three identical datasources, two available, one unavailable?!

[sebbay]

Hello,

I am using JBoss 5.1.0 and configured three identical datasources with different JNDI-Names.

datasource RTBSDataSource:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
               
    <no-tx-datasource>
        <jndi-name>RTBSDataSource</jndi-name>

        <connection-url>jdbc:oracle:thin:@xxx:yyy:zzz</connection-url>
        <use-java-context>false</use-java-context>

        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

        <user-name>USR</user-name>
        <password>PWD</password>

        <min-pool-size>5</min-pool-size>
        <max-pool-size>32</max-pool-size>

        <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

        <metadata>
            <type-mapping>Oracle9i</type-mapping>
        </metadata>
    </no-tx-datasource>
               
</datasources>

datasource B1TRANSLATION:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
                
     <no-tx-datasource>
         <jndi-name>B1TRANSLATION</jndi-name>

         <connection-url>jdbc:oracle:thin:@xxx:yyy:zzz</connection-url>
         <use-java-context>false</use-java-context>

         <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

         <user-name>USR</user-name>
         <password>PWD</password>

         <min-pool-size>5</min-pool-size>
         <max-pool-size>32</max-pool-size>

         <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

        <metadata>
             <type-mapping>Oracle9i</type-mapping>
         </metadata>
     </no-tx-datasource>
                
</datasources>

datasource CubeDataSource:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
                
     <no-tx-datasource>
         <jndi-name>CubeDataSource</jndi-name>

         <connection-url>jdbc:oracle:thin:@xxx:yyy:zzz</connection-url>
         <use-java-context>false</use-java-context>

         <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

         <user-name>USR</user-name>
         <password>PWD</password>

         <min-pool-size>5</min-pool-size>
         <max-pool-size>32</max-pool-size>

         <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

        <metadata>
             <type-mapping>Oracle9i</type-mapping>
         </metadata>
     </no-tx-datasource>
                
</datasources>

Has somebody an idea, why the datasources RTBSDataSource and CubeDataSource are in state 'available' and the datasource B1TRANSLATION is in state 'unavailable'?

When starting up JBoss, I get no errors.

Best regards,

sebbay

[peterj]

Offhand, I don't see any difference. But try this: start JBoss AS with only RTBSDataSource and CubeDataSource deployed. Once the "started in xxx seconds" message appears, deploy the B1TRANSLATION and see what shows up in both the console log and server.log. That might give a clue as to what is going on.

Another thing you can check is to turn on monitoring within Oracle and see what, if any, queries are being sent.