Hi ,

I am getting the following Error

net.sf.hibernate.JDBCException: could not initialize collection which is being caused by

Caused by: java.sql.SQLException: ORA-00911: invalid character

The error is due to special character "_" which is being appended before field names ( table aliases) like _brokerage0_ in attached trace.

Please let me know if anybody has the solution for this.

Jayant


Hibernate: select _brokerage0_.ID as ID__, _brokerage0_.SPLIT_ID as SPLIT_ID__, broker1_.ID as ID0_, broker1_.UPDATED_BY as UPDATED_BY0_, broker1_.CREATED_BY as CREATED_BY0_, broker1_.UPDATED_ON as UPDATED_ON0_, broker1_.CREATED_ON as CREATED_ON0_, broker1_.LONGNAME as LONGNAME0_, broker1_.SHORTNAME as SHORTNAME0_, broker1_.ACTIVE as ACTIVE0_, expense2_.COST_ID as COST_ID1_, expense2_.INCLUDEDINCONTRACT_FLAG as INCLUDE23_1_, expense2_.PAYABLE_FLAG as PAYABLE24_1_, expense2_.RECEIVABLE_FLAG as RECEIVA25_1_, expense2_.ACTIVE as ACTIVE1_, expense2_.COMMENTS as COMMENTS1_, expense2_.AMOUNT as AMOUNT1_, expense2_.CURRENCY_ID as CURRENCY4_1_, expense2_.UNIT_ID as UNIT_ID1_, expense2_.TYPE as TYPE1_, expense2_.EXCHANGE_RATE as EXCHANGE7_1_, expense2_.SPLIT_ID as SPLIT_ID1_, expense2_.CREATED_BY as CREATED_BY1_, expense2_.UPDATED_BY as UPDATED_BY1_, expense2_.CREATED_ON as CREATED_ON1_, expense2_.UPDATED_ON as UPDATED_ON1_, currency3_.ID as ID2_, currency3_.UPDATED_BY as UPDATED_BY2_, currency3_.CREATED_BY as CREATED_BY2_, currency3_.UPDATED_DATE as UPDATED_4_2_, currency3_.CREATED_DATE as CREATED_5_2_, currency3_.LONGNAME as LONGNAME2_, unitofmeas4_.ID as ID3_, unitofmeas4_.UPDATED_BY as UPDATED_BY3_, unitofmeas4_.CREATED_BY as CREATED_BY3_, unitofmeas4_.UPDATED_ON as UPDATED_ON3_, unitofmeas4_.CREATED_ON as CREATED_ON3_, unitofmeas4_.LONGNAME as LONGNAME3_, split5_.SPLIT_ID as SPLIT_ID4_, split5_.SPLIT_CODE as SPLIT_CODE4_, split5_.SPLIT_SEQUENCE_NUMBER as SPLIT_SE3_4_, split5_.COMMODITY_CONTEXT_ID as COMMODIT4_4_, split5_.DELIVERY_ID as DELIVERY5_4_, split5_.MISC_ITEMS_ID as MISC_ITE6_4_, split5_.STATUS_ID as STATUS_ID4_, split5_.CONTRACT_ID as CONTRACT8_4_, split5_.UPDATED_BY as UPDATED_BY4_, split5_.CREATED_BY as CREATED_BY4_, split5_.UPDATED_ON as UPDATED_ON4_, split5_.CREATED_ON as CREATED_ON4_, commodityc6_.ID as ID5_, commodityc6_.COMMODITY_GROUP_ID as COMMODIT2_5_, commodityc6_.COMMODITY_ID as COMMODIT3_5_, commodityc6_.CROP_YEAR as CROP_YEAR5_, commodityc6_.BASELOCATION_ID as BASELOCA5_5_, commodityc6_.COMMENTS as COMMENTS5_, commodityc6_.PACKING_COMMENTS as PACKING_7_5_, commodityc6_.SPECIFICATION_COMMENTS as SPECIFIC8_5_, commodityc6_.PACKINGTYPE_ID as PACKINGT9_5_, commodityc6_.ORIGIN_COUNTRY_ID as ORIGIN_10_5_, commodityc6_.QUANTITY_ID as QUANTIT11_5_, commodityc6_.UPDATED_BY as UPDATED_BY5_, commodityc6_.CREATED_BY as CREATED_BY5_, commodityc6_.UPDATED_ON as UPDATED_ON5_, commodityc6_.CREATED_ON as CREATED_ON5_, commodityg7_.ID as ID6_, commodityg7_.LONGNAME as LONGNAME6_, commodity8_.ID as ID7_, commodity8_.GROUP_ID as GROUP_ID7_, commodity8_.SHORTNAME as SHORTNAME7_, commodity8_.LONGNAME as LONGNAME7_, commodity8_.CREATED_BY as CREATED_BY7_, commodity8_.CREATED_ON as CREATED_ON7_, commodity8_.UPDATED_BY as UPDATED_BY7_, commodity8_.UPDATED_ON as UPDATED_ON7_, packingtyp9_.ID as ID8_, packingtyp9_.UPDATED_BY as UPDATED_BY8_, packingtyp9_.CREATED_BY as CREATED_BY8_, packingtyp9_.UPDATED_ON as UPDATED_ON8_, packingtyp9_.CREATED_ON as CREATED_ON8_, packingtyp9_.LONGNAME as LONGNAME8_, packingtyp9_.SHORTNAME as SHORTNAME8_, country10_.ID as ID9_, country10_.SHORTNAME as SHORTNAME9_, commodityq11_.ID as ID10_, commodityq11_.EXECUTED_QUANTITY as EXECUTE10_10_, commodityq11_.CANCELLED_QUANTITY as CANCELL11_10_, commodityq11_.TOLERANCE_ID as TOLERAN12_10_, commodityq11_.MEAN_MIN_QUANTITY as MEAN_MIN3_10_, commodityq11_.MAX_QUANTITY as MAX_QUAN4_10_, commodityq11_.UNIT_ID as UNIT_ID10_, commodityq11_.UPDATED_BY as UPDATED_BY10_, commodityq11_.CREATED_BY as CREATED_BY10_, commodityq11_.UPDATED_ON as UPDATED_ON10_, commodityq11_.CREATED_ON as CREATED_ON10_, tolerancet12_.ID as ID11_, tolerancet12_.UPDATED_BY as UPDATED_BY11_, tolerancet12_.CREATED_BY as CREATED_BY11_, tolerancet12_.UPDATED_ON as UPDATED_ON11_, tolerancet12_.CREATED_ON as CREATED_ON11_, tolerancet12_.LONGNAME as LONGNAME11_, tolerancet12_.SHORTNAME as SHORTNAME11_, tolerancet12_.VALUE as VALUE11_, tolerancet12_.OPERATION as OPERATION11_, unitofmeas13_.ID as ID12_, unitofmeas13_.UPDATED_BY as UPDATED_BY12_, unitofmeas13_.CREATED_BY as CREATED_BY12_, unitofmeas13_.UPDATED_ON as UPDATED_ON12_, unitofmeas13_.CREATED_ON as CREATED_ON12_, unitofmeas13_.LONGNAME as LONGNAME12_, delivery14_.ID as ID13_, delivery14_.TYPE_ID as TYPE_ID13_, delivery14_.PERIOD_ID as PERIOD_ID13_, delivery14_.MULTIPLE_PORTS_FLAG as MULTIPLE4_13_, delivery14_.TOLERANCEOPTIONTYPE_ID as TOLERANC5_13_, delivery14_.COMMENTS as COMMENTS13_, delivery14_.VESSEL_NAME as VESSEL_N7_13_, delivery14_.DEST_COUNTRY as DEST_COU8_13_, delivery14_.TRANSPORTATIONTYPE_ID as TRANSPOR9_13_, delivery14_.PARITY_ID as PARITY_ID13_, delivery14_.UPDATED_BY as UPDATED_BY13_, delivery14_.CREATED_BY as CREATED_BY13_, delivery14_.UPDATED_ON as UPDATED_ON13_, delivery14_.CREATED_ON as CREATED_ON13_, deliveryty15_.ID as ID14_, deliveryty15_.UPDATED_BY as UPDATED_BY14_, deliveryty15_.CREATED_BY as CREATED_BY14_, deliveryty15_.UPDATED_ON as UPDATED_ON14_, deliveryty15_.CREATED_ON as CREATED_ON14_, deliveryty15_.LONGNAME as LONGNAME14_, deliveryty15_.SHORTNAME as SHORTNAME14_, period16_.ID as ID15_, period16_.DISC_TYPE as DISC_TYPE15_, period16_.FROM_DATE as FROM_DATE15_, period16_.TO_DATE as TO_DATE15_, period16_.DESCRIPTION as DESCRIPT5_15_, period16_.POSITION_MONTH as POSITION6_15_, period16_.UPDATED_BY as UPDATED_BY15_, period16_.CREATED_BY as CREATED_BY15_, period16_.UPDATED_DATE as UPDATED_9_15_, period16_.CREATED_DATE as CREATED10_15_, period16_.IS_CLOSE as IS_CLOSE15_, period16_.IS_OPEN as IS_OPEN15_, country17_.ID as ID16_, country17_.SHORTNAME as SHORTNAME16_, transporta18_.ID as ID17_, transporta18_.UPDATED_BY as UPDATED_BY17_, transporta18_.CREATED_BY as CREATED_BY17_, transporta18_.UPDATED_ON as UPDATED_ON17_, transporta18_.CREATED_ON as CREATED_ON17_, transporta18_.LONGNAME as LONGNAME17_, transporta18_.SHORTNAME as SHORTNAME17_, parity19_.ID as ID18_, parity19_.TYPE_CODE as TYPE_CODE18_, parity19_.LOCATION_ID as LOCATION3_18_, parity19_.UPDATED_BY as UPDATED_BY18_, parity19_.CREATED_BY as CREATED_BY18_, parity19_.UPDATED_ON as UPDATED_ON18_, parity19_.CREATED_ON as CREATED_ON18_, paritytype20_.ID as ID19_, paritytype20_.UPDATED_BY as UPDATED_BY19_, paritytype20_.CREATED_BY as CREATED_BY19_, paritytype20_.UPDATED_ON as UPDATED_ON19_, paritytype20_.CREATED_ON as CREATED_ON19_, paritytype20_.LONGNAME as LONGNAME19_, paritytype20_.SHORTNAME as SHORTNAME19_, parityloca21_.ID as ID20_, parityloca21_.SHORTNAME as SHORTNAME20_, parityloca21_.LONGNAME as LONGNAME20_, parityloca21_.TYPE as TYPE20_, parityloca21_.COUNTRY_CODE as COUNTRY_5_20_, parityloca21_.COUNTRY_DESCRIPTION as COUNTRY_6_20_, parityloca21_.UPDATED_BY as UPDATED_BY20_, parityloca21_.CREATED_BY as CREATED_BY20_, parityloca21_.UPDATED_ON as UPDATED_ON20_, parityloca21_.CREATED_ON as CREATED_ON20_, misccontex22_.ID as ID21_, misccontex22_.DEMDESPID as DEMDESPID21_, misccontex22_.INSURANCEID as INSURANC3_21_, misccontex22_.CONTRACTFORMID as CONTRACT4_21_, misccontex22_.OTHER_CONDITIONS as OTHER_CO5_21_, misccontex22_.INSURANCE_VALUE as INSURANC6_21_, misccontex22_.INSURANCE_CLAUSE as INSURANC7_21_, misccontex22_.ARBITRATION_CLAUSE as ARBITRAT8_21_, misccontex22_.COMMENTS as COMMENTS21_, misccontex22_.UPDATED_BY as UPDATED_BY21_, misccontex22_.CREATED_BY as CREATED_BY21_, misccontex22_.UPDATED_ON as UPDATED_ON21_, misccontex22_.CREATED_ON as CREATED_ON21_, demdesp23_.ID as ID22_, demdesp23_.DEMURAGE as DEMURAGE22_, demdesp23_.DESPATCH as DESPATCH22_, demdesp23_.DEM_DESP_CURRENCY as DEM_DESP4_22_, currency24_.ID as ID23_, currency24_.UPDATED_BY as UPDATED_BY23_, currency24_.CREATED_BY as CREATED_BY23_, currency24_.UPDATED_DATE as UPDATED_4_23_, currency24_.CREATED_DATE as CREATED_5_23_, currency24_.LONGNAME as LONGNAME23_, insurance25_.ID as ID24_, insurance25_.CONDITION as CONDITION24_, insurance25_.CLAUSE as CLAUSE24_, insurance25_.UPDATED_BY as UPDATED_BY24_, insurance25_.CREATED_BY as CREATED_BY24_, insurance25_.UPDATED_ON as UPDATED_ON24_, insurance25_.CREATED_ON as CREATED_ON24_, contractfo26_.ID as ID25_, contractfo26_.FORM as FORM25_, contractfo26_.ARBITRATION_CLAUSE as ARBITRAT3_25_, contractfo26_.UPDATED_BY as UPDATED_BY25_, contractfo26_.CREATED_BY as CREATED_BY25_, contractfo26_.UPDATED_ON as UPDATED_ON25_, contractfo26_.CREATED_ON as CREATED_ON25_, status27_.ID as ID26_, status27_.COMPLETED_FLAG as COMPLETE2_26_, status27_.CANCELLED_FLAG as CANCELLE3_26_, status27_.EXECUTED_FLAG as EXECUTED4_26_, status27_.UPDATED_BY as UPDATED_BY26_, status27_.CREATED_BY as CREATED_BY26_, status27_.UPDATED_ON as UPDATED_ON26_, status27_.CREATED_ON as CREATED_ON26_, contract28_.ID as ID27_, contract28_.CONTRACT_DATE as CONTRACT2_27_, contract28_.COMPANY_ID as COMPANY_ID27_, contract28_.PROFITCENTER_CONTEXT_ID as PROFITCE4_27_, contract28_.COUNTERPARTY_CONTEXT_ID as COUNTERP5_27_, contract28_.NUMBER_OF_SPLITS as NUMBER_O6_27_, contract28_.TSF_FLAG as TSF_FLAG27_, contract28_.TRADER_ID as TRADER_ID27_, contract28_.TYPE as TYPE27_, contract28_.CODE as CODE27_, contract28_.AMENDMENT_DATE as AMENDME11_27_, contract28_.AMENDMENT_FLAG as AMENDME12_27_, contract28_.QUANTITY_ID as QUANTIT13_27_, contract28_.ACCOUNTING_PERIOD_ID as ACCOUNT14_27_, contract28_.STATUS_ID as STATUS_ID27_, contract28_.COMMENTS as COMMENTS27_, contract28_.UPDATED_BY as UPDATED_BY27_, contract28_.CREATED_BY as CREATED_BY27_, contract28_.UPDATED_ON as UPDATED_ON27_, contract28_.CREATED_ON as CREATED_ON27_, company29_.ID as ID28_, company29_.SHORTNAME as SHORTNAME28_, company29_.LONGNAME as LONGNAME28_, company29_.COMPANY_CURRENCY as COMPANY_4_28_, company29_.LOCAL_CURRENCY as LOCAL_CU5_28_, company29_.LOCATION_ID as LOCATION6_28_, company29_.CREATED_BY as CREATED_BY28_, company29_.CREATED_ON as CREATED_ON28_, company29_.UPDATED_BY as UPDATED_BY28_, company29_.UPDATED_ON as UPDATED_ON28_, profitcent30_.ID as ID29_, profitcent30_.COMM_GRP_ID as COMM_GRP2_29_, profitcent30_.PROFITCENTER_ID as PROFITCE3_29_, profitcent30_.QUANTITYUNIT_ID as QUANTITY4_29_, profitcent30_.COMPANY_ID as COMPANY_ID29_, profitcent30_.UPDATED_BY as UPDATED_BY29_, profitcent30_.CREATED_BY as CREATED_BY29_, profitcent30_.UPDATED_ON as UPDATED_ON29_, profitcent30_.CREATED_ON as CREATED_ON29_, commodityg31_.ID as ID30_, commodityg31_.LONGNAME as LONGNAME30_, profitcent32_.ID as ID31_, profitcent32_.COMMODITYGROUP_ID as COMMODIT2_31_, profitcent32_.LONGNAME as LONGNAME31_, profitcent32_.COMMENTS as COMMENTS31_, profitcent32_.COMPANY_ID as COMPANY_ID31_, profitcent32_.LOCATION_ID as LOCATION6_31_, commodityg33_.ID as ID32_, commodityg33_.LONGNAME as LONGNAME32_, company34_.ID as ID33_, company34_.SHORTNAME as SHORTNAME33_, company34_.LONGNAME as LONGNAME33_, company34_.COMPANY_CURRENCY as COMPANY_4_33_, company34_.LOCAL_CURRENCY as LOCAL_CU5_33_, company34_.LOCATION_ID as LOCATION6_33_, company34_.CREATED_BY as CREATED_BY33_, company34_.CREATED_ON as CREATED_ON33_, company34_.UPDATED_BY as UPDATED_BY33_, company34_.UPDATED_ON as UPDATED_ON33_, location35_.ID as ID34_, location35_.COUNTRY_ID as COUNTRY_ID34_, location35_.CITY_ID as CITY_ID34_, location35_.REGION_ID as REGION_ID34_, location35_.STATE_ID as STATE_ID34_, location35_.DEPARTMENT_ID as DEPARTME6_34_, location35_.NAME as NAME34_, country36_.ID as ID35_, country36_.SHORTNAME as SHORTNAME35_, city37_.ID as ID36_, city37_.SHORTNAME as SHORTNAME36_, region38_.ID as ID37_, region38_.SHORTNAME as SHORTNAME37_, state39_.ID as ID38_, state39_.SHORTNAME as SHORTNAME38_, department40_.ID as ID39_, department40_.SHORTNAME as SHORTNAME39_, unitofmeas41_.ID as ID40_, unitofmeas41_.UPDATED_BY as UPDATED_BY40_, unitofmeas41_.CREATED_BY as CREATED_BY40_, unitofmeas41_.UPDATED_ON as UPDATED_ON40_, unitofmeas41_.CREATED_ON as CREATED_ON40_, unitofmeas41_.LONGNAME as LONGNAME40_, company42_.ID as ID41_, company42_.SHORTNAME as SHORTNAME41_, company42_.LONGNAME as LONGNAME41_, company42_.COMPANY_CURRENCY as COMPANY_4_41_, company42_.LOCAL_CURRENCY as LOCAL_CU5_41_, company42_.LOCATION_ID as LOCATION6_41_, company42_.CREATED_BY as CREATED_BY41_, company42_.CREATED_ON as CREATED_ON41_, company42_.UPDATED_BY as UPDATED_BY41_, company42_.UPDATED_ON as UPDATED_ON41_, counterpar43_.ID as ID42_, counterpar43_.COUNTER_PARTY_NUMBER as COUNTER_2_42_, counterpar43_.REF_CODE as REF_CODE42_, counterpar43_.PAYMENTTERMTYPE_ID as PAYMENTT4_42_, counterpar43_.CURRENCY_ID as CURRENCY5_42_, counterpar43_.UNIT_ID as UNIT_ID42_, counterpar43_.UPDATED_BY as UPDATED_BY42_, counterpar43_.CREATED_BY as CREATED_BY42_, counterpar43_.UPDATED_ON as UPDATED_ON42_, counterpar43_.CREATED_ON as CREATED_ON42_, counterpar44_.ID as ID43_, counterpar44_.UPDATED_BY as UPDATED_BY43_, counterpar44_.CREATED_BY as CREATED_BY43_, counterpar44_.UPDATED_ON as UPDATED_ON43_, counterpar44_.CREATED_ON as CREATED_ON43_, counterpar44_.LONGNAME as LONGNAME43_, counterpar44_.SHORTNAME as SHORTNAME43_, counterpar44_.SAP_CODE as SAP_CODE43_, paymentter45_.ID as ID44_, paymentter45_.UPDATED_BY as UPDATED_BY44_, paymentter45_.CREATED_BY as CREATED_BY44_, paymentter45_.UPDATED_ON as UPDATED_ON44_, paymentter45_.CREATED_ON as CREATED_ON44_, paymentter45_.LONGNAME as LONGNAME44_, paymentter45_.SHORTNAME as SHORTNAME44_, paymentter45_.COMMENTS as COMMENTS44_, currency46_.ID as ID45_, currency46_.UPDATED_BY as UPDATED_BY45_, currency46_.CREATED_BY as CREATED_BY45_, currency46_.UPDATED_DATE as UPDATED_4_45_, currency46_.CREATED_DATE as CREATED_5_45_, currency46_.LONGNAME as LONGNAME45_, unitofmeas47_.ID as ID46_, unitofmeas47_.UPDATED_BY as UPDATED_BY46_, unitofmeas47_.CREATED_BY as CREATED_BY46_, unitofmeas47_.UPDATED_ON as UPDATED_ON46_, unitofmeas47_.CREATED_ON as CREATED_ON46_, unitofmeas47_.LONGNAME as LONGNAME46_, period48_.ID as ID47_, period48_.DISC_TYPE as DISC_TYPE47_, period48_.FROM_DATE as FROM_DATE47_, period48_.TO_DATE as TO_DATE47_, period48_.DESCRIPTION as DESCRIPT5_47_, period48_.POSITION_MONTH as POSITION6_47_, period48_.UPDATED_BY as UPDATED_BY47_, period48_.CREATED_BY as CREATED_BY47_, period48_.UPDATED_DATE as UPDATED_9_47_, period48_.CREATED_DATE as CREATED10_47_, period48_.IS_CLOSE as IS_CLOSE47_, period48_.IS_OPEN as IS_OPEN47_, status49_.ID as ID48_, status49_.COMPLETED_FLAG as COMPLETE2_48_, status49_.CANCELLED_FLAG as CANCELLE3_48_, status49_.EXECUTED_FLAG as EXECUTED4_48_, status49_.UPDATED_BY as UPDATED_BY48_, status49_.CREATED_BY as CREATED_BY48_, status49_.UPDATED_ON as UPDATED_ON48_, status49_.CREATED_ON as CREATED_ON48_, _brokerage0_.ID as ID49_, _brokerage0_.BROKER_ID as BROKER_ID49_, _brokerage0_.SPLIT_ID as SPLIT_ID49_, _brokerage0_.REF_CODE as REF_CODE49_, _brokerage0_.COMMISSION_ID as COMMISSI5_49_, _brokerage0_.ACTIVE as ACTIVE49_, _brokerage0_.COMMENTS as COMMENTS49_, _brokerage0_.UPDATED_BY as UPDATED_BY49_, _brokerage0_.CREATED_BY as CREATED_BY49_, _brokerage0_.UPDATED_ON as UPDATED_ON49_, _brokerage0_.CREATED_ON as CREATED_ON49_ from BGM_CONTRACTS.T_BROKER_CONTEXT _brokerage0_ left outer join BGM_COMPONENTS.T_BROKER broker1_ on _brokerage0_.BROKER_ID=broker1_.ID left outer join BGM_CONTRACTS.T_COST expense2_ on _brokerage0_.COMMISSION_ID=expense2_.COST_ID left outer join BGM_COMPONENTS.T_CURRENCY currency3_ on expense2_.CURRENCY_ID=currency3_.ID left outer join BGM_COMPONENTS.T_UNIT unitofmeas4_ on expense2_.UNIT_ID=unitofmeas4_.ID left outer join BGM_CONTRACTS.T_SPLIT split5_ on expense2_.SPLIT_ID=split5_.SPLIT_ID left outer join BGM_CONTRACTS.T_COMMODITY_CONTEXT commodityc6_ on split5_.COMMODITY_CONTEXT_ID=commodityc6_.ID left outer join BGM_COMPONENTS.T_COMMODITY_GROUP commodityg7_ on commodityc6_.COMMODITY_GROUP_ID=commodityg7_.ID left outer join BGM_COMPONENTS.T_COMMODITY commodity8_ on commodityc6_.COMMODITY_ID=commodity8_.ID left outer join BGM_CONTRACTS.T_PACKING_TYPE packingtyp9_ on commodityc6_.PACKINGTYPE_ID=packingtyp9_.ID left outer join BGM_COMPONENTS.T_COUNTRY country10_ on commodityc6_.ORIGIN_COUNTRY_ID=country10_.ID left outer join BGM_CONTRACTS.T_QUANTITY commodityq11_ on commodityc6_.QUANTITY_ID=commodityq11_.ID left outer join BGM_CONTRACTS.T_TOLERANCE_TYPE tolerancet12_ on commodityq11_.TOLERANCE_ID=tolerancet12_.ID left outer join BGM_COMPONENTS.T_UNIT unitofmeas13_ on commodityq11_.UNIT_ID=unitofmeas13_.ID left outer join BGM_CONTRACTS.T_DELIVERY delivery14_ on split5_.DELIVERY_ID=delivery14_.ID left outer join BGM_CONTRACTS.T_DELIVERY_TYPE deliveryty15_ on delivery14_.TYPE_ID=deliveryty15_.ID left outer join BGM_CONTRACTS.T_PERIOD period16_ on delivery14_.PERIOD_ID=period16_.ID left outer join BGM_COMPONENTS.T_COUNTRY country17_ on delivery14_.DEST_COUNTRY=country17_.ID left outer join BGM_CONTRACTS.T_TRANSPORTATION_TYPE transporta18_ on delivery14_.TRANSPORTATIONTYPE_ID=transporta18_.ID left outer join BGM_CONTRACTS.T_PARITY parity19_ on delivery14_.PARITY_ID=parity19_.ID left outer join BGM_CONTRACTS.T_PARITY_TYPE paritytype20_ on parity19_.TYPE_CODE=paritytype20_.ID left outer join BGM_CONTRACTS.T_PARITY_LOCATION parityloca21_ on parity19_.LOCATION_ID=parityloca21_.ID left outer join BGM_CONTRACTS.T_MISC_ITEMS misccontex22_ on split5_.MISC_ITEMS_ID=misccontex22_.ID left outer join BGM_CONTRACTS.T_DEM_DESP demdesp23_ on misccontex22_.DEMDESPID=demdesp23_.ID left outer join BGM_COMPONENTS.T_CURRENCY currency24_ on demdesp23_.DEM_DESP_CURRENCY=currency24_.ID left outer join BGM_CONTRACTS.T_INSURANCE insurance25_ on misccontex22_.INSURANCEID=insurance25_.ID left outer join BGM_CONTRACTS.T_CONTRACT_FORM contractfo26_ on misccontex22_.CONTRACTFORMID=contractfo26_.ID left outer join BGM_CONTRACTS.T_STATUS status27_ on split5_.STATUS_ID=status27_.ID left outer join BGM_CONTRACTS.T_CONTRACT contract28_ on split5_.CONTRACT_ID=contract28_.ID left outer join BGM_COMPONENTS.T_COMPANY company29_ on contract28_.COMPANY_ID=company29_.ID left outer join BGM_CONTRACTS.T_PROFITCENTER_CONTEXT profitcent30_ on contract28_.PROFITCENTER_CONTEXT_ID=profitcent30_.ID left outer join BGM_COMPONENTS.T_COMMODITY_GROUP commodityg31_ on profitcent30_.COMM_GRP_ID=commodityg31_.ID left outer join BGM_COMPONENTS.T_PROFIT_CENTER profitcent32_ on profitcent30_.PROFITCENTER_ID=profitcent32_.ID left outer join BGM_COMPONENTS.T_COMMODITY_GROUP commodityg33_ on profitcent32_.COMMODITYGROUP_ID=commodityg33_.ID left outer join BGM_COMPONENTS.T_COMPANY company34_ on profitcent32_.COMPANY_ID=company34_.ID left outer join BGM_COMPONENTS.T_LOCATION location35_ on profitcent32_.LOCATION_ID=location35_.ID left outer join BGM_COMPONENTS.T_COUNTRY country36_ on location35_.COUNTRY_ID=country36_.ID left outer join BGM_COMPONENTS.T_CITY city37_ on location35_.CITY_ID=city37_.ID left outer join BGM_COMPONENTS.T_REGION region38_ on location35_.REGION_ID=region38_.ID left outer join BGM_COMPONENTS.T_STATE state39_ on location35_.STATE_ID=state39_.ID left outer join BGM_COMPONENTS.T_DEPARTMENT department40_ on location35_.DEPARTMENT_ID=department40_.ID left outer join BGM_COMPONENTS.T_UNIT unitofmeas41_ on profitcent30_.QUANTITYUNIT_ID=unitofmeas41_.ID left outer join BGM_COMPONENTS.T_COMPANY company42_ on profitcent30_.COMPANY_ID=company42_.ID left outer join BGM_CONTRACTS.T_COUNTER_PARTY_CONTEXT counterpar43_ on contract28_.COUNTERPARTY_CONTEXT_ID=counterpar43_.ID left outer join BGM_COMPONENTS.T_COUNTER_PARTY counterpar44_ on counterpar43_.COUNTER_PARTY_NUMBER=counterpar44_.ID left outer join BGM_CONTRACTS.T_PAYMENT_TERM_TYPE paymentter45_ on counterpar43_.PAYMENTTERMTYPE_ID=paymentter45_.ID left outer join BGM_COMPONENTS.T_CURRENCY currency46_ on counterpar43_.CURRENCY_ID=currency46_.ID left outer join BGM_COMPONENTS.T_UNIT unitofmeas47_ on counterpar43_.UNIT_ID=unitofmeas47_.ID left outer join BGM_CONTRACTS.T_PERIOD period48_ on contract28_.ACCOUNTING_PERIOD_ID=period48_.ID left outer join BGM_CONTRACTS.T_STATUS status49_ on contract28_.STATUS_ID=status49_.ID where _brokerage0_.SPLIT_ID=?
net.sf.hibernate.JDBCException: could not initialize collection: [com.bunge.bgm.contract.business.domain.trade.Split._brokerages#342]
at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:287)
at net.sf.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:3226)
at net.sf.hibernate.collection.PersistentCollection.forceInitialization(PersistentCollection.java:340)
at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3089)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:831)
at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:851)
at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:57)
at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:49)
at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:419)
at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2081)
at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1955)
at net.sf.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:1917)
at net.sf.hibernate.type.ManyToOneType.resolveIdentifier(ManyToOneType.java:68)
at net.sf.hibernate.type.EntityType.resolveIdentifier(EntityType.java:215)
at net.sf.hibernate.type.EntityType.nullSafeGet(EntityType.java:154)
at net.sf.hibernate.impl.IteratorImpl.postNext(IteratorImpl.java:71)
at net.sf.hibernate.impl.IteratorImpl.<init>(IteratorImpl.java:48)
at net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:849)
at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1577)
at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:27)
at com.bunge.bgm.contract.business.domain.trade.LinkMain.findByOrigin(LinkMain.java:85)
at com.bunge.bgm.contract.business.domain.trade.LinkMain.main(LinkMain.java:156)
Caused by: java.sql.SQLException: ORA-00911: invalid character
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:795)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:189)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:910)
at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:885)
at net.sf.hibernate.loader.OneToManyLoader.initialize(OneToManyLoader.java:80)
at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:284)
... 22 more

This is special case with Oracle database It Says Invalid character when _ is the first character in the alias.

Thanks

Jayant

don't crosspost please.

Cross Post All You Want, My Friend!

I'm using Hibernate 3.1, and this still seems to be a problem. It only seems to occur when mapping a collection to a field that starts with an underscore.

What's the best way to solve this, override the naming strategy?

Can I open abug for this in JIRA?

Jerry