- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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>
Views
Replies
Total Likes