Hi,
I am having an issue deploying a ha-local-tx-datasource into JBoss 5.0.1 (Java 6 version).
local-tx-datasource works fine but when I deploy a ha datasource nothing seems to happen,
i.e. nothing is logged to console, and the file appears in the web-console, but no
datasource.
This is the xml, from my -ds.xml file:
| <datasources>
| <ha-local-tx-datasource>
| <jndi-name>jdbc/DBConnection</jndi-name>
|
<connection-url>jdbc:oracle:thin:@db1:1521:db1|jdbc:oracle:thin:@db2:1521:db2</connection-url>
| <url-delimiter>|</url-delimiter>
|
| <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
| <user-name>USERNAME</user-name>
| <password>PASSWORD</password>
|
| <!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed
on first use -->
| <min-pool-size>2</min-pool-size>
|
| <!-- The maximum connections in a pool/sub-pool -->
| <max-pool-size>20</max-pool-size>
|
| <!-- sql to call on an existing pooled connection when it is obtained from pool
- the OracleValidConnectionChecker is prefered -->
| <check-valid-connection-sql>select 1 from
dual</check-valid-connection-sql>
|
| <!-- 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>
| -->
|
| </ha-local-tx-datasource>
|
| </datasources>
|
If it helps this file works perfectly in JBoss 4.0.3
Thanks for your help
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4214626#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...