I have the following file deployed under deploy directory from JBoss and
started up in an "all" configuration. The OS is a SUSE 9.3 and JDK1.5_06
<?xml version="1.0" encoding="UTF-8"?>
| <datasources>
| <local-tx-datasource>
| <jndi-name>RBTDS</jndi-name>
|
<connection-url>jdbc:oracle:thin:@111.111.111.111:1531:XXX</connection-url>
| <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
| <user-name></user-name>
| <password></password>
|
| <!-- The minimum connections in a pool/sub-pool. Pools are lazily
constructed on first use -->
| <min-pool-size>5</min-pool-size>
|
| <!-- The maximum connections in a pool/sub-pool -->
| <max-pool-size>50</max-pool-size>
|
| <!-- The time before an unused connection is destroyed -->
| <!-- NOTE: This is the check period. It will be destroyed somewhere
between 1x and 2x this timeout after last use -->
| <!-- TEMPORARY FIX! - Disable idle connection removal, HSQLDB has a
problem with not reaping threads on closed connections -->
| <idle-timeout-minutes>0</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 prefered
| <check-valid-connection-sql>some arbitrary
sql</check-valid-connection-sql>
| -->
|
| <!--
| <track-statements>true</track-statements>
| -->
|
| <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml
(optional) -->
| <metadata>
| <type-mapping>Oracle9i</type-mapping>
| </metadata>
| </local-tx-datasource>
|
| </datasources>
The datasource is depoyed and can see the JNDI name correctly. Every time
that i'm trying to access the datasource i'm getting the following error:
|
| 2006-06-05 11:45:00,018 INFO [STDOUT] ServiceFee Exception catched:
javax.naming.ConfigurationException: Error reading application resource file
[Root exception is java.io.IOException: Invalid use of destroyed classloader,
UCL destroyed at:]
|
I can access the DefaultDS but not this one from my MBean
this is the code which i'm using:
Context ctx = new InitialContext();
| System.out.println("Datasource set to:"+getDs());
| DataSource ds = (DataSource)ctx.lookup(getDs());
| conn = ds.getConnection();
|
do i need something else to configure in jboss?
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3949029#3949029
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3949029
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
