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
