It's amazing what a two-hour break and a cup of tea can do for you. The code posted in the earlier message was 100% correct EXCEPT the following word: parmaterMap
Thanks to David for pointing me in the right direction. Zarar -------Original Message------- > From: Zarar Siddiqi <[EMAIL PROTECTED]> > Subject: RE: TypeHandler Problem using <parameterMap> > Sent: 18 Aug '05 14:00 > > > I've changed it to the one you've described (which is similar to the ones > mention in the docs). And the read part still works fine. However, I think > this is really an issue of the paramerMap being applied incorrectly. Using > the ? style, I have the following which refuses to insert but when i use > inline parameter maps instead of ?, everthing works fine. You mentioned that > there is another way of applying parameter maps (using @ShipmentId etc) which > I somewhat prefer. I can't find documentation on that anywhere. Can > somebody point me in the right direction. > > Thanks for all your help. > > In agony, > Zarar > > <statement id="insertShipmentDimensions" parmaterMap="parameterDimensions"> > INSERT INTO nlmi_dimensions > (ShipmentId,Pieces,Weight,Length,Width,Height,Stackable) > VALUES (?,?,?,?,?,?,?) > </statement> > > <parameterMap id="parameterDimensions" class="pearl.nlmi.vo.Dimensions"> > <parameter property="ShipmentId"/> > <parameter property="Pieces"/> > <parameter property="Weight"/> > <parameter property="Length"/> > <parameter property="Width"/> > <parameter property="Height"/> > <parameter property="Stackable" dbType="Varchar" > type="bool"/> > </parameterMap> > > > > > > > > > -------Original Message------- > > From: David Marzo (Puzzlet) <[EMAIL PROTECTED]> > > Subject: RE: TypeHandler Problem using <parameterMap> > > Sent: 18 Aug '05 11:33 > > > > I use custom TypeHandler with no problem, but i declare a type handler > > in > > SqlMap.config > > > > Like: > > > > <typeHandler type="System.Decimal" dbType="Decimal" > > callback="persistence.access.mapper.AccessDecimalTypeHandlerCallBack,Per > > sistence.Access"></typeHandler> > > > > But I belive thath set TypeHandler in Property works fine, set up a > > breakpoint in > > > > IBatisNet.DataMapper.MappedStatements. ApplyResultMap( ... ) in Line 277 > > > > An see if the value of property.TypeHandler is correct. > > > > First try to replace the #ShipmentId#, # Pieces #, #Weight#, #Length#, > > ... > > in the insertShipmentDimensions for ?,?,?,etc .. or named parameters > >[EMAIL PROTECTED], @Pieces, etc .. > > I think ## is interpreted as inline parameter ingnoring your > > parameterMap configuration ;-). > > > > Note: MS access no support milliseconds in DateTime but OleDB provider > > support it. That cause an error when you try to INSERT/UPDATE a DateTime > > with not milliseconds set to cero, I fix this with a TypeHandler ;-) > > > > Hope this help > > > > > > > > > -------Original Message------- > -------Original Message-------
