Hi Enrico,
   Could you also provide class TblItmtyp? Thanks!

--- On Fri, 10/3/08, egoosen <[EMAIL PROTECTED]> wrote:

> From: egoosen <[EMAIL PROTECTED]>
> Subject: Exception in SQLBuffer.java on OpenJPA 1.3.0-SNAPSHOT
> To: [email protected]
> Date: Friday, October 3, 2008, 6:46 AM
> Hi,
> 
> I'm getting the following exception when this code
> runs:
> public TblItmdes getTrackingItem(String itmCde){
>               TblItmdes tblItmdes =
> getTblItmdesDAO().findTblItmdesByItmCde(itmCde);
>               tblItmdes.getTblTrklnks(); //<-- lazy load throws
> exception
>               return tblItmdes;
>       }
> 
> PS. It works fine in 1.1.0.
> 
> Caused by: java.lang.IndexOutOfBoundsException: Index: 1,
> Size: 1
>       at java.util.ArrayList.RangeCheck(ArrayList.java:546)
>       at java.util.ArrayList.get(ArrayList.java:321)
>       at
> org.apache.openjpa.jdbc.sql.SQLBuffer.setParameters(SQLBuffer.java:629)
>       at
> org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:529)
>       at
> org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:485)
>       at
> org.apache.openjpa.jdbc.sql.SelectImpl.prepareStatement(SelectImpl.java:463)
>       at
> org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:379)
>       at
> org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:339)
>       at
> org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:420)
>       at
> org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:230)
>       at
> org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:220)
>       at
> org.apache.openjpa.jdbc.meta.strats.StoreCollectionFieldStrategy.load(StoreCollectionFieldStrategy.java:603)
>       at
> org.apache.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:822)
>       at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:626)
>       at
> org.apache.openjpa.kernel.DelegatingStoreManager.load(DelegatingStoreManager.java:116)
>       at
> org.apache.openjpa.kernel.ROPStoreManager.load(ROPStoreManager.java:78)
>       at
> org.apache.openjpa.kernel.StateManagerImpl.loadFields(StateManagerImpl.java:2920)
>       at
> org.apache.openjpa.kernel.StateManagerImpl.loadField(StateManagerImpl.java:2998)
>       at
> org.apache.openjpa.kernel.StateManagerImpl.beforeAccessField(StateManagerImpl.java:1492)
>       at
> org.apache.openjpa.kernel.StateManagerImpl.accessingField(StateManagerImpl.java:1477)
>       at
> za.co.metcapri.model.ebstatus.TblItmdes.pcGettblTrklnks(TblItmdes.java)
>       at
> za.co.metcapri.model.ebstatus.TblItmdes.getTblTrklnks(TblItmdes.java:77)
>       at
> za.co.metcapri.status.business.AdminManagerBean.getTrackingItem(AdminManagerBean.java:84)
>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
>       at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>       at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>       at java.lang.reflect.Method.invoke(Method.java:585)
>       at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:299)
>       at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
>       at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
>       at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
>       at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
>       at
> org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:54)
>       at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
>       at
> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
>       at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
>       at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
>       at $Proxy41.getTrackingItem(Unknown Source)
>       at
> za.co.metcapri.status.server.services.AdminServiceBean.getTrackingItemLinks(AdminServiceBean.java:61)
>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
>       at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>       at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>       at java.lang.reflect.Method.invoke(Method.java:585)
>       at
> com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:528)
>       ... 16 more
> 
> public class TblItmdes extends BaseEntity {
> 
> //    Mapped Fields
> 
> @TableGenerator(name="tblItmdesGenerator",schema="EBSTATUS",table="TBL_KEYGEN",pkColumnName="PRIMARY_KEY_COLUMN"
>       
> ,valueColumnName="LAST_USED_ID",pkColumnValue="TBL_ITMDES_ID",allocationSize=1)
>               @Id
>       
> @GeneratedValue(strategy=GenerationType.TABLE,generator="tblItmdesGenerator")
>               @Column(name = "ITMDES_ID",nullable=false)
>               private Integer itmdesId;    
> 
>       @Basic
>       @Column(name = "DPLODR_NBR",nullable=true) 
>       private Integer dplodrNbr;
> 
>       @Basic
>       @Column(name = "ITM_CDE",nullable=true) 
>       private String itmCde;
> 
>       @Basic
>       @Column(name = "ITM_DES",nullable=true) 
>       private String itmDes;
> 
> 
> //    Mapped Relationships
>       @OneToMany(mappedBy="tblItmdes",fetch =
> FetchType.LAZY,cascade = {
> CascadeType.PERSIST,CascadeType.MERGE })
>       private Collection<TblTrklnk> tblTrklnks = new
> ArrayList<TblTrklnk>();
>       @OneToMany(mappedBy="tblItmdes",fetch =
> FetchType.LAZY,cascade = {
> CascadeType.PERSIST,CascadeType.MERGE })
>       private Collection<TblTrkdet> tblTrkdets = new
> ArrayList<TblTrkdet>();
>       public Integer getItmdesId() {
>               return getInteger(itmdesId);
>       }
>       public void setItmdesId(Integer itmdesId) {
>               this.itmdesId = itmdesId;
>       }
> 
>       public Integer getDplodrNbr() {
>               return getInteger(dplodrNbr);
>       }
>       public void setDplodrNbr(Integer dplodrNbr) {
>               this.dplodrNbr = dplodrNbr;
>       }
> 
>       public String getItmCde() {
>               return getString(itmCde);
>       }
>       public void setItmCde(String itmCde) {
>               this.itmCde = itmCde;
>       }
> 
>       public String getItmDes() {
>               return getString(itmDes);
>       }
>       public void setItmDes(String itmDes) {
>               this.itmDes = itmDes;
>       }
>       public Collection<TblTrklnk> getTblTrklnks() {
>               if (tblTrklnks == null) {
>                       tblTrklnks = new ArrayList<TblTrklnk>();
>               }
>               return tblTrklnks;
>       }
>       public void setTblTrklnks(Collection<TblTrklnk>
> tblTrklnks) {
>               this.tblTrklnks = tblTrklnks;
>       }
>       public void addTblTrklnk(TblTrklnk tblTrklnk) {
>               tblTrklnk.setTblItmdes(this);
>               getTblTrklnks().add(tblTrklnk);
>       }
>       public void removeTblTrklnk(TblTrklnk tblTrklnk) {
>               tblTrklnk.setTblItmdes(null);
>               getTblTrklnks().remove(tblTrklnk);
>       }
>       public Collection<TblTrkdet> getTblTrkdets() {
>               if (tblTrkdets == null) {
>                       tblTrkdets = new ArrayList<TblTrkdet>();
>               }
>               return tblTrkdets;
>       }
>       public void setTblTrkdets(Collection<TblTrkdet>
> tblTrkdets) {
>               this.tblTrkdets = tblTrkdets;
>       }
>       public void addTblTrkdet(TblTrkdet tblTrkdet) {
>               tblTrkdet.setTblItmdes(this);
>               getTblTrkdets().add(tblTrkdet);
>       }
>       public void removeTblTrkdet(TblTrkdet tblTrkdet) {
>               tblTrkdet.setTblItmdes(null);
>               getTblTrkdets().remove(tblTrkdet);
>       }
>       protected void synchParentRelationships(){
>               getItmdesId();
> 
>       }
>       protected void synchChildRelationships(){
>               syncCollection(getTblTrklnks());
>               syncCollection(getTblTrkdets());
>       }
> }
> 
> public class TblTrklnk extends BaseEntity {
> 
> //    Mapped Fields
> 
> @TableGenerator(name="tblTrklnkGenerator",schema="EBSTATUS",table="TBL_KEYGEN",pkColumnName="PRIMARY_KEY_COLUMN"
>       
> ,valueColumnName="LAST_USED_ID",pkColumnValue="TBL_TRKLNK_ID",allocationSize=1)
>       @Id
> 
> @GeneratedValue(strategy=GenerationType.TABLE,generator="tblTrklnkGenerator")
>       @Column(name = "TRKLNK_ID",nullable=false)
>       private Integer trklnkId;    
> 
>       @Basic
>       @Column(name = "ITMTYP_CDE",nullable=true) 
>       private String itmtypCde;
> 
>       @Basic
>       @Column(name = "ITM_CDE",nullable=true) 
>       private String itmCde;
> 
> 
> //    Mapped Relationships
>       @ManyToOne(fetch = FetchType.EAGER,cascade = {
> CascadeType.PERSIST,CascadeType.MERGE })
>       @JoinColumns([EMAIL PROTECTED](name =
> "ITMTYP_CDE",referencedColumnName="ITMTYP_CDE")})
>    
>       @ForeignKey
>       private TblItmtyp tblItmtyp;   
>       @ManyToOne(fetch = FetchType.LAZY,cascade = {
> CascadeType.PERSIST,CascadeType.MERGE })
>       @JoinColumns([EMAIL PROTECTED](name =
> "ITM_CDE",referencedColumnName="ITM_CDE")})
>    
>       @ForeignKey
>       private TblItmdes tblItmdes;   
>       public Integer getTrklnkId() {
>               return getInteger(trklnkId);
>       }
>       public void setTrklnkId(Integer trklnkId) {
>               this.trklnkId = trklnkId;
>       }
> 
>       public String getItmtypCde() {
>               return getString(itmtypCde);
>       }
>       public void setItmtypCde(String itmtypCde) {
>               this.itmtypCde = itmtypCde;
>       }
> 
>       public String getItmCde() {
>               return getString(itmCde);
>       }
>       public void setItmCde(String itmCde) {
>               this.itmCde = itmCde;
>       }
>       public TblItmtyp getTblItmtyp() {
>               return tblItmtyp;
>       }
>       public void setTblItmtyp(TblItmtyp tblItmtyp) {
>               this.tblItmtyp = tblItmtyp;
>               if(tblItmtyp!=null&&tblItmtyp.getItmtypCde()!=null){
>                       setItmtypCde(tblItmtyp.getItmtypCde());
>               }       
>       }
>       public TblItmdes getTblItmdes() {
>               return tblItmdes;
>       }
>       public void setTblItmdes(TblItmdes tblItmdes) {
>               this.tblItmdes = tblItmdes;
>               if(tblItmdes!=null&&tblItmdes.getItmCde()!=null){
>                       setItmCde(tblItmdes.getItmCde());
>               }       
>       }
>       protected void synchParentRelationships(){
>               getTrklnkId();
> 
>               if (needsToSynch(getTblItmtyp())) {
>                       setTblItmtyp(getTblItmtyp());
>               }
>               if (needsToSynch(getTblItmdes())) {
>                       setTblItmdes(getTblItmdes());
>               }
>       }
>       protected void synchChildRelationships(){
>       }
> }
> -- 
> View this message in context:
> http://n2.nabble.com/Exception-in-SQLBuffer.java-on-OpenJPA-1.3.0-SNAPSHOT-tp1141997p1141997.html
> Sent from the OpenJPA Users mailing list archive at
> Nabble.com.


      

Reply via email to