Open GoogleCodeExporter opened 8 years ago
Got it working reason of failure was i had my project and jpa4jena in my
workspace in eclipse with workspace resolution turned on and it was finding
various files.
I progressedw ith this and tried to add db backed store for big big graphs
using
tws:dbmodel rdf:type sdb:DatasetStore ;
tws:package "com.maarif.cube.core.service.helloworld";
sdb:layout "layout2" ;
sdb:connection <#conn> ;
.
<#conn> rdf:type sdb:SDBConnection ;
sdb:sdbType "hsqldb" ;
sdb:sdbHost "mem" ;
sdb:sdbUser "sa" ;
sdb:sdbPassword "" ;
sdb:sdbName "SDB2" ;
sdb:driver "org.hsqldb.jdbcDriver" ;
.
but it fails with PersistenceException
javax.persistence.PersistenceException:
com.hp.hpl.jena.assembler.exceptions.AssemblerException: caught: null
doing:
root: http://www.thewebsemantic.com/dbmodel with type: http://jena.hpl.hp.com/2007/sdb#DatasetStore assembler class: class com.hp.hpl.jena.sdb.assembler.DatasetStoreAssembler
at thewebsemantic.jpa.JBProvider._createEntityManagerFactory(JBProvider.java:99)
at thewebsemantic.jpa.JBProvider.createEntityManagerFactory(JBProvider.java:80)
at thewebsemantic.jpa.JBProvider.createEntityManagerFactory(JBProvider.java:39)
at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:46)
at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:30)
at com.maarif.cube.core.service.helloworld.JenaBeanTest.saveTest(JenaBeanTest.java:30)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:45)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:42)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:30)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:263)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:68)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:47)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)
at org.junit.runners.ParentRunner.run(ParentRunner.java:300)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: com.hp.hpl.jena.assembler.exceptions.AssemblerException: caught: null
doing:
root: http://www.thewebsemantic.com/dbmodel with type: http://jena.hpl.hp.com/2007/sdb#DatasetStore assembler class: class com.hp.hpl.jena.sdb.assembler.DatasetStoreAssembler
at com.hp.hpl.jena.assembler.assemblers.AssemblerGroup$PlainAssemblerGroup.openBySpecificType(AssemblerGroup.java:138)
at com.hp.hpl.jena.assembler.assemblers.AssemblerGroup$PlainAssemblerGroup.open(AssemblerGroup.java:117)
at com.hp.hpl.jena.assembler.assemblers.AssemblerGroup$ExpandingAssemblerGroup.open(AssemblerGroup.java:81)
at com.hp.hpl.jena.assembler.assemblers.AssemblerBase.open(AssemblerBase.java:52)
at com.hp.hpl.jena.assembler.assemblers.AssemblerBase.open(AssemblerBase.java:48)
at com.hp.hpl.jena.assembler.assemblers.AssemblerGroup.openModel(AssemblerGroup.java:35)
at thewebsemantic.jpa.JBProvider._createEntityManagerFactory(JBProvider.java:94)
... 30 more
Caused by: java.lang.NullPointerException
at com.hp.hpl.jena.sparql.util.graph.GraphUtils.atmostOneProperty(GraphUtils.java:125)
at com.hp.hpl.jena.sparql.util.graph.GraphUtils.getResourceValue(GraphUtils.java:159)
at com.hp.hpl.jena.sdb.assembler.StoreDescAssembler.open(StoreDescAssembler.java:52)
at com.hp.hpl.jena.sdb.assembler.DatasetStoreAssembler.openStore(DatasetStoreAssembler.java:49)
at com.hp.hpl.jena.sdb.assembler.DatasetStoreAssembler.open(DatasetStoreAssembler.java:40)
at com.hp.hpl.jena.sdb.assembler.DatasetStoreAssembler.open(DatasetStoreAssembler.java:33)
at com.hp.hpl.jena.assembler.assemblers.AssemblerGroup$PlainAssemblerGroup.openBySpecificType(AssemblerGroup.java:130)
... 36 more
Original comment by bedouinr...@gmail.com
on 27 Mar 2013 at 11:56
tws:dbmodel rdf:type sdb:Model ;
tws:package "com.maarif.cube.core.service.helloworld";
sdb:store <#store>;
sdb:dataset <#dataset>;
.
<#dataset> rdf:type sdb:DatasetStore ;
sdb:store <#store> .
<#store> rdf:type sdb:Store ;
sdb:connection <#conn> ;
sdb:layout "layout2" ;
.
<#conn> rdf:type sdb:SDBConnection ;
##sdb:sdbType "hsqldb" ;
##sdb:sdbHost "file" ;
##sdb:sdbUser "sa" ;
##sdb:sdbPassword "" ;
##sdb:jdbcURL "jdbc:hsqldb:mem;shutdown=true;sql.enforce_size=false";
##sdb:sdbName "SDB2" ;
##sdb:driver "org.hsqldb.jdbcDriver" ;
sdb:sdbType "derby" ;
sdb:sdbName "DB/SDB2" ; # Directory name of the database
sdb:driver "org.apache.derby.jdbc.EmbeddedDriver" ;
.
its creating db connection now but fails with errors ;
WARN 2013-03-28 10:00:11,937 [Thread-2]
com.hp.hpl.jena.sdb.sql.SDBConnection.exception(SDBConnection.java:338):
prepareStatement: SQLException
Schema 'USER' does not exist
DELETE FROM Triples
WHERE
s = ? AND
p = ? AND
o = ?
ERROR 2013-03-28 10:00:11,937 [Thread-2]
com.hp.hpl.jena.sdb.layout2.LoaderTuplesNodes$Commiter.handleIssue(LoaderTuplesN
odes.java:373): Error in thread: Problem making new tupleloader
com.hp.hpl.jena.sdb.SDBException: Problem making new tupleloader
at com.hp.hpl.jena.sdb.layout2.LoaderTuplesNodes.updateOneTuple(LoaderTuplesNodes.java:292)
at com.hp.hpl.jena.sdb.layout2.LoaderTuplesNodes.access$200(LoaderTuplesNodes.java:43)
at com.hp.hpl.jena.sdb.layout2.LoaderTuplesNodes$Commiter.run(LoaderTuplesNodes.java:362)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.reflect.InvocationTargetException
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.hp.hpl.jena.sdb.layout2.LoaderTuplesNodes.updateOneTuple(LoaderTuplesNodes.java:288)
... 3 more
Caused by: com.hp.hpl.jena.sdb.SDBException: Problem initialising loader for
[Triples]
at com.hp.hpl.jena.sdb.layout2.TupleLoaderBase.<init>(TupleLoaderBase.java:59)
at com.hp.hpl.jena.sdb.layout2.hash.TupleLoaderHashBase.<init>(TupleLoaderHashBase.java:29)
at com.hp.hpl.jena.sdb.layout2.hash.TupleLoaderHashDerby.<init>(TupleLoaderHashDerby.java:33)
... 8 more
Caused by: java.sql.SQLSyntaxErrorException: Schema 'USER' does not exist
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at com.hp.hpl.jena.sdb.sql.SDBConnection.prepareStatement(SDBConnection.java:228)
at com.hp.hpl.jena.sdb.layout2.TupleLoaderBase.init(TupleLoaderBase.java:70)
at com.hp.hpl.jena.sdb.layout2.TupleLoaderBase.<init>(TupleLoaderBase.java:57)
... 10 more
Caused by: java.sql.SQLException: Schema 'USER' does not exist
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 26 more
Caused by: ERROR 42Y07: Schema 'USER' does not exist
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source)
at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source)
at org.apache.derby.impl.sql.compile.DeleteNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 20 more
DEBUG 2013-03-28 10:00:11,937 [main]
com.hp.hpl.jena.shared.LockMRSW.leaveCriticalSection(LockMRSW.java:143): main
>> leaveCS: Thread R/W: 0/1 :: Model R/W: 0/1 (thread: main)
DEBUG 2013-03-28 10:00:11,937 [main]
com.hp.hpl.jena.shared.LockMRSW.leaveCriticalSection(LockMRSW.java:176): main
<< leaveCS: Thread R/W: 0/0 :: Model R/W: 0/0 (thread: main)
Original comment by bedouinr...@gmail.com
on 28 Mar 2013 at 9:59
I m using StoreDesc delivered in jena-sdb 1.3.6 and I have the same problem
when I want to use the SDBConnection.
Original comment by alexandr...@gmail.com
on 28 Jun 2013 at 2:18
Original issue reported on code.google.com by
bedouinr...@gmail.com
on 26 Mar 2013 at 2:55