Hi
I need to use MSSQL JDBC driver with D2RQ but I get a driver class not
found exception. It seems like all I need to do is to include the
sqljdbc.jar file in the class path so that D2RQ can pick it up. How do
I do this?
Error:
de.fuberlin.wiwiss.d2rq.D2RQException: Database driver class not
found: com.microsoft.sqlserver.jdbc.SQLServerDriver (E42)
at de.fuberlin.wiwiss.d2rq.map.Database.registerJDBCDriver
(Database.java:47)
at de.fuberlin.wiwiss.d2rq.map.Database.connectedDB(Database.java:
152)
at org.topbraidcomposer.d2rq.wizard.MappingGenerator.connectToDatabase
(MappingGenerator.java:165)
at org.topbraidcomposer.d2rq.wizard.MappingGenerator.run
(MappingGenerator.java:127)
at org.topbraidcomposer.d2rq.wizard.ImportD2RQWizard.run
(ImportD2RQWizard.java:108)
at org.topbraidcomposer.d2rq.wizard.ImportD2RQWizard$1.run
(ImportD2RQWizard.java:54)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run
(ModalContext.java:121)
Anyways I also tried the jTDS driver and I get this
java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not
loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:614)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>
(ConnectionJDBC2.java:344)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>
(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at de.fuberlin.wiwiss.d2rq.sql.ConnectedDB.connect(ConnectedDB.java:
78)
at de.fuberlin.wiwiss.d2rq.sql.ConnectedDB.connection
(ConnectedDB.java:67)
at de.fuberlin.wiwiss.d2rq.dbschema.DatabaseSchemaInspector.<init>
(DatabaseSchemaInspector.java:71)
at de.fuberlin.wiwiss.d2rq.sql.ConnectedDB.schemaInspector
(ConnectedDB.java:86)
at org.topbraidcomposer.d2rq.wizard.MappingGenerator.connectToDatabase
(MappingGenerator.java:165)
at org.topbraidcomposer.d2rq.wizard.MappingGenerator.run
(MappingGenerator.java:127)
at org.topbraidcomposer.d2rq.wizard.ImportD2RQWizard.run
(ImportD2RQWizard.java:108)
at org.topbraidcomposer.d2rq.wizard.ImportD2RQWizard$1.run
(ImportD2RQWizard.java:54)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run
(ModalContext.java:121)
Caused by: java.io.IOException: SSO Failed: Native SSPI library not
loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.sendMSLoginPkt(TdsCore.java:
1889)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:587)
... 14 more
de.fuberlin.wiwiss.d2rq.D2RQException: rethrew: java.sql.SQLException:
I/O Error: SSO Failed: Native SSPI library not loaded. Check the
java.library.path system property.
at de.fuberlin.wiwiss.d2rq.sql.ConnectedDB.connect(ConnectedDB.java:
80)
at de.fuberlin.wiwiss.d2rq.sql.ConnectedDB.connection
(ConnectedDB.java:67)
at de.fuberlin.wiwiss.d2rq.dbschema.DatabaseSchemaInspector.<init>
(DatabaseSchemaInspector.java:71)
at de.fuberlin.wiwiss.d2rq.sql.ConnectedDB.schemaInspector
(ConnectedDB.java:86)
at org.topbraidcomposer.d2rq.wizard.MappingGenerator.connectToDatabase
(MappingGenerator.java:165)
at org.topbraidcomposer.d2rq.wizard.MappingGenerator.run
(MappingGenerator.java:127)
at org.topbraidcomposer.d2rq.wizard.ImportD2RQWizard.run
(ImportD2RQWizard.java:108)
at org.topbraidcomposer.d2rq.wizard.ImportD2RQWizard$1.run
(ImportD2RQWizard.java:54)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run
(ModalContext.java:121)
Caused by: java.sql.SQLException: I/O Error: SSO Failed: Native SSPI
library not loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:614)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>
(ConnectionJDBC2.java:344)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>
(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at de.fuberlin.wiwiss.d2rq.sql.ConnectedDB.connect(ConnectedDB.java:
78)
... 8 more
Caused by: java.io.IOException: SSO Failed: Native SSPI library not
loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.sendMSLoginPkt(TdsCore.java:
1889)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:587)
... 14 more
Ram
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TopBraid Composer Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/topbraid-composer-users?hl=en
-~----------~----~----~----~------~----~------~--~---
