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 -~----------~----~----~----~------~----~------~--~---
