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
