[jira] Commented: (CAY-1084) openbase does not like our join syntax :(

From: Tore Halset (JIRA) ("Tore)
Date: Thu Jul 03 2008 - 16:28:52 EDT

  • Next message: Marcin Skladaniec (JIRA): "[jira] Updated: (CAY-794) Abstract objEntities"

        [ https://issues.apache.org/cayenne/browse/CAY-1084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12998#action_12998 ]

    Tore Halset commented on CAY-1084:
    ----------------------------------

    I have joined the list, but is not able to post as I do not know what the mail adr is. Really strange. Will do.

    Added support for the current OpenBase join syntax. It still fails some tests as the outer joins behaves a little different. It looks like checking for null does not work if you want rows that does not have a related row on the right side of the join. or so.

    Will keep this one open a little while to see what happens..

    > 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
    > Assignee: 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 : Thu Jul 03 2008 - 16:29:51 EDT