|Alias for identifier have more than 30 char. ora-00972 identifier too long [message #468186]
||Tue, 04 August 2009 13:13
| Amod M
Registered: July 2009
I am using EclipseLink 1.0.2 on Oracle platform.
I am using ReadAllQuery & to use pagination, I use
I have a column name with 30 chars. So query generated by EclipseLink
generates alias which is more than 30 chars. Hence I am getting error:
ora-00972 identifier is too long.
I am aware of bug which is logged
It mentions workaround as:
But I want to use RownumFiltering.
Attachment in comment #6 of PR 262923 corectly modifies the problem. New
alias name algorithm truncates the column name appropriately if
resulting string would be too long. It indicates that code in
SQLSelectStatement.java, OraclePlatform.java has been modified.
But Target Milestone is mentioned as 2.0. Can I get the fix in EclipseLink
1.0.2 through some patch or other mechanism.
Thanks for any help.
Powered by FUDForum
. Page generated in 0.01547 seconds