jena-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Spreitzer <mspre...@us.ibm.com>
Subject sdbtest uses "LIMIT"
Date Thu, 10 Feb 2011 00:39:57 GMT
I am starting to use Jena.  I picked SDB.  I follow the instructions at 
http://openjena.org/wiki/SDB/Commands#Testing and get an SQL syntax error. 
 The test in Modifiers/slice1 (and some other slices too) issues the 
following SQL statement:

SELECT R_1.lex AS V_1_lex, R_1.datatype AS V_1_datatype, R_1.lang AS 
V_1_lang, R_1.type AS V_1_type, R_1.lex AS V_2_lex, R_1.datatype AS 
V_2_datatype, R_1.lang AS V_2_lang, R_1.type AS V_2_type
FROM
    Triples AS T_1
  LEFT OUTER JOIN
    Nodes AS R_1
  ON ( T_1.p = R_1.hash )
LIMIT 3

Sadly, that LIMIT clause is not standard SQL syntax --- and is not 
accepted by the database I am using (DB2 v9.7).  Is this a problem only 
with the test or can I expect problems in real usage?  Is there a known 
work-around for those of us using DB2?

Thanks,
Mike Spreitzer
SMTP: mspreitz@us.ibm.com, Lotus Notes: Mike Spreitzer/Watson/IBM
Office phone: +1-914-784-6424 (IBM T/L 863-)
AOL Instant Messaging: M1k3Sprtzr
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message