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]<topbraid-users%[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
