jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From KÖLL Claus <C.KO...@TIROL.GV.AT>
Subject jdbc2jcr question
Date Fri, 13 Mar 2009 09:14:55 GMT
hi,

i'm currently playing around with the jdbc2jcr project which should be really cool ;-)

ok but i have a problem running the TestCase.

In the JCRConnection Object while calling createView(JCRView) following sql will be executed

----------
CREATE FUNCTION jdbc2jcr_nt_file ( connectionKey VARCHAR(100), viewKey VARCHAR(100) ) RETURNS
TABLE ( jcr_path VARCHAR(1000), jcr_name VARCHAR(1000), jcr_primaryType VARCHAR(1000), jcr_mixinTypes
VARCHAR(1000), jcr_created TIMESTAMP ) LANGUAGE JAVA PARAMETER STYLE DERBY_JDBC_RESULT_SET
NO SQL EXTERNAL NAME 'org.apache.jackrabbit.jdbc.JCRResultSet.jcrQuery'
---------

but this throws a SQLException:
java.sql.SQLException: Syntax error: Encountered "TABLE" at line 1, column 95.

Can anybody give me a hint what i do wrong ?

greets
claus

Mime
View raw message