Irene, The "existing database" I am dealing with is Derby running on a desktop client and on a server. The database contains a conventional SQL data model for high frequency sensor data. I would like to annotate the the sensor data using rdf/owl and store it in the same database as the sensor data.
Arthur Sent from my iPhone On Aug 3, 2010, at 12:03 PM, "Irene Polikoff" <[email protected]> wrote: > Hi Arthur, > > > > Jena SDB over RDBMS is intended for users who have existing relational on a > server which they want to use as RDF storage. Users who don’t have this > requirement and just want to quickly create an RDF database could you use TDB. > > > > From your perspective, what needs would be served by an embedded SQL database > which are already not met by TDB? > > > > Regards, > > > > Irene > > > > From: [email protected] > [mailto:[email protected]] On Behalf Of Arthur Keen > Sent: Monday, August 02, 2010 3:44 PM > To: [email protected] > Subject: Re: [topbraid-users] Re: MySQL Communications link failure > > > > Thanks Scott, > > > > I got used to using the TDB interface, and I was hoping TBCME would offer to > create the MySQL instance if it did not exist :) Are there any plans to > support an embedded SQL database for Jena SDB, for example, Derby? > > > > Arthur > > > > On Mon, Aug 2, 2010 at 2:32 PM, Scott Henninger <[email protected]> > wrote: > > Arthur; Yes, it is necessary to create a MySQL instance (schema) in > MySQL before using SDB. > > -- Scott > > > On Aug 2, 2:15 pm, Arthur Keen <[email protected]> wrote: > > I am using TBCME 3.3.2 on Mac OS-X 10..6.4 and would like to create a Jena > > SDB mysql repository. I downloaded mysql-connector-java-5.1.13.jar, renamed > > it to mysql-connector.jar, and put it in the root of my workspace folder. > > > > Tried New>>RDF/OWL Jena SDB Database Connection. TBCME throws an error > > "Operation Failed. Reason: could not create database" and the "Details" > > button shows "Communications link failure." Restarting compose ad > > refreshing the workspace before retrying resulted in the same error. Is the > > driver that I downloaded the right version? Do I need to create a mysql > > instance outside of topbraid? > > > > Regards > > > > Arthur > > > > Exception Trace Stack > > > > com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link > > failure > > > > The last packet sent successfully to the server was 0 milliseconds ago. The > > driver has not received any packets from the server. > > > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > > > > at > > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > > > > at > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > > > > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > > > > at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) > > > > at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1118) > > > > at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343) > > > > at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2308) > > > > at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2122) > > > > at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:774) > > > > at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49) > > > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > > > > at > > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > > > > at > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > > > > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > > > > at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) > > > > at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:375) > > > > at > > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:289) > > > > at org.topbraid.javax.util.DBUtil.getConnection(DBUtil.java:51) > > > > at org.topbraid.sdb.module.StoreCache.createStore(StoreCache.java:50) > > > > at > > org.topbraid.sdb.module.AbstractSDBModule.getStoreCache(AbstractSDBModule.java:55) > > > > at > > org.topbraid.sdb.module.AbstractSDBModule.getStore(AbstractSDBModule.java:39) > > > > at > > org.topbraid.sdb.module.exportToSDB.ExportToSDBModule.execute(ExportToSDBModule.java:67) > > > > at > > org.topbraid.sparqlmotion.engine.impl.ExecutionEngine.execute(ExecutionEngine.java:212) > > > > at > > org.topbraid.sparqlmotion.engine.impl.ExecutionEngine.executeModule(ExecutionEngine.java:186) > > > > at > > org.topbraid.sparqlmotion.engine.impl.ExecutionEngine.execute(ExecutionEngine.java:155) > > > > at org.topbraidcomposer.sdb.wizards.SDBUtil.performFinish(SDBUtil.java:55) > > > > at > > org.topbraidcomposer.sdb.wizards.create.SDBCreateWizard$1.run(SDBCreateWizard.java:65) > > > > at > > org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121) > > > > Caused by: java.net.ConnectException: Connection refused > > > > at java.net.PlainSocketImpl.socketConnect(Native Method) > > > > at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) > > > > at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) > > > > at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) > > > > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:432) > > > > at java.net.Socket.connect(Socket.java:529) > > > > at java.net.Socket.connect(Socket.java:478) > > > > at java.net.Socket.<init>(Socket.java:375) > > > > at java.net.Socket.<init>(Socket.java:218) > > > > at > > com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256) > > > > at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292) > > -- > > You received this message because you are subscribed to the Google > > Group "TopBraid Suite Users", the topics of which include TopBraid Composer, > TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. > > 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-users?hl=en > > > > -- > You received this message because you are subscribed to the Google > Group "TopBraid Suite Users", the topics of which include TopBraid Composer, > TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. > 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-users?hl=en > > -- > You received this message because you are subscribed to the Google > Group "TopBraid Suite Users", the topics of which include TopBraid Composer, > TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. > 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-users?hl=en -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion and SPIN. 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-users?hl=en
