ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zarar Siddiqi" <zarar.sidd...@utoronto.ca>
Subject Re: Postgres - inserting null causes error - Unknown Types value
Date Wed, 14 Sep 2005 13:30:08 GMT
Thanks for all the replys.  The answer was to create a parameter map (or use inline parameters
which specify jdbc type).  MySQL definitely handles it more gracefully than PostGres.
  ----- Original Message ----- 
  From: Niels Beekman 
  To: user-java@ibatis.apache.org 
  Sent: Tuesday, September 13, 2005 12:35 PM
  Subject: RE: Postgres - inserting null causes error - Unknown Types value


  I do not know PostgreSql very well, but could it be that you have to explicitly specify
the JDBC-type, as in Oracle?

   

  Niels

   


------------------------------------------------------------------------------

  From: Zarar Siddiqi [mailto:zarar.siddiqi@utoronto.ca] 
  Sent: dinsdag 13 september 2005 15:15
  To: user-java@ibatis.apache.org
  Subject: Postgres - inserting null causes error - Unknown Types value

   

  I'm having a problem with iBatis using PostgreSql.

   

  I have an insert statment, "insertEndUser" which I pass an "EndUser" object to for inserting.
 If all the properties of the EndUser object are non-null, the insert works fine, but if ANY
of them are null, I get the following exception, (in this case "gender" was null).  I'm using
the Spring (1.2.4) framework and it's SqlMapClientTemplate class to do the insert.

   

  Any ideas of what might be wrong.  I was thinking of using a type handler to make the mapping
from null to empty String but this seems too trivial of a problem for it to require extreme
measures.  I'm migrating from MySql to PostgreSql and this was working just fine in MySql.
 

   

  Any input is appreciated. 

   

   


  org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar
[]; nested exception is
  com.ibatis.common.jdbc.exception.NestedSQLException:
  --- The error occurred in com/_8020/mcc/dao/ibatis/sql/EndUserSQL.xml.
  --- The error occurred while applying a parameter map.
  --- Check the insertEndUser-InlineParameterMap.
  --- Check the parameter mapping for the 'gender' property.
  --- Cause: org.postgresql.util.PSQLException: Unknown Types value.
  com.ibatis.common.jdbc.exception.NestedSQLException:
  --- The error occurred in com/company/dummy/dao/ibatis/sql/EndUserSQL.xml.
  --- The error occurred while applying a parameter map.
  --- Check the insertEndUser-InlineParameterMap.
  --- Check the parameter mapping for the 'gender' property.
  --- Cause: org.postgresql.util.PSQLException: Unknown Types value.
  Caused by: org.postgresql.util.PSQLException: Unknown Types value. at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:87)
   at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:442)

Mime
View raw message