-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 15/08/12 21:52, Jayanath Amaranayake wrote: > 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. > So you're getting:
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 Looking at the explanation of ORA-00911 this isn't obvious at all, but I reckon it's the semicolon. Could you try executing the original then the following statement in toad or sqldeveloper? 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 (Just adding a space between 'MODE' and ';') The original parses fine on my work database, but that may be a version issue. We're on 11g. select * from v$version where banner like 'Oracle%'; If both are fine then we'll have to find another way to reproduce the issue. Damian -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlAsvgoACgkQAyLCB+mTtymaHQCfQvUlDLc8GrXXs5fU0eq4hNvW +PsAoKgkSj2ri3nr1WV1YTmoU34R0+Lp =TUIN -----END PGP SIGNATURE-----
