ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jason Punzalan <jasonpunza...@gmail.com>
Subject invalid column type
Date Wed, 27 Apr 2005 03:17:26 GMT
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

Mime
View raw message