You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cayenne.apache.org by "Tore Halset (JIRA)" <de...@cayenne.apache.org> on 2008/07/01 22:39:52 UTC
[jira] Issue Comment Edited: (CAY-1084) openbase does not like our
join syntax :(
[ https://issues.apache.org/cayenne/browse/CAY-1084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12991#action_12991 ]
halset edited comment on CAY-1084 at 7/1/08 1:39 PM:
----------------------------------------------------------
..Probably by subclassing JoinStack and also make it possible for the JoinStack to output stuff after "WHERE" in the SelectTranslator.
was (Author: halset):
..Probably by subclassing JoinStack and also make it possible for the JoinStack to output stuff after "WHERE".
> 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.