Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Alias for identifier have more than 30 char. ora-00972 identifier too long
Alias for identifier have more than 30 char. ora-00972 identifier too long [message #468186] Tue, 04 August 2009 13:13
Amod M is currently offline 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.
Previous Topic:Changes in mutable objects not detected
Next Topic:EclipseLink Expressions - is there a better way to design the DAO?
Goto Forum:
  


Current Time: Thu Oct 02 14:38:53 GMT 2014

Powered by FUDForum. Page generated in 0.02309 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software