[jira] Commented: (OPENJPA-594) Incorrect schema separator used for Informix tables

["Pinaki Poddar (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OPENJPA-594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12595396#action_12595396 ] 

Pinaki Poddar commented on OPENJPA-594:
---------------------------------------

The properties of a database dictionary are highly configurable and hence the following persistence.xml configuration may attain the the same effect without any code change
 
      <property name="openjpa.jdbc.DBDictionary" value="informix(CatalogSeparator='.'")/>


> Incorrect schema separator used for Informix tables
> ---------------------------------------------------
>
>                 Key: OPENJPA-594
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-594
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc
>    Affects Versions: 1.0.2
>            Reporter: Dinkar Rao
>            Assignee: Michael Dick
>         Attachments: patch-594.txt
>
>   Original Estimate: 0h
>  Remaining Estimate: 0h
>
> With Informix IDS 9.4 (or 10.0), when a schema  is specified in the table annotation or in the openjpa.jdbc.schema property, a SQL for CREATE TABLE with invalid syntax is generated:
> CREATE TABLE MYSCHEMA:MYTABLE (...);
> The correct separator between the schema and the table is "dot".

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