Ram, it's not clear exactly how you addressed this in the wizard.
There are two key fields that need to be set up with the driver
package that you have. The following are examples - you will need to
give these proper names according to your setup.
Driver Class: 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
make sure your driver class is included, not just the .jar driver
class. You may need to open the .jar to find it.
Driver Jar URL: 'file:///C:/sqlserver/jdbcsql.jar'
this assumes a localhost installation in the directory "C:/
sqlserver" and a jdbcsql.jar file containing the driver (i.e. the
location of the .jar file containing the Driver Class)
-- Scott
On Dec 19, 11:04 am, ram <[email protected]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
