Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-1084

openbase does not like our join syntax :(

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.0
    • Fix Version/s: None
    • Component/s: Database integration
    • Labels:
      None
    • Environment:
      OpenBase 10.0.11

      Description

      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

        Attachments

          Activity

            People

            • Assignee:
              halset Tore Halset
              Reporter:
              halset Tore Halset
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: