|
I read somewhere in docs, that is caused
because jdbc driver 8.xx is almost full implementation of JDBC Type 3,
which uses prepareStatement in contrast to jdbc driver 7.4.xx, which does
not. So you have to explicitly specify the JDBC-type as Niels
said.
You don't have to create parameterMap just specify
the type like:
insert into table(column)
values (#column:INTEGER)
which is much shorter:)
Darek Dober
----- Original Message -----
Sent: Tuesday, September 13, 2005 10:18
AM
Subject: Re: Postgres - inserting null
causes error - Unknown Types value
To avoid this, I create a parameterMap for my insert and
update.
Niels Beekman a écrit :
I do not know
PostgreSql very well, but could it be that you have to explicitly specify
the JDBC-type, as in Oracle?
Niels
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)
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.23/99 - Release Date: 12/09/2005
--
Il n'y a pas de mauvais langage, il n'y a que des bons programmeurs...
|
- Re: Postgres - inserting null causes error - Unknown Types v... Darek Dober
-
