Thanks for the answer Ron. Its seems that the problem is the "type" attribute. I'm going to change my map file ;)
--- Ron Grabowski <[EMAIL PROTECTED]> escribió: > According to the test cases: > > http://tinyurl.com/77dbg > http://svn.apache.org/repos/asf/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/OracleClient/Category.xml > > This should be the correct syntax: > > <insert id="InsertCategoryNull" > parameterMap="insert-null-params"> > <selectKey property="Id" type="pre" > resultClass="int"> > select s_categories.nextval as value from dual > </selectKey> > insert into Categories (Category_Id, > Category_Name, Category_Guid) > values (?,?,?) > </insert> > > It looks like your selectKey node is incorrect. The > .Net version has a > slightly different syntax than the Java version. For > example there is > no jdbcType attribute in the xml config files for > .Net. It is replaced > by dbType. I suggest reading the IBatisNet > documentation for more > information: > > http://ibatis.apache.org/downloads.html > > --- Angel Valero <[EMAIL PROTECTED]> wrote: > > > Hi, I'm trying to do an insert with a selectKey > > (oracle database) statement like the next one, but > it > > doesn´t assign the sequence value to the > especified > > field. Any wrong in the next xml fragment? > > > > <insert id="insertDocumento" > > parameterClass="Documento"> > > <selectKey resultClass="int" > > keyProperty="ID_DOCUMENTO" > > > SELECT DOCUMENTOS_SEQ.nextval AS > > ID_DOCUMENTO FROM DUAL > > </selectKey> > > insert into gco_documentos > > (ID_DOCUMENTO, > > ID_TEMPORADA, > > FECHA, > > DESCRIPCION, > > FICHERO, > > TIPO_DOC) > > values > > (#ID_DOCUMENTO#, > > #ID_TEMPORADA#, > > #FECHA#, > > #DESCRIPCION#, > > #FICHERO#, > > #TIPO_DOC# ) > > </insert> > > > > Thanks in advance > > > > > > > > ______________________________________________ > > Renovamos el Correo Yahoo! > > Nuevos servicios, más seguridad > > http://correo.yahoo.es > > > > ______________________________________________ Renovamos el Correo Yahoo! Nuevos servicios, más seguridad http://correo.yahoo.es
