Greetings!
A generated Oracle select statement below yielded java.sql.SQLException: ORA-00972: identifier is too long. The dialect is set to oracle10 already. Is there any way to control and constrain the generated identifiers. And one more detail. We are using JPA annotations, not XML mapping files. Thanks in advance for any suggestions.
-Aaron
select irgcluster0_.IRG_CLUSTER_ID as IRG1_2_1_, irgcluster0_.CREATED_DATE as CREATED2_2_1_, irgcluster0_.CREATOR_ID as CREATOR3_2_1_, irgcluster0_.LAST_UPD_DATE as LAST4_2_1_, irgcluster0_.LAST_UPD_ID as LAST5_2_1_, irgcluster0_.CLUSTER_IRG_CODE as CLUSTER6_2_1_, irgcluster0_.IRG_CLUSTER_DESC as IRG7_2_1_, irgcluster0_.PHS_ORG_CODE as PHS8_2_1_, components1_.IRG_CLUSTER_ID as IRG1_3_, component2_.IRG_CLUSTER_COMPONENT_ID as components2_3_, component2_.IRG_CLUSTER_COMPONENT_ID as IRG1_1_0_, component2_.CREATED_DATE as CREATED2_1_0_, component2_.CREATOR_ID as CREATOR3_1_0_, component2_.LAST_UPD_DATE as LAST4_1_0_, component2_.LAST_UPD_ID as LAST5_1_0_, component2_.IRG_CLUSTER_ID as IRG7_1_0_, component2_.DEFERRAL_IDENTIFIER_FLAG as DEFERRAL6_1_0_, component2_.SRA_DESIGNATOR as SRA8_1_0_, component2_.SRA_FLEX as SRA9_1_0_, component2_.SRG_CODE as SRG10_1_0_, component2_.SRG_FLEX as SRG11_1_0_ from IRG_CLUSTERS_T irgcluster0_ left outer join IRG_CLUSTERS_T_IRG_CLUSTER_COMPONENTS_T components1_ on irgcluster0_.IRG_CLUSTER_ID = components1_.IRG_CLUSTER_ID left outer join IRG_CLUSTER_COMPONENTS_T component2_ on components1_.components_IRG_CLUSTER_COMPONENT_ID = component2_.IRG_CLUSTER_COMPONENT_ID where irgcluster0_.IRG_CLUSTER_ID = ?
|