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
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3843925#3843925
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3843925
-------------------------------------------------------
This SF.Net email is sponsored by OSTG. Have you noticed the changes on
Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
one more big change to announce. We are now OSTG- Open Source Technology
Group. Come see the changes on the new OSTG site. www.ostg.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
