error inserting or updating a record with date field (null allowed) using sqlmaps ---------------------------------------------------------------------------------
Key: IBATIS-289 URL: http://issues.apache.org/jira/browse/IBATIS-289 Project: iBatis for Java Type: Bug Components: SQL Maps Versions: 2.1.5 Environment: windows, netbeans, tomcat, sybase Reporter: keyur thadeshwar Priority: Blocker Hi I am trying to insert or update a record in my table which has a date field which allows NULL. but when i try inserting or updating from sqlmaps it gives an error as below com.ibatis.dao.client.DaoException: Error ending SQL Map transaction. Cause: com.sybase.jdbc3.jdbc.SybSQLException: A wrong datastream has been sent to the server. The server was expecting token 32 but got the token 33. This is an internal error. Caused by: com.sybase.jdbc3.jdbc.SybSQLException: A wrong datastream has been sent to the server. The server was expecting token 32 but got the token 33. This is an internal error. com.ibatis.dao.engine.transaction.sqlmap.SqlMapDaoTransaction.rollback(SqlMapDaoTransaction.java:51) com.ibatis.dao.engine.transaction.sqlmap.SqlMapDaoTransactionManager.rollbackTransaction(SqlMapDaoTransactionManager.java:85) com.ibatis.dao.engine.impl.DaoContext.endTransaction(DaoContext.java:112) com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:77) $Proxy14.updateTeamMember(Unknown Source) org.apache.jsp.actionModifyTransfer_jsp._jspService(actionModifyTransfer_jsp.java:171) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362) But if I do the same using simple JDBC it works and does not give any error It is bug with sqlmaps. please help -- 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 - For more information on JIRA, see: http://www.atlassian.com/software/jira