Thanks Ram, that does help some. The generate-mapping script in D2RQ will generate a mapping, but does no verification and therefore will take any input. Composer will verify the existence of the driver before creating the mapping. Therefore, while the generate-mapping script will create a mapping file, it may or may not specify a successful connection to the database. In your case I suspect it won't.
The "driver not found" message from D2RQ (when using the Composer Import wizard) is stating it like it is. The driver is not being found. In particular, you need to find the correct addressing for the Driver Class for your SQLServer installation. It appears that com.microsoft.sqlserver.jdbc.SQLServerDriver is not correct for yor setup. Check the setup for your SQLServer database instance. Some SQLServer packages require a separate installation for the SQLServer driver. There may also be problems with getting the .jar file in the CLASSPATH - for example Java doesn't tolerate spaces in the path. If you can't get that to work. jTDS is an option. -- Scott On Dec 22, 12:04 pm, ram <[email protected]> wrote: > The output I show above is NOT generated by TBC. The D2RQ package has > a script/batch file called generate-mapping which I used to generate > the output above. > > What I want is TBC to generate an OWL schema from the database tables. > So i tried doing it through import using D2RQ. Thats when I get the > "driver not found" error.. > > hope this clarifies things.. > ram > > On Dec 22, 9:56 am, Scott Henninger <[email protected]> > wrote: > > > Ram; I guess I'm a little confused at this point. You have a > > mapping, but are you saying it doesn't work or something? What is or > > isn't happening that you expect? I'm also unclear on what you mean by > > a "command line". Do you mean using the D2RQ server directly - i.e. > > not using Composer? > > > -- Scott > > > On Dec 22, 11:38 am, ram <[email protected]> wrote: > > > > Hey scott > > > > I am doing all the things you are asking me to. > > > > BTW, I am able to run D2RQ (v-0.5.1) from the command line using the > > > same parameters.. The first few lines of the mapping file produced by > > > generate-mapping are below. > > > > --- > > > [D2RQ] Database is: Microsoft SQL Server, version: 9.00.3042 > > > @prefix map: <file:///stdout#> . > > > @prefix db: <> . > > > @prefix vocab: <vocab/> . > > > @prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> . > > > @prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> . > > > @prefix xsd: <http://www.w3.org/2001/XMLSchema#> . > > > @prefix d2rq: <http://www.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/0.1#> . > > > > map:database a d2rq:Database; > > > d2rq:jdbcDriver "com.microsoft.sqlserver.jdbc.SQLServerDriver"; > > > d2rq:jdbcDSN "jdbc:sqlserver://xxx.xx.xx.xx: > > > 1433;database=ChevronIAM_XXX;integratedSecurity=true"; > > > > --- > > > > On Dec 21, 1:47 pm, Scott Henninger <[email protected]> > > > wrote: > > > > > 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 > > ... > > read more » --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
