Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openjpa.apache.org
Date: Thu, 1 Mar 2012 14:37:56 +0000 (UTC)
From: "aabbcc (Commented) (JIRA)" <jira@apache.org>
To: dev@openjpa.apache.org
Message-ID: 
 <1856495318.7361.1330612676761.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <1885842879.7162.1330608478715.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Commented] (OPENJPA-2148) Issue with MaxColumnNameLength in
 the OracleDictionary class
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

aabbcc commented on OPENJPA-2148:
---------------------------------

Its Oracle version 11. There are few column names with 30 characters in length. It seems OpenJPA considers start & end quotes as well while counting column name length therefore this issue is arising. Even I tried with different combination of characters.

Its bug in OpenJPA.

                
> Issue with MaxColumnNameLength in the OracleDictionary class
> ------------------------------------------------------------
>
>                 Key: OPENJPA-2148
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2148
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 2.1.1
>            Reporter: aabbcc
>            Priority: Blocker
>
> I am using oracle database with OpenJPA.
> The DBDictionary class defines default MaxColumnNameLength as 128.
> But In the OracleDictionary class which extend DBDictionary has MaxColumnNameLength as 30. While generating sql query, JPA takes first 28 characters of the column name and ignores rest of the characters. Also it takes start & end quotes, which in total makes it to 30 characters
> Due to this, jpa query fails if there are column in the oracle database with more than 28 characters as it finds mismatch in SQL query and actual column name.  
> Please fix this issue by changing MaxColumnNameLength in OracleDictionary class to 128.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira