This is much shorter...
thanks Darek ;-)
Darek Dober a écrit :
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...
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.24/101 - Release Date: 13/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... TNO
-
