openbase does not like our join syntax :(
-----------------------------------------
Key: CAY-1084
URL: https://issues.apache.org/cayenne/browse/CAY-1084
Project: Cayenne
Issue Type: Bug
Components: Cayenne Core Library
Affects Versions: 3.0
Environment: OpenBase 10.0.11
Reporter: Tore Halset
Hello.
Just tried the junit tests on OpenBase and it did not work very well. A lot of the problems is from the join syntax that OpenBase seem to have problems with.
INFO: SELECT t0.COLLECTION_TO_MANY_ID, t0.ID FROM COLLECTION_TO_MANY_TARGET t0 JOIN COLLECTION_TO_MANY t1 ON (t0.COLLECTION_TO_MANY_ID = t1.ID) WHERE t1.ID = ? [bind: 1->ID:1]
INFO: *** error.
java.sql.SQLException: SQL ERROR - [position 72, near 'JOIN' in '_TARGET t0 JOIN COLLECTIO'] comma or JOIN syntax expected but not found in from clause.
SQL: SELECT t0.COLLECTION_TO_MANY_ID, t0.ID FROM COLLECTION_TO_MANY_TARGET t0 JOIN COLLECTION_TO_MANY t1 ON (t0.COLLECTION_TO_MANY_ID = t1.ID) WHERE t1.ID = 1
at com.openbase.net.c.a(Unknown Source)
at com.openbase.jdbc.c.a(Unknown Source)
at com.openbase.jdbc.c.a(Unknown Source)
at com.openbase.jdbc.i.executeQuery(Unknown Source)
at org.apache.cayenne.access.jdbc.SelectAction.performAction(SelectAction.java:73)
This looks like the documentation for select statements including join. The "JOIN" keyword is not shown at all.
http://www.openbase.com/help/KnowledgeBase/400_OpenBaseSQL/401_SelectStatements.html
-- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
This archive was generated by hypermail 2.0.0 : Tue Jul 01 2008 - 16:13:51 EDT