Thanks for the suggestion, I will try the jTDS driver. -----Original Message----- From: Brian Bruns [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 02, 2005 6:15 PM To: ibatis-user-java@incubator.apache.org Subject: Re: Populating 2 lists within a class
You might have better luck using jTDS (jtds.sourceforge.net). On Wed, 2 Mar 2005 16:04:06 -0800, Warren Bell <[EMAIL PROTECTED]> wrote: > Sybase using an ODBC driver > > -----Original Message----- > From: Clinton Begin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 02, 2005 3:35 PM > To: ibatis-user-java@incubator.apache.org > Subject: Re: Populating 2 lists within a class > > Uh oh. Would you by chance be using Microsoft Access or perhaps MS SQL > Server? > > Cheers, > Clinton > > On Wed, 2 Mar 2005 15:02:50 -0800, Warren Bell > <[EMAIL PROTECTED]> wrote: > > I have a class that has two Lists as properties. I can populate one or the > > other List, but I can not seem to get both of them populated. I have > > switched the order of the List mappings and it always has a problem with > the > > last one listed. The two lists are itemMovement and itemPromoPrices1 in > the > > result map "get-Item-Result1". I am getting a java.sql.SQLException: No > data > > found Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:. Any > > help will be appreciated. > > > > <resultMap id="get-Item-Result1" class="item"> > > <result property="upc" column="INV_ScanCode"/> > > <result property="desc" column="INV_Name"/> > > <result property="brand" column="BRD_Name"/> > > <result property="size" column="INV_Size"/> > > <result property="unit" column="PI1_Description"/> > > <result property="department" column="DPT_Name"/> > > <result property="category" column="PI4_Description"/> > > <result property="vendorSKU" column="ORD_SupplierStockNumber"/> > > <result property="cost" column="INV_LastCost"/> > > <result property="price" column="SIB_BasePrice"/> > > <result property="itemMovement" column="INV_ScanCode" > > select="getItemMovement1"/> > > <result property="itemPromoPrices1" column="INV_ScanCode" > > select="getItemPromoPrice1"/> > > </resultMap> > > > > <resultMap id="get-Item-Promo-Price-Result1" class="promoPrice1"> > > <result property="upc" column="INV_ScanCode"/> > > <result property="description" column="PCD_WRKName"/> > > <result property="salePrice" column="PCD_Price_pl1"/> > > <result property="promoStartDate" column="PCD_PSWStartDate"/> > > <result property="promoEndDate" column="PCD_PSWEndDate"/> > > <result property="priorityLevel" column="PCD_PriorityLevel"/> > > <result property="discountKey" column="PCD_DIS_FK_pl1" > > nullValue="-999"/> > > </resultMap> > > > > <resultMap id="get-Item-Movement-Result1" class="movement"> > > <result property="upc" column="Scancode"/> > > <result property="movementDate" column="ISG_StartTime"/> > > <result property="quantity" column="SIT_Quantity"/> > > </resultMap> > > > > <select id="getItem1" parameterClass="java.lang.String" > > resultMap="get-Item-Result1"> > > SELECT INV_ScanCode, INV_Name, BRD_Name, INV_Size, PI1_Description, > > DPT_Name, PI4_Description, ORD_SupplierStockNumber, INV_LastCost, > > SIB_BasePrice FROM v_InventoryMaster WHERE INV_ScanCode = #value# > > </select> > > > > <select id="getItemPromoPrice1" parameterClass="java.lang.String" > > resultMap="get-Item-Promo-Price-Result1"> > > SELECT INV_ScanCode, PCD_WRKName, PCD_Price_pl1, PCD_PSWStartDate, > > PCD_PSWEndDate, PCD_PriorityLevel, PCD_DIS_FK_pl1 FROM v_InventoryMaster, > > PriceChangeData WHERE INV_PK = PCD_INV_FK AND INV_CPK = PCD_INV_CFK AND > > INV_ScanCode = #value# > > </select> > > > > <select id="getItemMovement1" parameterClass="java.lang.String" > > resultMap="get-Item-Movement-Result1"> > > SELECT Scancode, ISG_StartTime, SIT_Quantity FROM v_SummaryItems WHERE > > Scancode = #value# > > </select> > > > > Thanks, > > > > Warren Bell > > Systems Administrator > > Clark's Nutritional Centers > > 4225 Market St. > > Riverside, CA 92501 > > 951-321-1960 ext. 142 > > 909-645-8864 mobile > > > > > >
