openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Donald Woods (JIRA)" <j...@apache.org>
Subject [jira] Updated: (OPENJPA-1725) Schemaname wrongly included in DBDictionary.checkNameLength after Tablename correctly truncated
Date Wed, 14 Jul 2010 15:58:50 GMT

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

Donald Woods updated OPENJPA-1725:
----------------------------------

    Fix Version/s: 1.3.0
                   2.1.0

> 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
>             Fix For: 1.3.0, 2.1.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.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message