Parsa; Good to get through the first step! Tale a look at the Triples tab to see if Composer can see any of the triples in the model. ...or let us know what "can't be seen" (the class hierarchy, rdfs:Resource instances, etc.)
-- Scott On Nov 11, 5:14 pm, Parsa Mirhaji <[EMAIL PROTECTED]> wrote: > 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) > > ... > > 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 -~----------~----~----~----~------~----~------~--~---
