I'm working with jboss2.4.4-Tomcat4.0.1, I configure the jboss.jcml file with my DB Oracle 9i (with driver classes12.zip in
lib/ext )
----------JBOSS.JCML-----------
oracle.jdbc.driver.OracleDriver
DefaultDS
oracle.jdbc.xa.client.OracleXADataSource
jdbc:oracle:thin:@bart:1521:test
silicon
Pamela
10
false
false
false
true
120000
1800000
false
false
1.0
0
---------------
The ejb's are BMP, there is the descriptors files:
----------EJB-JAR.XML-----------
...
<resource-ref>
<res-ref-name>jdbc/DefaultDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
------------------------------
---------JBOSS.XML------------------
<enterprise-beans>
<ejb-name>DiagnosE</ejb-name>
<jndi-name>diagnosServer</jndi-name>
<resource-ref>
<res-ref-name>jdbc/DefaultDS</res-ref-name>
<jndi-name>java:/DefaultDS</jndi-name>
</resource-ref>
</enterprise-beans>
---------------------------
I can make the deploy but when i try execute the client, failed in sentencies sql:
Table not found!
Anybody can help me?
Thanks in advanced.
Looks more like a database/sql-related problem than anything to do with JBoss. At least, he seems to be able to connect to the database server, but fails to find a table with the name provided in your jdbc code or sql statement.
Hope this did help,
Lars