| Alias for identifier have more than 30 char. ora-00972 identifier too long [message #468186] |
Tue, 04 August 2009 13:13 |
 Amod M
Messages: 11
Registered: July 2009 |
Junior Member |
|
|
Hi,
I am using EclipseLink 1.0.2 on Oracle platform.
I am using ReadAllQuery & to use pagination, I use
ReadAllQuery.setMaxRows(100)
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
https://bugs.eclipse.org/bugs/show_bug.cgi?id=262923
It mentions workaround as:
oraclePlatform.setShouldUseRownumFiltering(false);
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.
Regards.
|
|
|
Powered by
FUDForum. Page generated in 0.03371 seconds
] 
Search
Help
Register
Login
Home
