Oops.. my mistake... actually after reading again the issue in confluence, i completely missed this line : "Now you may be asking yourself what are the valid jdbc types. Look no further they are posted in the Java API documents java.sql.Types" i never thought about it.. I changed the mappings to : <insert id="insertEmp" parameterClass="java.util.HashMap"> INSERT INTO EMP ( EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
VALUES ( #empno:INTEGER#, #ename:VARCHAR#, #job:VARCHAR#, #mgr:INTEGER#, #hiredate:DATE#, #sal:DOUBLE#, #comm:DOUBLE#, #deptno:INTEGER#) </insert> and the statement works... really thanks for the help :) Yusuf. -----Original Message----- From: Jeff Butler [mailto:[EMAIL PROTECTED] Sent: Thursday, April 27, 2006 10:01 AM To: [email protected] Subject: Re: Invalid Column Type issue in confluence The JDBC type specified in the mapping can only be one of the standard JDBC types that are listed in java.sql.Types. Some of the types you are specifying (VARCHAR2, NUMBER) are invalid - and iBATIS will use Types.OTHER in those cases. This is likely that cause of the problem you are seeing. Switch to one of the supported datatypes - that will probably solve it. Jeff Butler
