You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "keyur thadeshwar (JIRA)" <ib...@incubator.apache.org> on 2006/04/19 16:19:34 UTC

[jira] Created: (IBATIS-289) error inserting or updating a record with date field (null allowed) using sqlmaps

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


[jira] Closed: (IBATIS-289) error inserting or updating a record with date field (null allowed) using sqlmaps

Posted by "Larry Meadors (JIRA)" <ib...@incubator.apache.org>.
     [ http://issues.apache.org/jira/browse/IBATIS-289?page=all ]
     
Larry Meadors closed IBATIS-289:
--------------------------------

    Resolution: Won't Fix

Please post support questions to the mailing lists: 

http://ibatis.apache.org/mailinglists.html



> 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