Subject:Msql Table err:FODC0004 Table "test.bibletable" not found in any JDBC connection. Author:Don Hamby Date:18 Apr 2008 07:12 PM
I am having trouble using any table after I connect to Mysql
I am using the following Java Driver
which I downloaded and extracted from the Mysql website
C:\jdbc2\mysql-connector-java-5.1.6-bin.jar
OS= winxp
Mysql version= 5.0.22
I have a data connection.. but it shows all the databases in mysql ..not just the test database
the tree list displays the correct list of tables in the "test" database
When I click on a table in the relational Database of file explorer I get this error:
com.ddtek.xquery3.XQQueryException: [DataDirect][XQuery][err:FODC0004]Table "test.bibletable" not found in any JDBC connection.
Details
java.lang.RuntimeException: com.ddtek.xquery3.XQQueryException: [DataDirect][XQuery][err:FODC0004]Table "test.bibletable" not found in any JDBC connection.
at com.stylusstudio.DDXQFileSystem$DDXQFile.runQuery(DDXQFileSystem.java:370)
at com.stylusstudio.DDXQFileSystem$DDXQFile.getInputStream(DDXQFileSystem.java:378)
Caused by: com.ddtek.xquery3.XQQueryException: [DataDirect][XQuery][err:FODC0004]Table "test.bibletable" not found in any JDBC connection.
at com.ddtek.xquery3.xqj.Util.createXQQueryException(Util.java:318)
at com.ddtek.xquery3.xqj.Util.createXQException(Util.java:239)
at com.ddtek.xquery3.xqj.layer.DDXQAbstractExpression.createOrGetExecutionContext(DDXQAbstractExpression.java:476)
at com.ddtek.xquery3.xqj.layer.DDXQExpression._executeQuery(DDXQExpression.java:94)
at com.ddtek.xquery3.xqj.layer.DDXQExpression.executeQuery(DDXQExpression.java:114)
at com.stylusstudio.DDXQFileSystem$DDXQFile.runQuery(DDXQFileSystem.java:367)
... 1 more
Caused by: com.ddtek.xquery.util.XQueryException: [ME0018][DataDirect][XQuery][err:FODC0004]Table "test.bibletable" not found in any JDBC connection.
at com.ddtek.xquery.mediator.metadata.MediatorMetaData.syncStaticContext(MediatorMetaData.java:108)
at com.ddtek.xquery.mediator.ContextFactory.prepareQuery(ContextFactory.java:225)
at com.ddtek.xquery3.xqj.layer.DDXQAbstractExpression.createOrGetExecutionContext(DDXQAbstractExpression.java:473)
... 4 more
What am I doing wrong?
Classpath is set correctly in the classpath environmental variable setting
I used control panel/system/system properties/enviromental variables/CLASSPATH
and I rebooted after changing it.
From another post it appears SS 2008 ignores this anyway...the system variable
Restarting Stylus Studio 2008 xml enterprise has no effect
other info:
Framework=1050g
DataDirect XQuery 3.1 (R034702)
JVM=10.0b22 Java Hotspot
debug mode port:8000
I have screen shots of this if that would help
A little frustated at this point
Thank you for the report, we are aware of the defect, the next Stylus Studio release will have it fixed.
In the mean while you should be able to query MySQL using XQuery:
be sure that the database connection includes the database name for example //localhost:3306/test?
- Create a new XQuery document
- Drag the database node into the XQuery tree schema as explained in the diagram at http://www.stylusstudio.com/docs/v2008/d_xquery36.html
- Change the collection statement to use the table name only, for example