Thanks for your response Scott.. I do not an input field for "Driver Jar URL" in my wizard. I am using TBC maestro edition v2.6.2..
ram On Dec 19, 1:32 pm, Scott Henninger <[email protected]> wrote: > 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- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
