-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 6 posts ] 
Author Message
 Post subject: Index out of bounds on second iteration of updates
PostPosted: Mon Dec 22, 2003 11:31 am 
Newbie

Joined: Wed Oct 15, 2003 10:24 pm
Posts: 10
If I load an existing object, use that object to create a new transient object, and then modify the loaded object, I seem to be OK for one loop. If I attempt to do this for another iteration, I get an index out of bounds on the update of the second record.

Here's a detail of it:

1) Load an existing product object
2) Load an existing person object
3) Create a new object that associates this product to a person (i.e. purchase it).
4) Update the number sold on the product object.

If I do more than one loop of this, I get an index out of bounds when binding parameters to update the second product object. The first iteration binds all parameters successfully, but the second iteration only binds a certain number (33 in this case).

NOTE: It seems to be OK if I make my changes to the product object before associating it to the new transient object (i.e. switch 3 & 4 around).... but I'm concerned that this is a hack and I'm seeing a bigger problem that I don't understand.

Thanks!
Paul J.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Dec 22, 2003 12:24 pm 
Hibernate Team
Hibernate Team

Joined: Sun Sep 14, 2003 3:54 am
Posts: 7256
Location: Paris, France
code ?
mapping (with less params 33 is too much for human reader :-)) ?
http://www.hibernate.org/ForumMailinglists/HowToAskForHelp

_________________
Emmanuel


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 24, 2003 7:30 am 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 12:50 pm
Posts: 5130
Location: Melbourne, Australia
Also: stack trace, of course


Top
 Profile  
 
 Post subject: Stack trace requested
PostPosted: Thu Jan 15, 2004 2:37 pm 
Newbie

Joined: Wed Oct 15, 2003 10:24 pm
Posts: 10
Here's the stack trace... note that the first update product update goes fine... but the second product gets the out of bounds. I found no oddities in the data between the two products that look like they would have caused this.

Thanks! -
Paul

Hibernate: update Product set Prod_Active_Ind=?, Prod_Nm=?, Prod_Year_Nbr=?, Prod_Quota_Cnt=?, Prod_Sold_Cnt=?, Lst_Seq_Nbr_Used_Id=?, Prod_Earliest_Use_Dt=?, Prod_Latest_Use_Dt=?, Prod_Use_Allowed_Month_Cnt=?, Short_Term_Designation_Ind=?, Prod_Note_Txt=?, Needs_Prime_Purch_Ind=?, CAP_Response_Req_Ind=?, HIP_Req_Ind=?, MHR_Req_Ind=?, Is_Group_Ind=?, Is_Lifetime_Cert_Ind=?, Lookup_Subgroup_Prod_Ind=?, Use_Child_Price_Ind=?, Prod_Display_Ind=?, Enter_Unit_Ind=?, Prod_Spec_AB_Lookup_On_Form_Ind=?, Prod_Spec_Display_Lookup_Txt=?, Sportsperson_Per_Appl_Cnt=?, Used_For_CH_Ind=?, Hunt_Nbr=?, Hunt_Area_Nm=?, Prod_Sale_Start_Ts=?, Prod_Sale_Stop_Ts=?, Appl_Sale_Start_Ts=?, Appl_Sale_Stop_Ts=?, Prod_Cancel_Min_Priv_Lvl_Nm=?, Prod_Dupl_Min_Priv_Lvl_Nm=?, Prod_Exch_Min_Priv_Lvl_Nm=?, Prod_Issue_Min_Priv_Lvl_Nm=?, Prod_No_Chrg_Min_Priv_Lvl_Nm=?, Prod_Override_Min_Priv_Lvl_Nm=?, Prod_Reprint_Min_Priv_Lvl_Nm=?, Prod_Receipt_Redemp_Min_Priv_Lvl_Nm=?, Prod_Spec_Cancel_Min_Priv_Lvl_Nm=?, Print_As_Standalone_Ind=?, Print_Tag_Ind=?, Print_Unit_Ind=?, Print_Zn_Ind=?, Allow_Local_Print_Ind=?, WWW_Issue_Priv_Ind=?, WWW_Dupl_Priv_Ind=?, WWW_Receipt_Redeem_Ind=?, Call_Issue_Priv_Ind=?, Call_Dupl_Priv_Ind=?, Call_Receipt_Redeem_Ind=?, Bus_Rule_Engine_Label_Nm=?, Prod_Create_Ts=?, Prod_Create_Person_Id=?, Prod_Lst_Updt_Ts=?, Prod_Lst_Updt_Person_Id=?, Enter_Site_Tag_Range_Ind=?, Enable_CH_Appl_Ind=?, Enter_Zone_Ind=?, Sport_Type_Cd=?, Legal_Desc_Id=?, Prod_Type_Id=?, Prod_Tab_Grp_Id=?, Hunt_Appl_Type_Cd=?, Species_Id=?, Permit_Confirmation_Cd=?, Hunt_Type_Cd=?, Geo_Zn_Id=? where Prod_Id=?
[12/21/03 19:08:00:110 GMT-06:00] 4caec7a6 SystemOut O 2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'true' to parameter: 1
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding 'SAGE-SHARPTAIL GROUSE PERMIT' to parameter: 2
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '2003' to parameter: 3
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.IntegerType - binding null to parameter: 4
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.IntegerType - binding '3875' to parameter: 5
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.LongType - binding '3982' to parameter: 6
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding '01 January 2003 12:00:00' to parameter: 7
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding '31 December 2003 11:59:00' to parameter: 8
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.IntegerType - binding null to parameter: 9
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 10
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 11
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'true' to parameter: 12
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 13
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 14
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 15
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 16
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 17
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 18
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 19
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'true' to parameter: 20
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 21
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 22
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 23
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.IntegerType - binding null to parameter: 24
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 25
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 26
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 27
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding null to parameter: 28
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding null to parameter: 29
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding null to parameter: 30
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding null to parameter: 31
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '02' to parameter: 32
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '02' to parameter: 33
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '02' to parameter: 34
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '02' to parameter: 35
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '02' to parameter: 36
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '02' to parameter: 37
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '02' to parameter: 38
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '02' to parameter: 39
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '08' to parameter: 40
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 41
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 42
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 43
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 44
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 45
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'true' to parameter: 46
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 47
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 48
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'true' to parameter: 49
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 50
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 51
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '625 SAGE-SHARPTAIL GROUSE PERMIT 2003' to parameter: 52
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding '15 December 2003 11:03:22' to parameter: 53
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.LongType - binding '1' to parameter: 54
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding '15 December 2003 11:03:22' to parameter: 55
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.LongType - binding '1' to parameter: 56
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 57
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 58
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 59
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 60
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.LongType - binding null to parameter: 61
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.LongType - binding '1944' to parameter: 62
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.LongType - binding '28' to parameter: 63
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 64
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.LongType - binding null to parameter: 65
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding 'S' to parameter: 66
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 67
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.LongType - binding null to parameter: 68
2003-12-21 19:08:00,110 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.LongType - binding '4299' to parameter: 69
Hibernate: update Person set First_Nm=?, Middle_Nm=?, Last_Nm=?, Suffix_Nm=?, Soc_Sec_Nbr=?, Birth_Dt=?, Res_Start_Dt=?, Height_Part_Feet_Nbr=?, Height_Part_Inch_Nbr=?, Weight_In_Lbs_Nbr=?, Driver_Lic_Nbr=?, Driver_Lic_Issue_Dt=?, Driver_Lic_Issue_St_Cd=?, Trapper_Id_Nbr=?, Txn_In_Progress_Id=?, Out_St_Hunter_Ref_Nbr=?, Out_St_Archery_Ref_Nbr=?, In_St_Hunter_Edu_Nbr=?, In_St_Archery_Edu_Nbr=?, Email_Addr_Txt=?, Person_HIP_Lst_Reported_Dt=?, Person_Create_Ts=?, Person_Create_Person_Id=?, Person_Lst_Updt_Ts=?, Person_Lst_Updt_Person_Id=?, Hair_Color_Cd=?, Eye_Color_Cd=?, Gender_Cd=? where Person_Id=?
[12/21/03 19:08:00:992 GMT-06:00] 4caec7a6 SystemOut O 2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding 'Henry' to parameter: 1
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '' to parameter: 2
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding 'Lee' to parameter: 3
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '' to parameter: 4
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '737374556' to parameter: 5
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding '03 March 1969 12:00:00' to parameter: 6
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding null to parameter: 7
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '5' to parameter: 8
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '11' to parameter: 9
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '145' to parameter: 10
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '' to parameter: 11
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding null to parameter: 12
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '' to parameter: 13
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '' to parameter: 14
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.LongType - binding null to parameter: 15
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '' to parameter: 16
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '' to parameter: 17
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 18
2003-12-21 19:08:00,992 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 19
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 20
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding null to parameter: 21
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding '21 December 2003 04:27:14' to parameter: 22
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.LongType - binding '14300044' to parameter: 23
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding '21 December 2003 07:07:21' to parameter: 24
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.LongType - binding '1000150004' to parameter: 25
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding 'BRO' to parameter: 26
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding 'BLU' to parameter: 27
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding 'M' to parameter: 28
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.LongType - binding '1007200000' to parameter: 29
Hibernate: update Product set Prod_Active_Ind=?, Prod_Nm=?, Prod_Year_Nbr=?, Prod_Quota_Cnt=?, Prod_Sold_Cnt=?, Lst_Seq_Nbr_Used_Id=?, Prod_Earliest_Use_Dt=?, Prod_Latest_Use_Dt=?, Prod_Use_Allowed_Month_Cnt=?, Short_Term_Designation_Ind=?, Prod_Note_Txt=?, Needs_Prime_Purch_Ind=?, CAP_Response_Req_Ind=?, HIP_Req_Ind=?, MHR_Req_Ind=?, Is_Group_Ind=?, Is_Lifetime_Cert_Ind=?, Lookup_Subgroup_Prod_Ind=?, Use_Child_Price_Ind=?, Prod_Display_Ind=?, Enter_Unit_Ind=?, Prod_Spec_AB_Lookup_On_Form_Ind=?, Prod_Spec_Display_Lookup_Txt=?, Sportsperson_Per_Appl_Cnt=?, Used_For_CH_Ind=?, Hunt_Nbr=?, Hunt_Area_Nm=?, Prod_Sale_Start_Ts=?, Prod_Sale_Stop_Ts=?, Appl_Sale_Start_Ts=?, Appl_Sale_Stop_Ts=?, Prod_Cancel_Min_Priv_Lvl_Nm=?, Prod_Dupl_Min_Priv_Lvl_Nm=?, Prod_Exch_Min_Priv_Lvl_Nm=?, Prod_Issue_Min_Priv_Lvl_Nm=?, Prod_No_Chrg_Min_Priv_Lvl_Nm=?, Prod_Override_Min_Priv_Lvl_Nm=?, Prod_Reprint_Min_Priv_Lvl_Nm=?, Prod_Receipt_Redemp_Min_Priv_Lvl_Nm=?, Prod_Spec_Cancel_Min_Priv_Lvl_Nm=?, Print_As_Standalone_Ind=?, Print_Tag_Ind=?, Print_Unit_Ind=?, Print_Zn_Ind=?, Allow_Local_Print_Ind=?, WWW_Issue_Priv_Ind=?, WWW_Dupl_Priv_Ind=?, WWW_Receipt_Redeem_Ind=?, Call_Issue_Priv_Ind=?, Call_Dupl_Priv_Ind=?, Call_Receipt_Redeem_Ind=?, Bus_Rule_Engine_Label_Nm=?, Prod_Create_Ts=?, Prod_Create_Person_Id=?, Prod_Lst_Updt_Ts=?, Prod_Lst_Updt_Person_Id=?, Enter_Site_Tag_Range_Ind=?, Enable_CH_Appl_Ind=?, Enter_Zone_Ind=?, Sport_Type_Cd=?, Legal_Desc_Id=?, Prod_Type_Id=?, Prod_Tab_Grp_Id=?, Hunt_Appl_Type_Cd=?, Species_Id=?, Permit_Confirmation_Cd=?, Hunt_Type_Cd=?, Geo_Zn_Id=? where Prod_Id=?
[12/21/03 19:08:01:002 GMT-06:00] 4caec7a6 SystemOut O 2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'true' to parameter: 1
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding 'BEAR BAITING PERMIT' to parameter: 2
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '2003' to parameter: 3
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.IntegerType - binding null to parameter: 4
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.IntegerType - binding '1484' to parameter: 5
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.LongType - binding '1524' to parameter: 6
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding '01 March 2003 12:00:00' to parameter: 7
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding '31 December 2003 12:00:00' to parameter: 8
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.IntegerType - binding null to parameter: 9
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 10
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 11
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'true' to parameter: 12
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 13
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 14
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 15
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 16
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 17
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 18
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 19
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'true' to parameter: 20
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 21
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 22
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 23
2003-12-21 19:08:01,002 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.IntegerType - binding null to parameter: 24
2003-12-21 19:08:01,012 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.YesNoType - binding 'false' to parameter: 25
2003-12-21 19:08:01,012 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 26
2003-12-21 19:08:01,012 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 27
2003-12-21 19:08:01,012 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding null to parameter: 28
2003-12-21 19:08:01,012 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding null to parameter: 29
2003-12-21 19:08:01,012 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding null to parameter: 30
2003-12-21 19:08:01,012 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.TimestampType - binding null to parameter: 31
2003-12-21 19:08:01,012 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '08' to parameter: 32
2003-12-21 19:08:01,012 [Servlet.Engine.Transports : 1] DEBUG net.sf.hibernate.type.StringType - binding '02' to parameter: 33
2003-12-21 19:08:01,012 [Servlet.Engine.Transports : 1] ERROR com.gtech.gsp.lic.command.purchase.CreateSalesTransactionCommand - error occured processing command
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at java.util.ArrayList.RangeCheck(ArrayList.java(Compiled Code))
at java.util.ArrayList.set(ArrayList.java:343)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.countParameter(WSJdbcPreparedStatement.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setString(WSJdbcPreparedStatement.java:1206)
at net.sf.hibernate.type.StringType.set(StringType.java:22)
at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java(Compiled Code))
at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java(Compiled Code))
at net.sf.hibernate.persister.EntityPersister.dehydrate(EntityPersister.java:371)
at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:635)
at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:611)
at net.sf.hibernate.impl.ScheduledUpdate.execute(ScheduledUpdate.java:31)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2100)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2062)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2005)
at com.gtech.gsp.lic.hibernate.service.HibernatorService.closeSession(HibernatorService.java:56)
at com.gtech.gsp.lic.hibernate.dao.SalesTransactionDAOImpl.buyProducts(SalesTransactionDAOImpl.java:819)
at com.gtech.gsp.lic.command.purchase.CreateSalesTransactionCommand.performExecute(CreateSalesTransactionCommand.java:64)
at com.gtech.command.target.EJBCommandServerBean.executeCommand(EJBCommandServerBean.java:61)
at com.gtech.command.target.EJSRemoteStatelessEJBCommandServer_504353bd.executeCommand(EJSRemoteStatelessEJBCommandServer_504353bd.java:41)
at com.gtech.command.target._EJBCommandServer_Stub.executeCommand(_EJBCommandServer_Stub.java:262)
at com.gtech.command.target.EJBCommandTarget.executeCommand(EJBCommandTarget.java:73)
at com.gtech.command.TargetableCommandImpl.execute(TargetableCommandImpl.java:261)
at com.gtech.gsp.lic.action.pos.purchase.UpdatePurchaseSummaryAction.processCommand(UpdatePurchaseSummaryAction.java:340)
at com.gtech.gsp.lic.action.pos.purchase.UpdatePurchaseSummaryAction.checkout(UpdatePurchaseSummaryAction.java:196)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at com.gtech.gsp.action.BaseDispatchAction.dispatchMethod(BaseDispatchAction.java:132)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at com.gtech.gsp.action.BaseDispatchAction.execute(BaseDispatchAction.java:143)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:258)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:872)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:491)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:173)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:199)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:331)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:432)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:343)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:592)
2003-12-21 19:08:01,012 [Servlet.Engine.Transports : 1] DEBUG com.gtech.command.target.EJBCommandTarget - java.lang.IndexOutOfBoundsException: Index: 0, Size: 0

java.lang.IndexOutOfBoundsException: Index: 0, Size: 0

2003-12-21 19:08:01,012 [Servlet.Engine.Transports : 1] WARN org.apache.struts.action.RequestProcessor - Unhandled Exception thrown: class com.gtech.command.CommandException


Top
 Profile  
 
 Post subject: Update Code
PostPosted: Thu Jan 15, 2004 2:49 pm 
Newbie

Joined: Wed Oct 15, 2003 10:24 pm
Posts: 10
Here's the update that I do to my product that works fine if I do it before setting the product on the new purchase transient object... but gives the previous stack if I perform this update to the product after I do the association to the transient purchase object. Note that the string it returns it stuck on the associative purchase object.

Thanks!
Paul

private String createDocumentNbr(Product product) throws Exception {

StringBuffer documentNbr = new StringBuffer();

product.setProdSoldCnt(
new Integer(product.getProdSoldCnt().intValue() + 1));
if (product.getLstSeqNbrUsedId() == null) {
product.setLstSeqNbrUsedId(new Long(1));
} else {

//Long lstSeqNbr = product.getLstSeqNbrUsedId() + 1;
product.setLstSeqNbrUsedId(
new Long(product.getLstSeqNbrUsedId().longValue() + 1));

}

String seqNbrStr = product.getLstSeqNbrUsedId().toString();
documentNbr.append(product.getProductType().getProdTypeCd());

StringBuffer paddedSeqNbrStr = new StringBuffer(6);
long len = seqNbrStr.length();
for (int iDx = 0;(len + iDx) < 6; iDx++) {
paddedSeqNbrStr.append("0");

}

paddedSeqNbrStr.append(seqNbrStr);

documentNbr.append(paddedSeqNbrStr.toString());
return documentNbr.toString();
}


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 23, 2004 1:14 pm 
Newbie

Joined: Wed Oct 15, 2003 10:24 pm
Posts: 10
It appears as though this was a problem with prepared statement caching in our IBM JDBC driver (com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement)

Basically the prepared statement caching has a bug in it that bombs out when it attempts to use a cached statement with a large number of parameters. To fix requiring that either the statement caching be set to zero... or that we updated our driver.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 6 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.