Possibly the model did not have any imports or no classes? Please check the Triples View to verify that it is indeed empty and report your findings. Thanks!
Holger On Nov 11, 2008, at 3:14 PM, Parsa Mirhaji 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) 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 -~----------~----~----~----~------~----~------~--~---
