Subject:XQuery editor whitin Stylus Studio cannot read full structure of some SQL Server tables Author:Rodolfo Vegas Date:27 Oct 2008 07:55 AM
Hi,
I am having troubles reading the structure of some tables in our Microsoft SQL Server. For the majority of the tables it performs well, but in some cases, the 'scan' of the table ends before the final column, and I get this messages on the Output window:
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.stylusstudio.DataDirectDDXQStub.registerDriver(DataDirectDDXQStub.java:50)
at com.stylusstudio.DataDirectDDXQStub.registerDrivers(DataDirectDDXQStub.java:69)
at com.stylusstudio.DataDirectDDXQStub.getConnection(DataDirectDDXQStub.java:102)
java.lang.ClassNotFoundException: org.postgresql.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.stylusstudio.DataDirectDDXQStub.registerDriver(DataDirectDDXQStub.java:50)
at com.stylusstudio.DataDirectDDXQStub.registerDrivers(DataDirectDDXQStub.java:70)
at com.stylusstudio.DataDirectDDXQStub.getConnection(DataDirectDDXQStub.java:102)
Despite of this, if I type any of the columns that are not displayed (nor in the File Explorer window neither in the drop-down list displayed when typing the code), whe running the query it goes fine.
Could you tell me what's going on? Is there something wrong with the installation?