YES! That did the trick! It now But, I can¹t see anything that is there in the model! I can load the model into Jena through code and write it out, but I can¹t see it from TBC? I did not check the overwrite existing model, so I am expecting that it did not go ahead and create an empty model inside the repository?
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: Holger Knublauch <[EMAIL PROTECTED]> Reply-To: TBC group <[email protected]> Date: Tue, 11 Nov 2008 14:59:41 -0800 To: TBC group <[email protected]> Subject: [tbc-users] Re: Importing from Jena Persistence Databases 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 -~----------~----~----~----~------~----~------~--~---
