Subject:[DataDirect][XQuery]Failed to make a JDBC connection to "Objecten". Cause: [DataDirect][XQuery]No suitable driver Author:Paul Hermans Date:14 Apr 2006 07:46 AM
Dear,
Latest Enterprise Release 2 version.
Building an XQuery using two collections using the DataDirect Sequelink connection to 2 MS Access tables.
Running the XQuery with the built-in processor works.
Running the same Query with the DataDirect XQuery engine results in following error message:
com.ddtek.xquery.XQException: [DataDirect][XQuery]Failed to make a JDBC connection to "Objecten". Cause: [DataDirect][XQuery]No suitable driver
at com.ddtek.xquery.xqj.Util.XQException(Util.java:198)
at com.ddtek.xquery.xqj.mediator.DDXQConnection.<init>(DDXQConnection.java:111)
at com.ddtek.xquery.xqj.mediator.DDXQDataSource._getConnection(DDXQDataSource.java:928)
at com.ddtek.xquery.xqj.mediator.DDXQDataSource.getConnection(DDXQDataSource.java:424)
Caused by: com.ddtek.xquery.util.XQueryException: [ME0022][DataDirect][XQuery]Failed to make a JDBC connection to "Objecten". Cause: [DataDirect][XQuery]No suitable driver
at com.ddtek.xquery.mediator.SqlAdapter.connect(SqlAdapter.java:74)
at com.ddtek.xquery.mediator.MediatorConnection.connectAllSqlAdapters(MediatorConnection.java:225)
at com.ddtek.xquery.mediator.MediatorConnection.connect(MediatorConnection.java:89)
at com.ddtek.xquery.xqj.mediator.DDXQConnection.<init>(DDXQConnection.java:109)
Subject:[DataDirect][XQuery]Failed to make a JDBC connection to Author:Minollo I. Date:14 Apr 2006 09:11 AM
Paul,
DataDirect XQuery doesn't support Sequelink drivers.
You can run the query with DataDirect XQuery using the doc() function to wrap the Sequelink connection, so that the Stylus Studio URI resolver can recognize it - even if that will make DataDirect XQuery see the data source as a normal XML document, and not use its relational optimizations...