Ram; Let's start from the top. Use Import... OWL/RDFS View on Relational Database with D2RQ to bring up the D2RQ wizard and specified something similar to the folowing:
Database URL: file:///C:/sqlserver/jdbcsql.jar - path to the driver .jar file assuming a localhost solution Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver (or sqlserver.jdbc.SQLServerDriver) - depending on your driver, the name "SQLServerDriver" may be different If jTDS is used instead, the database URL should be jdbc:jtds:MsSQL://<host>[:<port>][/<database>] ... here the host, port an database refer to the specific database instance you are trying to use. Beyond that, more information would be needed on your specific setup to help out. -- Scott On Dec 19, 4: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 - > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
