hi Wolfgang,
I tried with your advice. but no luck for me there. hmm i should give some more explanatios i suppose. first i have external .xml DB connection file - made from Jboss examples. Looks like so:
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>ecrpDB</jndi-name>
<connection-url>jdbc:oracle:thin:@ecrp2db-test.sigov.si:1521:erpt</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>myuname</user-name>
<password>mypasswd</password>
<min-pool-size>0</min-pool-size>
<max-pool-size>2</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>
</local-tx-datasource>
</datasources>
onward i do some correctons to my META-INF/application.xml file:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE application PUBLIC "-//Sun Microsystems, Inc.//DTD J2EE Application 1.3//EN" "http://java.sun.com/dtd/application_1_3.dtd">
<application id="Application_ID">
<display-name>e-CRP_Portal</display-name>
<module id="EjbModule_1276254105569">
<ejb>e-CRP_Portal_EJB.jar</ejb>
</module>
<module id="WebModule_1276254108583">
<web>
<web-uri>e-CRP_Portal_Web.war</web-uri>
<context-root>ecrpportal</context-root>
</web>
</module>
<resource-ref>
<res-ref-name>ecrpDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<mapped-name>jdbc/e-CRP_Portal-1.09.00-b23</mapped-name>
<res-auth>Container</res-auth>
</resource-ref>
</application>
still no luck for me. what do i do wrong or what do i miss? is something obviously? perhaps i shouldnt modify application.xml and rather create new web.xml for my ear...
with all respect;
gasper