Anything other than ³sqlserver² (or its variants SQLServer, SqlServer etc) fails with the following error:
³Could not create database Failure to instantiate DB Driver:sqlserver java.sql.SQLException: The syntax of the connection URL 'jdbc:jtds:MsSQL://129.106.31.167:1433/SODS/' is invalid.² This includes even the jtds documented uri: <jdbc:jtds:mircorost://...> Parsa Mirhaji, MD Director, The Center for Biosecurity and Public Health Informatics Research The School of Health Information Sciences The University of Texas Health Science Center at Houston Tel: (713) 500-3157 Fax: (713) 500-0370 Assistance (Connie Tapper): (713) 500-3973 P Please consider the environment before printing this e-mail. From: Scott Henninger <[EMAIL PROTECTED]> Reply-To: TBC group <[email protected]> Date: Tue, 11 Nov 2008 14:39:29 -0800 (PST) To: TBC group <[email protected]> Subject: [tbc-users] Re: Importing from Jena Persistence Databases Parsa; The error message indicates that the Jena driver needs to be specified for the Database URL. Try using MsSQL (case sensitive). I.e.: jdbc:jtds:MsSQL://<host>[:<port>][/<database>] Give that a try... -- Scott On Nov 11, 12:23 pm, Parsa Mirhaji <[EMAIL PROTECTED]> wrote: > correction: > jdbc:jtds:sqlserver://<host>[:<port>][/<database>] > > From: Parsa Mirhaji <[EMAIL PROTECTED]> > Reply-To: TBC group <[email protected]> > Date: Tue, 11 Nov 2008 12:21:04 -0600 > To: TBC group <[email protected]> > Subject: [tbc-users] Re: Importing from Jena Persistence Databases > > I think there is a discrepancy between jtds documentation and > implementation. Where they suggest to use > jdbc:jtds:microsoft://<host>[:<port>][/<database>] as the JDBC URI format, > it actually works if you enter > jdbc:jtds:microsoft://<host>[:<port>][/<database>] > > But the problem presents itself in another way after the connection is made: > > Please notice that the failing class is now a JENA class from > com.hp.hpl.jena namespace. > > I tested this with another JDBC driver for microsofy sql server, from MSDN > website, and it fails at this exact point too. > > Any comments? > Thanks > Parsa > > Parsa Mirhaji, MD > Director, The Center for Biosecurity and Public Health Informatics Research > The School of Health Information Sciences > The University of Texas Health Science Center at Houston > Tel: (713) 500-3157 > Fax: (713) 500-0370 > Assistance (Connie Tapper): (713) 500-3973 > > P Please consider the environment before printing this e-mail. > > From: Scott Henninger <[EMAIL PROTECTED]> > Reply-To: TBC group <[email protected]> > Date: Mon, 10 Nov 2008 17:42:27 -0800 (PST) > To: TBC group <[email protected]> > Subject: [tbc-users] Re: Importing from Jena Persistence Databases > > Hello Parsa; There are a few things to try out. First the Database > URL in your screen image uses the 'mysql' subprotocol (server type). > You'll want to use 'sqlserver', i.e. 'jdbc:sqlserver' followed by the > URL for your database. You may also need to include the port number > the database listens to. > > Given that you are using the jTDS driver, the Driver Class and Driver > Jar URL seem to be correct. Making sure the jar file is on your > localhost under E:/text and that it is in your classpath would be the > only things I could suggest. > > -- Scott > > On Nov 10, 6:16 pm, Parsa Mirhaji <[EMAIL PROTECTED]> wrote: > > > Scott > > I know it is a while but the trick did not work. I used a TBC 2.6.2 to > > connect to a MSSQL Server Jena Persistence using the connection information > > in the attached file and see the error message as shown in the image. > > Changing drivers, driver classes and such did not work. > > Any comments? > > Best regards > > Parsa > > > Parsa Mirhaji, MD > > Director, The Center for Biosecurity and Public Health Informatics Research > > The School of Health Information Sciences > > The University of Texas Health Science Center at Houston > > Tel: (713) 500-3157 > > Fax: (713) 500-0370 > > Assistance (Connie Tapper): (713) 500-3973 > > > P Please consider the environment before printing this e-mail. > > > From: Scott Henninger <[EMAIL PROTECTED]> > > Reply-To: TBC group <[email protected]> > > Date: Fri, 25 Jul 2008 07:07:51 -0700 (PDT) > > To: TBC group <[email protected]> > > Subject: [tbc-users] Re: Importing from Jena Persistence Databases > > > Hello Parsa; It seems to me that you have a couple of options. One > > is to go directly to the database in MS-SQL and import to TBC via > > d2rq. The second is to import via the Jena database connection > > wizard. To do this, you need to give TBC the information about the > > database name, location, and the driver for MS-SQL. > > > I'm assuming that the Jena database was created by some other > > application. Therefore you will need to tell TBC how to get to it. > > Use the New -> OW/RDFS Jena Database wizard. Think of "new" as a new > > database connection. This works OK for me using MySQL data stores > > created in Jena format. You will need to specify the MS-SQL jar and > > class locations, as the current wizard does not have a driver for MS- > > SQL. > > > If that doesn't work for you, we may need more information about how > > the Jena database was created, etc. > > -- Scott > > > On Jul 24, 11:49 am, Parsa Mirhaji <[EMAIL PROTECTED]> wrote: > > > > Scott, > > > Thanks for the response. In my case I already have the Jena model in the > > > MS-SQL database. The question is how I can import it into TBC and somehow > > > save it into an OWL file. Information I need is where to put the MS-SQL > > > driver and how to invoke it from import menu... > > > Thanks > > > Parsa > > > > Parsa Mirhaji, MD > > > Director, The Center for Biosecurity and Public Health Informatics Research > > > The School of Health Information Sciences > > > The University of Texas Health Science Center at Houston > > > Tel: (713) 500-3157 > > > Fax: (713) 500-0370 > > > Assistance (Yukiko Bryson): (713) 500-3938 > > > > From: Scott Henninger <[EMAIL PROTECTED]> > > > Reply-To: <[email protected]> > > > Date: Tue, 22 Jul 2008 15:51:33 -0700 (PDT) > > > To: TopBraid Composer Users <[email protected]> > > > Subject: [tbc-users] Importing from Jena Persistence Databases > > > > Parsa; I'm moving this to a separate discussion. Somehow the the post > > > was placed at the end of a different discussion. > > > > For the issue below, I believe all you will need is the JDBC driver > > > for the MS-SQL service you are running - i.e. the applicable .jar > > > file. Put the jar in a local "file:///" or on a web server (http) you > > > have access to. Then use New... to create a new Jena database. The > > > wizard will show all the information you need, including the location > > > of the MS-SQL .jar file. Use the net.sourceforge.jtds.jdbc.Driver as > > > the Driver Class. > > > > -- Scott > > > > On Jul 22, 12:21 pm, Parsa Mirhaji <[EMAIL PROTECTED]> wrote: > > > > > Holger, > > > > How if it is possible to import a model from JENA persistence that uses a > > > > MS-SQL Server Backend into TBC? > > > > Thanks > > > > Parsa > > > > > Parsa Mirhaji, MD > > > > Director, The Center for Biosecurity and Public Health Informatics > Research > > > > The School of Health Information Sciences > > > > The University of Texas Health Science Center at Houston > > > > Tel: (713) 500-3157 > > > > Fax: (713) 500-0370 > > > > Assistance (Yukiko Bryson): (713) 500-3938 > > > TBC2MSSQL.jpg > > 133KViewDownload > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
