I am quite sure the D2RQ script is connecting to my database alright. I cannot show you the rest of the current mapping file but it contains the mapping for all the tables (class maps, property bridges and all that good stuff) in the database. Infact even the "dump-rdf" runs succesfully and retrieves all the content of the database tables into an RDF file. i think there is no way it can do it without a connection.. If you really want me to, I could create a dummy database and get the complete D2RQ mapping created for it..
ram. On Dec 22, 10:57 am, Scott Henninger <[email protected]> wrote: > 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) > > > > > > > > > > ... > > read more »- 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 -~----------~----~----~----~------~----~------~--~---
