Thanks Andy.
I tried to use the snap shot but getting the following error with Oracle XE
11g.
The same code works just fine with MySQL.
My code:
Store store = StoreFactory.create("sdb-oracle.ttl");
store.getTableFormatter().create();
Model model = SDBFactory.connectDefaultModel(store);
InputStream is =
FileManager.get().open("ontologies/SampleOntology.turtle");
*model.read(is,null,"TURTLE"); // this is where it fails*
String queryString = "SELECT * { ?s ?p ?o }" ;
Query query = QueryFactory.create(queryString) ;
Dataset ds = DatasetStore.create(store) ;
QueryExecution qe = QueryExecutionFactory.create(query, ds) ;
try { ResultSet rs = qe.execSelect() ;
ResultSetFormatter.out(rs) ;
} finally {
qe.close() ;
}
store.getConnection().close() ;
store.close() ;
The error:
java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
I attached the stack trace and the sample ontology file that I use, hoping
that it could be helpful.
Is there any database specific configuration that I missed?. Any thoughts?
Thanks in advance for any help on this.
Jay
On Tue, Aug 14, 2012 at 5:36 PM, Andy Seaborne <[email protected]> wrote:
> On 14/08/12 20:39, Jayanath Amaranayake wrote:
>
>> Hi all,
>> I'm trying to store my RDF models in an Oracle DB. I know that I have to
>> use SDB with Jena. However the latest Jena download bundle does not have
>> SDB at the moment. Has anyone used Jena 2.7.2 with SDB 1.3.4. It seems
>> like
>> the SDB 1.3.4 had been released with the older Jena 2.6.4.
>>
>> Thanks in advance for any help.
>>
>> Jay
>>
>
> It may work but there was quite a gap between jena versions 2.6.4 and
> 2.7.2. I'd be interesting in hearing if it works.
>
> I have just updated SDB and there is a development build with current
> dependencies:
>
> http://s.apache.org/jena-sdb-**1.3.5-SNAPSHOT<http://s.apache.org/jena-sdb-1.3.5-SNAPSHOT>
>
> Dependencies:
>
> jena-sdb 1.3.5-SNAPSHOT
> jena-parent: 3
> jena-core: 2.7.3
> jena-arq: 2.9.3
>
> Andy
>
>
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/C:/_Tools/Other/logback-1.0.6/logback-1.0.6/logback-classic-1.0.6.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/C:/_Tools/SemanticWeb/apache-jena-sdb-1.3.5-SNAPSHOT/lib/slf4j-log4j12-1.6.4.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type
[ch.qos.logback.classic.selector.DefaultContextSelector]
11:40:12.855 [main] DEBUG com.hp.hpl.jena.sparql.mgt.ARQMgt - Register MBean:
com.hp.hpl.jena.sparql.system:type=Context
11:40:12.887 [main] DEBUG com.hp.hpl.jena.sparql.mgt.ARQMgt - Register MBean:
com.hp.hpl.jena.sparql.system:type=Engine
11:40:13.862 [main] DEBUG com.hp.hpl.jena.sparql.mgt.ARQMgt - Register MBean:
com.hp.hpl.jena.sparql.system:type=SystemInfo
11:40:13.882 [main] DEBUG com.hp.hpl.jena.sparql.mgt.ARQMgt - Register MBean:
com.hp.hpl.jena.sparql.system:type=SystemInfo
11:40:13.893 [main] DEBUG com.hp.hpl.jena.sparql.mgt.ARQMgt - Register MBean:
org.openjena.riot.system:type=SystemInfo
11:40:14.150 [main] DEBUG com.hp.hpl.jena.sparql.mgt.ARQMgt - Register MBean:
com.hp.hpl.jena.sdb.system:type=SystemInfo
11:40:14.324 [main] DEBUG com.hp.hpl.jena.util.FileManager - Add location:
LocatorFile
11:40:14.325 [main] DEBUG com.hp.hpl.jena.util.FileManager -
loadModel(sdb-oracle.ttl)
11:40:14.325 [main] DEBUG com.hp.hpl.jena.util.FileManager - Syntax guess:
TURTLE
11:40:14.329 [main] DEBUG com.hp.hpl.jena.util.FileManager - Found:
sdb-oracle.ttl (LocatorFile)
11:40:14.700 [main] DEBUG com.hp.hpl.jena.util.FileManager - Add location:
LocatorFile
11:40:14.702 [main] DEBUG com.hp.hpl.jena.util.FileManager - Add location:
ClassLoaderLocator
11:40:14.706 [main] DEBUG com.hp.hpl.jena.util.LocationMapper - Failed to find
configuration:
file:location-mapping.rdf;file:location-mapping.n3;file:location-mapping.ttl;file:etc/location-mapping.rdf;file:etc/location-mapping.n3;file:etc/location-mapping.ttl
11:40:14.707 [main] DEBUG com.hp.hpl.jena.util.FileManager - Add location:
LocatorFile
11:40:14.708 [main] DEBUG com.hp.hpl.jena.util.FileManager - Add location:
LocatorURL
11:40:14.709 [main] DEBUG com.hp.hpl.jena.util.FileManager - Add location:
ClassLoaderLocator
11:40:14.710 [main] DEBUG com.hp.hpl.jena.util.FileManager -
loadModel(vocabularies/assembler.n3)
11:40:14.711 [main] DEBUG com.hp.hpl.jena.util.FileManager - Not mapped:
vocabularies/assembler.n3
11:40:14.711 [main] DEBUG com.hp.hpl.jena.util.FileManager - Syntax guess: N3
11:40:14.714 [main] DEBUG com.hp.hpl.jena.util.FileManager - Found:
vocabularies/assembler.n3 (ClassLoaderLocator)
11:40:15.228 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?a
rdfs:isDefinedBy ?b) -> (?a rdfs:seeAlso ?b) ]
11:40:15.229 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdf:rest ?y) -> (?y rdf:type rdf:List) ]
11:40:15.230 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdfs:label ?y) -> (?y rdf:type rdfs:Literal) ]
11:40:15.231 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdfs:comment ?y) -> (?y rdf:type rdfs:Literal) ]
11:40:15.232 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdfs:range ?y) -> (?y rdf:type rdfs:Class) ]
11:40:15.234 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdfs:domain ?y) -> (?y rdf:type rdfs:Class) ]
11:40:15.235 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdfs:subClassOf ?y) -> (?y rdf:type rdfs:Class) ]
11:40:15.236 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdfs:subPropertyOf ?y) -> (?y rdf:type rdf:Property) ]
11:40:15.238 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdf:rest ?y) -> (?x rdf:type rdf:List) ]
11:40:15.239 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdf:first ?y) -> (?x rdf:type rdf:List) ]
11:40:15.240 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdf:object ?y) -> (?x rdf:type rdf:Statement) ]
11:40:15.241 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdf:predicate ?y) -> (?x rdf:type rdf:Statement) ]
11:40:15.242 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdf:subject ?y) -> (?x rdf:type rdf:Statement) ]
11:40:15.243 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdfs:range ?y) -> (?x rdf:type rdf:Property) ]
11:40:15.244 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdfs:domain ?y) -> (?x rdf:type rdf:Property) ]
11:40:15.245 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdfs:subClassOf ?y) -> (?x rdf:type rdfs:Class) ]
11:40:15.246 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdfs:subPropertyOf ?y) -> (?x rdf:type rdf:Property) ]
11:40:15.250 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
rdf:type ?y) -> (?y rdf:type rdfs:Class) ]
11:40:15.325 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?a
rdfs:isDefinedBy ?b) -> (?a rdfs:seeAlso ?b) ]
11:40:15.326 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#content ?y) -> (?y rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#Content) ]
11:40:15.327 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#subModel ?y) -> (?y rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#Model) ]
11:40:15.328 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#reificationMode ?y) -> (?y rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#ReificationMode) ]
11:40:15.329 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#prefixMapping ?y) -> (?y rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#PrefixMapping) ]
11:40:15.331 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#locationMapper ?y) -> (?y rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#LocationMapper) ]
11:40:15.332 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#rules ?y) -> (?y rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#RuleSet) ]
11:40:15.334 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#reasonerFactory ?y) -> (?y rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#ReasonerFactory) ]
11:40:15.335 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#ontModelSpec ?y) -> (?y rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#OntModelSpec) ]
11:40:15.336 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#baseModel ?y) -> (?y rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#Model) ]
11:40:15.337 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#includes ?y) -> (?y rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#PrefixMapping) ]
11:40:15.338 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#reasoner ?y) -> (?y rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#ReasonerFactory) ]
11:40:15.339 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#rootModel ?y) -> (?y rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#Model) ]
11:40:15.340 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#initialContent ?y) -> (?y rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#Content) ]
11:40:15.341 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#schema ?y) -> (?y rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#Model) ]
11:40:15.342 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#fileManager ?y) -> (?y rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#FileManager) ]
11:40:15.359 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#contentEncoding ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#ContentItem) ]
11:40:15.361 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#literalContent ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#ContentItem) ]
11:40:15.362 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#fileManager ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#HasFileManager) ]
11:40:15.363 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#rule ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#HasRules) ]
11:40:15.364 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#reasoner ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#InfModel) ]
11:40:15.365 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#baseModel ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#InfModel) ]
11:40:15.366 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#modelName ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#NamedModel) ]
11:40:15.367 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2004/08/location-mapping#mapping ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#LocationMapper) ]
11:40:15.368 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#schema ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#ReasonerFactory) ]
11:40:15.369 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#subModel ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#UnionModel) ]
11:40:15.370 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#ontLanguage ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#OntModelSpec) ]
11:40:15.372 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#documentManager ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#OntModelSpec) ]
11:40:15.373 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#likeBuiltinSpec ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#OntModelSpec) ]
11:40:15.374 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#directory ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#FileModel) ]
11:40:15.375 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#reificationMode ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#Model) ]
11:40:15.376 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#reasonerClass ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#ReasonerFactory) ]
11:40:15.377 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#policyPath ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#DocumentManager) ]
11:40:15.378 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#reasonerURL ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#ReasonerFactory) ]
11:40:15.379 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#externalContent ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#ContentItem) ]
11:40:15.381 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#importSource ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#OntModelSpec) ]
11:40:15.382 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#rootModel ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#UnionModel) ]
11:40:15.383 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#mapName ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#FileModel) ]
11:40:15.384 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#rulesFrom ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#HasRules) ]
11:40:15.385 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#includes ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#PrefixMapping) ]
11:40:15.386 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#prefix ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#SinglePrefixMapping) ]
11:40:15.387 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#namespace ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#SinglePrefixMapping) ]
11:40:15.388 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#initialContent ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#Loadable) ]
11:40:15.389 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#content ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#Loadable) ]
11:40:15.390 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#locationMapper ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#FileManager) ]
11:40:15.391 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#ontModelSpec ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#OntModel) ]
11:40:15.393 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#prefixMapping ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#Model) ]
11:40:15.394 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#reasonerFactory ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#OntModelSpec) ]
11:40:15.395 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#rules ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#HasRules) ]
11:40:15.396 [main] DEBUG c.h.h.j.r.rulesys.FBRuleInfGraph - Adding rule [ (?x
http://jena.hpl.hp.com/2005/11/Assembler#fileEncoding ?y) -> (?x rdf:type
http://jena.hpl.hp.com/2005/11/Assembler#FileModel) ]
11:40:16.303 [main] DEBUG com.hp.hpl.jena.sdb.sql.JDBC - Create JDBC URL:
(type=oracle, host=localhost:1521, dbName=XE)
11:40:16.303 [main] DEBUG com.hp.hpl.jena.sdb.sql.JDBC - Create JDBC
connection: jdbc:oracle:thin:@localhost:1521:XE
11:42:19.780 [main] DEBUG com.hp.hpl.jena.shared.LockMRSW - Lock : main
11:42:19.781 [main] DEBUG com.hp.hpl.jena.shared.LockMRSW - Lock : main
11:42:19.977 [main] DEBUG com.hp.hpl.jena.shared.LockMRSW - Lock : main
11:42:26.495 [main] DEBUG com.hp.hpl.jena.util.FileManager -
open(ontologies/SampleOntology.turtle)
11:42:26.496 [main] DEBUG com.hp.hpl.jena.util.FileManager - Not mapped:
ontologies/SampleOntology.turtle
11:42:26.499 [main] DEBUG com.hp.hpl.jena.util.FileManager - Found:
ontologies/SampleOntology.turtle (LocatorFile)
11:44:16.929 [main] DEBUG c.h.h.j.s.layout2.LoaderTuplesNodes - Threading
started
11:44:16.931 [Thread-1] DEBUG c.h.h.j.s.layout2.LoaderTuplesNodes - Running
loader thread
11:44:17.154 [Thread-1] WARN c.hp.hpl.jena.sdb.sql.SDBConnection - execUpdate:
SQLException
ORA-00911: invalid character
LOCK TABLE Nodes IN EXCLUSIVE MODE; INSERT INTO Nodes (hash, lex, lang,
datatype, type)
SELECT NNodeTriples.n0 , NNodeTriples.n1 , NNodeTriples.n2 , NNodeTriples.n3 ,
NNodeTriples.n4
FROM NNodeTriples LEFT JOIN Nodes ON (NNodeTriples.n0=Nodes.hash)
WHERE Nodes.hash IS NULL
11:44:17.164 [Thread-1] ERROR c.h.h.j.s.layout2.LoaderTuplesNodes - Error in
thread: Exception flushing
com.hp.hpl.jena.sdb.SDBException: Exception flushing
at
com.hp.hpl.jena.sdb.layout2.TupleLoaderBase.flush(TupleLoaderBase.java:234)
~[jena-sdb-1.3.5-SNAPSHOT.jar:1.3.5-SNAPSHOT]
at
com.hp.hpl.jena.sdb.layout2.TupleLoaderBase.finish(TupleLoaderBase.java:169)
~[jena-sdb-1.3.5-SNAPSHOT.jar:1.3.5-SNAPSHOT]
at
com.hp.hpl.jena.sdb.layout2.LoaderTuplesNodes.commitTuples(LoaderTuplesNodes.java:306)
~[jena-sdb-1.3.5-SNAPSHOT.jar:1.3.5-SNAPSHOT]
at
com.hp.hpl.jena.sdb.layout2.LoaderTuplesNodes.access$100(LoaderTuplesNodes.java:43)
~[jena-sdb-1.3.5-SNAPSHOT.jar:1.3.5-SNAPSHOT]
at
com.hp.hpl.jena.sdb.layout2.LoaderTuplesNodes$Commiter.run(LoaderTuplesNodes.java:346)
~[jena-sdb-1.3.5-SNAPSHOT.jar:1.3.5-SNAPSHOT]
at java.lang.Thread.run(Unknown Source) [na:1.6.0_30]
Caused by: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
~[ojdbc6.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
~[ojdbc6.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
~[ojdbc6.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
~[ojdbc6.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
~[ojdbc6.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
~[ojdbc6.jar:11.2.0.2.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1822)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1787)
~[ojdbc6.jar:11.2.0.2.0]
at
oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:280)
~[ojdbc6.jar:11.2.0.2.0]
at
com.hp.hpl.jena.sdb.sql.SDBConnection.execUpdate(SDBConnection.java:163)
~[jena-sdb-1.3.5-SNAPSHOT.jar:1.3.5-SNAPSHOT]
at
com.hp.hpl.jena.sdb.layout2.TupleLoaderBase.flush(TupleLoaderBase.java:216)
~[jena-sdb-1.3.5-SNAPSHOT.jar:1.3.5-SNAPSHOT]
... 5 common frames omitted
Exception in thread "main" com.hp.hpl.jena.sdb.SDBException: Exception flushing
at
com.hp.hpl.jena.sdb.layout2.TupleLoaderBase.flush(TupleLoaderBase.java:234)
at
com.hp.hpl.jena.sdb.layout2.TupleLoaderBase.finish(TupleLoaderBase.java:169)
at
com.hp.hpl.jena.sdb.layout2.LoaderTuplesNodes.commitTuples(LoaderTuplesNodes.java:306)
at
com.hp.hpl.jena.sdb.layout2.LoaderTuplesNodes.access$100(LoaderTuplesNodes.java:43)
at
com.hp.hpl.jena.sdb.layout2.LoaderTuplesNodes$Commiter.run(LoaderTuplesNodes.java:346)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
at
oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1822)
at
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1787)
at
oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:280)
at
com.hp.hpl.jena.sdb.sql.SDBConnection.execUpdate(SDBConnection.java:163)
at
com.hp.hpl.jena.sdb.layout2.TupleLoaderBase.flush(TupleLoaderBase.java:216)
... 5 more
