openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dick (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (OPENJPA-1725) Schemaname wrongly included in DBDictionary.checkNameLength after Tablename correctly truncated
Date Wed, 04 May 2011 14:42:04 GMT

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

Michael Dick reassigned OPENJPA-1725:
-------------------------------------

    Assignee: Michael Dick

> Schemaname wrongly included in DBDictionary.checkNameLength after Tablename correctly
truncated
> -----------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-1725
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1725
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 1.2.2, 1.3.0, 2.0.0, 2.1.0
>         Environment: Linux, J2SE, OracleDB 10.2.0.1, JDBC drivers 10.2.0.1, 11.2.0.1,
10.2.0.4, OpenJPA versions as listed above
>            Reporter: Joerg Knoche
>            Assignee: Michael Dick
>             Fix For: 2.2.0
>
>
> While enhancing and mapping files for an Oracle database the tablenames are correctly
truncated after 30 characters (or whatever I write as maxTableNameLenght in the DBDictionary),
the check in DBDictionary.checkNameLength includes the name of the schema which is used, therefore
exceeding and failing the check for 30 characters by (length of schemaname +1) (see exception
below). 
> Exception in thread "main" <openjpa-2.0.0-r422266:935683 nonfatal user error> org.apache.openjpa.util.UserException:
Table name "TEST.LS_DETPOINT_WITH_ORIENTATIONDA" is 35-character long. The database allows
maximum 30-character for a table name.
>      [java]     at org.apache.openjpa.jdbc.sql.DBDictionary.checkNameLength(DBDictionary.java:5215)
>      [java]     at org.apache.openjpa.jdbc.sql.DBDictionary.getCreateTableSQL(DBDictionary.java:3304)
>      [java]     at org.apache.openjpa.jdbc.sql.OracleDictionary.getCreateTableSQL(OracleDictionary.java:899)
>      [java]     at org.apache.openjpa.jdbc.schema.SchemaTool.createTable(SchemaTool.java:956)

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message