Grokbase Groups Cayenne dev July 2008
FAQ
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.

Search Discussions

  • Anonymous at Jul 1, 2008 at 8:23 pm
    [ https://issues.apache.org/cayenne/browse/CAY-1084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12989#action_12989 ]

    Andrus Adamchik commented on CAY-1084:
    --------------------------------------

    I suspected some of the DB's won't like the new syntax.... Actually I think the current mechanism is flexible enough to generate "legacy" joins per adapter.

    OpenBase seems to even support outer joins, via a really weird syntax (from the link you posted) :

    "OpenBase supports left outer joins, meaning that records from tables specified first are included even when they cannot be matched with records from tables on the right. An outer join is specified by using the * operator in place of the = operator in the WHERE statement. Here is an example:

    SELECT mov.TITLE, mov.CATEGORY, stu.NAME FROM MOVIE mov, STUDIO stu WHERE mov.STUDIO_ID * stu.STUDIO_ID "
    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.
  • Anonymous at Jul 1, 2008 at 8:25 pm
    [ https://issues.apache.org/cayenne/browse/CAY-1084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12990#action_12990 ]

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

    So how do I start to "generate "legacy" joins per " this adapter???
    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.
  • Anonymous at Jul 1, 2008 at 8:40 pm
    [ https://issues.apache.org/cayenne/browse/CAY-1084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12991#action_12991 ]

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

    ..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.
  • Anonymous at Jul 1, 2008 at 8:40 pm
    [ 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.
  • Anonymous at Jul 1, 2008 at 8:45 pm
    [ https://issues.apache.org/cayenne/browse/CAY-1084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12992#action_12992 ]

    Mike Kienenberger commented on CAY-1084:
    ----------------------------------------

    In the past, OpenBase has been very good about changing syntax to fit in with standards.

    You might want to drop a line on the openbase dev mailing list.

    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.
  • Anonymous at Jul 3, 2008 at 8:21 pm
    [ https://issues.apache.org/cayenne/browse/CAY-1084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Tore Halset reassigned CAY-1084:
    --------------------------------

    Assignee: Tore Halset
    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.
  • Anonymous at Jul 3, 2008 at 8:29 pm
    [ 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.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdev @
categoriescayenne
postedJul 1, '08 at 8:13p
activeJul 3, '08 at 8:29p
posts8
users1
websitecayenne.apache.org

1 user in discussion

Anonymous: 8 posts

People

Translate

site design / logo © 2022 Grokbase