[
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
