You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jena.apache.org by David Jordan <Da...@sas.com> on 2013/03/04 20:57:12 UTC
postgres issue
I have been using Jena with MySQL without problems. I now have to get an environment set up using Postgres.
Using some existing code that was working with MySQL does not work with Postgres.
Any ideas? I have no experience with Postgres.
This occurs with the call to Model.read(in, base, lang).
I did the sdb creation step, which creates the tables nodes, prefixes, quads, triples.
The name of the table in the insert looks strange: NNodeQuads1449629931
[java] Exception flushing
[java] com.hp.hpl.jena.sdb.SDBException: Exception flushing
[java] at com.hp.hpl.jena.sdb.layout2.TupleLoaderBase.flush(TupleLoaderBase.java:234)
[java] at com.hp.hpl.jena.sdb.layout2.TupleLoaderBase.finish(TupleLoaderBase.java:169)
[java] at com.hp.hpl.jena.sdb.layout2.LoaderTuplesNodes.commitTuples(LoaderTuplesNodes.java:306)
[java] at com.hp.hpl.jena.sdb.layout2.LoaderTuplesNodes.access$100(LoaderTuplesNodes.java:43)
[java] at com.hp.hpl.jena.sdb.layout2.LoaderTuplesNodes$Commiter.run(LoaderTuplesNodes.java:346)
[java] at java.lang.Thread.run(Thread.java:662)
[java] Caused by: java.sql.BatchUpdateException: Batch entry 3 INSERT INTO NNodeQuads1449629931 VALUES (-5388035591044083834 , '?????????? ???????????????' , 'el' , '' , 3 ) was aborted. Call getNextException to see the cause.
[java] at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2746)
[java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1887)
[java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405)
[java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2893)
[java] at com.hp.hpl.jena.sdb.layout2.TupleLoaderBase.flush(TupleLoaderBase.java:214)
[java] ... 5 more
[java] Java Result: -1
David Jordan
Senior Software Developer
SAS Institute Inc.
Health & Life Sciences, Research & Development
Bldg R ▪ Office 4467
600 Research Drive ▪ Cary, NC 27513
Tel: 919 531 1233 ▪ david.jordan@sas.com<ma...@sas.com>
www.sas.com<http://www.sas.com/>
SAS® … THE POWER TO KNOW®