Hi all,
Am having problems seeing a data source though it's registered in JNDI and is loaded by JBoss with no problems. Accessing the DS gives me a :
java.sql.SQLException: Unexpected token: stored_proc_name
15:50:52,747 INFO [STDOUT] at org.hsqldb.Trace.getError(Unknown Source)
15:50:52,757 INFO [STDOUT] at org.hsqldb.jdbcResultSet.(Unknown Sourc
e)
15:50:52,757 INFO [STDOUT] at org.hsqldb.jdbcConnection.executeStandalone(U
nknown Source)
15:50:52,757 INFO [STDOUT] at org.hsqldb.jdbcConnection.execute(Unknown Sou
rce)
15:50:52,757 INFO [STDOUT] at org.hsqldb.jdbcStatement.fetchResult(Unknown
Source)
15:50:52,757 INFO [STDOUT] at org.hsqldb.jdbcStatement.executeQuery(Unknown
Source)
15:50:52,757 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedStatem
ent.executeQuery(WrappedStatement.java:259)
and then where I call it in my bean.
The problem here is that I'm not using the Hypersonic driver and am actually using the JNet JSQLDriver, which works just fine if I explicitly make a connection to the data base URL.
Is JBoss going to the included Hypersonic driver because it can't find the name ? I've included a jboss.xml like so:
<ejb-name>someName</ejb-name>
<resource-ref>
<res-ref-name>jdbc/myDS</res-ref-name>
<jndi-name>java:/jdbc/myDS</jndi-name>
</resource-ref>
and a myDS file is :
<local-tx-datasource>
<jndi-name>jdbc/myDS</jndi-name>
<connection-url>jdbc:JSQLConnect://127.19.1.281/database=myDB</connection-url>
<driver-class>com.jnetdirect.jsql.JSQLDriver</driver-class>
<user-name>me</user-name>
mer
</local-tx-datasource>
What am I missing ?
thanks