for inserts you should use the following syntax for value specification: #propertyName:TYPE#
check out page 21 of the developer's guide. I hope that helps you can use inline parameter maps. You simply need to specify the type rather than simply calling #propertyName# to extract the value. Brandon On Tue, 14 Dec 2004 15:07:33 -0500, Robert Dare <[EMAIL PROTECTED]> wrote: > > Hi all, > > The iBATIS-SqlMaps-2.pdf Developer Guide notes that when > using an Oracle driver, one mustspecify the SQL type of > a column if it is nullable. > > For doing inserts, does this mean that one must use a > <parameterMap> rather than just passing in a classType > in the statement XML? > > I read elsewhere in the iBATIS documentation that there is > a performance gain by using the classType rather than a > parameterMap attribute in the statement XML. > > Can anyone enlighten me on this subject? > > Regards, > > Rob. >

