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 22:00:18 UTC
update on my Postgres issue
With the recent error I reported, I was trying to load dbPedia ontology in RDF/XML format.
This is with Postgres 9.2 and SDB 1.3.6 Snapshot.
Caused by: java.sql.BatchUpdateException: Batch entry 3 INSERT INTO NNodeQuads17852335 VALUES (-5388035591044083834 , '?????????? ???????????????' , 'el' , '' , 3 ) was aborted. Call getNextException to see the cause.
I switched and loaded a small ontology file in TURTLE that had been working in MySQL. It has just 58 nodes and 91 quads. It loaded fine without any problems. So maybe this ontology is so small that it is not triggering batch updates?
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®
RE: update on my Postgres issue
Posted by David Jordan <Da...@sas.com>.
Thanks Andy. You were right, the default character encoding Postgres uses is not UTF-8 compatible. I created a new environment with the right encoding and it worked fine.
-----Original Message-----
From: Andy Seaborne [mailto:andy.seaborne.apache@gmail.com] On Behalf Of Andy Seaborne
Sent: Tuesday, March 05, 2013 5:57 AM
To: users@jena.apache.org
Subject: Re: update on my Postgres issue
On 04/03/13 21:00, David Jordan wrote:
> With the recent error I reported, I was trying to load dbPedia ontology in RDF/XML format.
> This is with Postgres 9.2 and SDB 1.3.6 Snapshot.
>
> Caused by: java.sql.BatchUpdateException: Batch entry 3 INSERT INTO NNodeQuads17852335 VALUES (-5388035591044083834 , '?????????? ???????????????' , 'el' , '' , 3 ) was aborted. Call getNextException to see the cause.
>
> I switched and loaded a small ontology file in TURTLE that had been working in MySQL. It has just 58 nodes and 91 quads. It loaded fine without any problems. So maybe this ontology is so small that it is not triggering batch updates?
This may be caused the database is not setup to be UTF-8 correctly.
It looks as if the string '?????????? ???????????????' is broken (language code el is modern greek).
Did your small example contain @el data?
Can you read it back properly?
Andy
>
> 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®
>
Re: update on my Postgres issue
Posted by Andy Seaborne <an...@apache.org>.
On 04/03/13 21:00, David Jordan wrote:
> With the recent error I reported, I was trying to load dbPedia ontology in RDF/XML format.
> This is with Postgres 9.2 and SDB 1.3.6 Snapshot.
>
> Caused by: java.sql.BatchUpdateException: Batch entry 3 INSERT INTO NNodeQuads17852335 VALUES (-5388035591044083834 , '?????????? ???????????????' , 'el' , '' , 3 ) was aborted. Call getNextException to see the cause.
>
> I switched and loaded a small ontology file in TURTLE that had been working in MySQL. It has just 58 nodes and 91 quads. It loaded fine without any problems. So maybe this ontology is so small that it is not triggering batch updates?
This may be caused the database is not setup to be UTF-8 correctly.
It looks as if the string '?????????? ???????????????' is broken
(language code el is modern greek).
Did your small example contain @el data?
Can you read it back properly?
Andy
>
> 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®
>