Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-1037

queries don't use catalog name, desirable for sybase DB

Agile BoardAttach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Wish
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • query
    • None
    • BEA weblogic, Sybase DB

    Description

      in DB-queries the catalog name is never used, like in "select * from mycatalog..MyTable where ..."
      This is unfortunate with Sybase (where catalogs are heavily used), because it forces one to have multiple persistence units, one for each catalog.
      And when I want a relation to an entity mapped to a table in a different catalog, I get an SQL-exception, since the 2nd table cannot be found (in the same catalog).
      This could be solved by prepending the catalog to the table name.

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            uz-mark Mark Duville

            Dates

              Created:
              Updated:

              Slack

                Issue deployment