Seems starange, but looking at it a bit I think I would try running D2RQ from the command line to see if it will run. I saw a post before that stated that you must remove the "com.microsoft" from the driver class as well. Others with this problem saw that they had possibly the wrong version of the driver.
On Sat, Dec 20, 2008 at 1:28 AM, ram <[email protected]> wrote: > > nope.. still the same error :( > > --error log-- > eclipse.buildId=I20080617-2000 > java.version=1.5.0_16 > java.vendor=Sun Microsystems Inc. > BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US > Command-line arguments: -os win32 -ws win32 -arch x86 > > > Error > Fri Dec 19 16:25:08 PST 2008 > de.fuberlin.wiwiss.d2rq.D2RQException: Database driver class not > found: com.microsoft.sqlserver.jdbc.SQLServerDriver (E42) > > 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) > > > > On Dec 19, 3:24 pm, "Dave butlerdi" <[email protected]> wrote: > > Preferences --> Data Management -->Driver Definitions --> add ... should > do > > it.... > > > > > > > > > > > > On Fri, Dec 19, 2008 at 11:20 PM, ram <[email protected]> wrote: > > > > > 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 - > > > > -- > > Regards > > > > Dave Butler > > butlerdi-at-pharm2phork-dot-org > > > > Also on Skype as butlerdi > > > > Get Skype herehttp://www.skype.com/download.html > > > > ********************************************************************** > > This email and any files transmitted with it are confidential and > > intended solely for the use of the individual or entity to whom they > > are addressed. If you have received this email in error please notify > > the system manager. > > > > This footnote also confirms that this email message has been swept by > > MIMEsweeper for the presence of computer viruses. > > > > www.mimesweeper.com > > **********************************************************************- > Hide quoted text - > > > > - Show quoted text - > > > > -- Regards Dave Butler butlerdi-at-pharm2phork-dot-org Also on Skype as butlerdi Get Skype here http://www.skype.com/download.html ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ********************************************************************** --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
