Make sure you've specified the JDBC type of *ALL* nullable columns. Oracle requires the type for nullable columns to be specified. Otherwise when you try to set a null value you'll get that invalid column type error.
Cheers, clinton On 4/26/05, Jason Punzalan <[EMAIL PROTECTED]> wrote: > this works on mysql but not on oracle. same table layout. any ideas? > > <insert id="insertContent" parameterClass="Content" > > <![CDATA[ > insert into content(publication, modified_by, priority, source, type_id, > body, id, subtitle, title, isFeature, modified, summary, page_id, enabled, > created_by, created, status, sub_type) > > values(#publication#, #modifiedBy#, #priority#, #source#, #typeId#, #body#, > #id#, #subtitle#, #title#, #isfeature#, now(), #summary#, #pageId#, > #enabled#, #createdBy#, now(), "draft", #subType.id#) > ]]> > > </insert> > > > > org.springframework.jdbc.UncategorizedSQLException: > (SqlMapClient operation): encountered SQLException [ > --- The error occurred in com/ruderfinn/maps/Content.xml. > > --- The error occurred while applying a parameter map. > --- Check the insertContent-InlineParameterMap. > --- Check the parameter mapping for the 'isfeature' property. > --- Cause: java.sql.SQLException: Invalid column type]; nested exception is > com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred in com/ruderfinn/maps/Content.xml. > --- The error occurred while applying a parameter map. > --- Check the insertContent-InlineParameterMap. > > --- Check the parameter mapping for the 'isfeature' property. > --- Cause: java.sql.SQLException: Invalid column type > com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred in com/ruderfinn/maps/Content.xml. > > --- The error occurred while applying a parameter map. > --- Check the insertContent-InlineParameterMap. > --- Check the parameter mapping for the 'isfeature' property. > --- Cause: java.sql.SQLException: Invalid column type > > Caused by: java.sql.SQLException: Invalid column type > > > > >
