[ http://issues.apache.org/jira/browse/IBATIS-39?page=history ] Clinton Begin closed IBATIS-39: -------------------------------
Assign To: Clinton Begin Resolution: Won't Fix Fix Version: 2.0.9 Thanks for all the details David. This is expected behaviour with certain databases (e.g. Oracle). The JDBC API requires that the column type be explicitly set for nullable columns when setNull is called, which means you must sepcify it in the jdbcType property of the parameter map. Perhaps the most we could do is document this better in the developer guide or the FAQ. > Unable to store null attributes as null values in a column > ---------------------------------------------------------- > > Key: IBATIS-39 > URL: http://issues.apache.org/jira/browse/IBATIS-39 > Project: iBatis for Java > Type: Bug > Components: SQL Maps > Versions: 2.0.8 > Environment: Standalone (no appserver) application in Java 1.4.2 connecting > to Sybase 12.5 using Sybase JDBC2 drivers (jconn2.jar) > Reporter: David Putnam > Assignee: Clinton Begin > Priority: Blocker > Fix For: 2.0.9 > Attachments: Customer.ibatis.xml, Customer.java, ibatis.xml, program log.txt > > Any null attribute throws a SQL Exception with an Unsupported JDBC type 0 > message. When I get back to the office I will copy actual error message and > configuration information into here. > BTW I created this because I am not sure if there is a better forum for this. > Hopefully I am not cluttering this area with a simple configuration problem. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira