openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dave Chen (JIRA)" <>
Subject [jira] [Commented] (OPENJPA-2387) Schema name is incorrectly included in length of Sequence name.
Date Fri, 28 Feb 2014 19:10:19 GMT


Dave Chen commented on OPENJPA-2387:

Hi, we are currently using version 2.2.2 and facing the same issue. When the binary patch
version will be released? Thanks in advance!

> Schema name is incorrectly included in length of Sequence name.
> ---------------------------------------------------------------
>                 Key: OPENJPA-2387
>                 URL:
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 2.2.2,, 2.3.0
>            Reporter: Heath Thomann
>            Assignee: Heath Thomann
>         Attachments: OPENJPA-2387-2.2.1.x.patch
> Take the following entity definition:
> @Entity @Table(name="LONG_NAME_ENTITY")
> @SequenceGenerator(name="longSequenceNameSequence",sequenceName="A_TWENTY_NINE_CHAR_LENGTH_SEQ")
> public class LongSequenceNameEntity implements Serializable
> As can be seen, a Sequence is defined with a name which is 29 characters long.  On a
Database such as Oracle which has a 30 character limit on sequence names, among others names,
this sequence is perfectly legal.  However, when a schema name is tacked onto this by OpenJPA,
OpenJPA code incorrectly counts the characters of the schema in the length of the sequence
name.   As such, the following exception will occur:
> Caused by: <openjpa- nonfatal user error> org.apache.openjpa.persistence.ArgumentException:
Sequence name "HTHOMANN.A_TWENTY_NINE_CHAR_LENGTH_SEQ" is 38-character long. The database
allows maximum 30-character for a sequence name.
> 	at org.apache.openjpa.jdbc.sql.DBDictionary.checkNameLength(
> 	at org.apache.openjpa.jdbc.sql.DBDictionary.commonCreateAlterSequenceSQL(
> 	at org.apache.openjpa.jdbc.sql.DBDictionary.getAlterSequenceSQL(
> The DBDictionary.checkNameLength in this case is counting the characters of the schema
name, and sequence name.  The length of the schema name should not be included in the length
of the sequence.

This message was sent by Atlassian JIRA

View raw message