[jira] Assigned: (OPENJPA-648) Table generator uses incorrect schema name

["Michael Dick (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OPENJPA-648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Dick reassigned OPENJPA-648:
------------------------------------

    Assignee: Jeremy Bauer

> Table generator uses incorrect schema name
> ------------------------------------------
>
>                 Key: OPENJPA-648
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-648
>             Project: OpenJPA
>          Issue Type: Sub-task
>          Components: jdbc
>    Affects Versions: 1.0.2, 1.2.0
>            Reporter: Jeremy Bauer
>            Assignee: Jeremy Bauer
>             Fix For: 1.0.3, 1.2.0
>
>         Attachments: OPENJPA-648_1.0.x.patch, OPENJPA-648_1.2.0.patch
>
>
> If a schema name is provided on an entity-level Table annotation and a different schema name is used within a field-level TableGenerator, the mapping tool uses the the schema name provided in the field-level annotation to create the table, but the runtime generates SQL using the schema of the entity-level table annotation.  The result is an exception when the runtime attempts to query the table.
> --- For example:
> @Entity(name="SENTITY")
> @Table(name="SENTITY", schema="TBLSCHEMA")
> public class SingleEntity {
>     @Id
>     @TableGenerator(name = "SID_Gen", table = "ID_Gen", schema="TGSCHEMA",
>             pkColumnName = "GEN_NAME", valueColumnName = "GEN_VAL",
>             pkColumnValue = "ID2", initialValue = 20, allocationSize = 10)
>     @GeneratedValue(strategy = GenerationType.TABLE, generator = "SID_Gen")     
>     private int id;    
> ....
> }
> --- Results in this SQL/exception:
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table/View 'TBLSCHEMA.ID_GEN' does not exist. {SELECT GEN_VAL FROM TBLSCHEMA.ID_Gen WHERE GEN_NAME = ? FOR UPDATE WITH RR} [code=20000, state=42X05]
> The mapping tool creates the id generator table using the correct schema (TGSCHEMA).  
> This issue is being opened as a subtask under OPENJPA-493.  It was found while testing a back-port of the fix made in rev. 610427 to the 1.0.x stream.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.