Did you also try entering "MsSQL" as database type in the wizard, leaving the URL the way that it worked for you?
Holger On Nov 11, 2008, at 2:46 PM, Parsa Mirhaji wrote: > 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 -~----------~----~----~----~------~----~------~--~---
