Avatar

Level 1

OK, tried the JBoss template example version supplied with JBoss (and tutorial) and same issue.

RDS view does not see the source.

The previous post -ds.xml came from creating a DS in the JBoss Admin console.

Which the admin console shows the data source status as available and the smaller DS attached as unavailable even after JBoss restart.

I also thought I'd try configuring a XA-ds.xml and found out that my Oracle drivers did not contain the oracle.jdbc.xa.client.OracleXADataSource class so no luck there:

Attache sample does not work either (username and pwd **** out for post):

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>HERSDataSource</jndi-name>
    <connection-url>jdbc:oracle:thin:@buf-ont1.ctg.com:1521:orcl</connection-url>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <user-name>******</user-name>
    <password>*******</password>
    <min-pool-size>5</min-pool-size>
    <max-pool-size>20</max-pool-size>
    <idle-timeout-minutes>5</idle-timeout-minutes>
<!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
    <!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->
    <!-- Checks the Oracle error codes and messages for fatal errors -->
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter     </exception-sorter-class-name>
        <!-- sql to call when connection is created
        <new-connection-sql>some arbitrary sql</new-connection-sql>
        -->

        <!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is preferred
        <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
        -->

      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
      <metadata>
         <type-mapping>Oracle9i</type-mapping>
      </metadata>

  </local-tx-datasource>
</datasources>

Incidentally I noticed that the logs do not show any messages that the RDS servlet is even running is there something I need to add to the service-config.xml

in order to see debug messages that may help here?

<filters>

<pattern>Endpoint.*</pattern>

<pattern>Service.*</pattern>

<!-- <pattern>Service.Data.Fiber</pattern>-->

<pattern>Configuration</pattern>

<pattern>Message.*</pattern> <pattern>DataService.*</pattern><pattern>SocketServer.*</pattern>

</filters>