[OPENJPA-1037] queries don't use catalog name, desirable for sybase DB

• Type: Wish
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: query
• Environment: BEA weblogic, Sybase DB
• Assignee: Unassigned
• Reporter: Mark Duville
• Created: 14/Apr/09 16:38
• Updated: 15/Apr/09 14:14

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.

Issue Links

• relates to: OPENJPA-840 OpenJPA does not fully support database catalogs