Done: https://issues.apache.org/jira/browse/IBATIS-694
Thanks :)
-- Edvin
Clinton Begin skrev:
Cool. Thanks for diggin in to figure it out. Can you log a jira
ticket for this? (Just paste the email body in)
On Fri, Nov 13, 2009 at 8:29 AM, Edvin Syse <[email protected]
<mailto:[email protected]>> wrote:
I just figured it out. The folder property of my domain object was
null. It seems that the error message blaims the selectKey
statement instead of the insert-statement. If it is possible to
separate them so that the error message is more
informative/correct, I think a lot of confusion can be avoided :)
-- Edvin
Edvin Syse skrev:
Hi!
I have declared a sequence in Postgres and try to use it in a
selectKey statement that runs before an insert:
<insert id="insert" parameterType="MessageSummary">
<selectKey keyProperty="id" resultType="int" order="BEFORE">
SELECT nextval('messages_id_seq')
</selectKey>
INSERT INTO messages (id, folder, uid, subject,
deliverydate, date, from, size, attachments, expunged, read)
VALUES (#{id}, #{folder.id <http://folder.id>}, #{uid},
#{subject}, #{deliveryDate}, #{date}, #{from}, #{size},
#{attachments}, #{expunged}, #{read})
</insert>
This yields the following exception:
org.apache.ibatis.exceptions.IbatisException:
### Error updating database. Cause:
org.apache.ibatis.type.TypeException: JDBC requires that the
JdbcType must be specified for all nullable parameters.
### The error may exist in
no/tornado/mail/mappers/MessageMapper.xml
### The error may involve
no.tornado.mail.mappers.MessageMapper.insert-Inline
### The error occurred while setting parameters
### SQL: SELECT nextval('messages_id_seq')
### Cause: org.apache.ibatis.type.TypeException: JDBC requires
that the JdbcType must be specified for all nullable parameters.
at
org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:95)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:82)
at
org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:49)
at
org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:18)
The query for nextval() returns an integer. None of the
columns in the database are nullable, and the SQL it's
complaining about doesn't contain any parameters at all.
I have another statement using the same syntax that actually
works:
<insert id="insert" parameterType="MailFolder">
<selectKey keyProperty="id" resultType="int" order="BEFORE">
SELECT nextval('folders_id_seq')
</selectKey>
INSERT INTO folders (id, userid, uidvalidity, parent,
path) VALUES (#{id}, #{userId}, #{uidValidity}, #{parent.id
<http://parent.id>,jdbcType=NUMERIC}, #{path})
</insert>
This table has one nullable column. Both sequences are created
using the same syntax (CREATE sequence <sequence-name>;)
Am I doing something wrong, or could this be a bug?
Sincerely,
Edvin Syse
---------------------------------------------------------------------
To unsubscribe, e-mail:
[email protected]
<mailto:[email protected]>
For additional commands, e-mail:
[email protected]
<mailto:[email protected]>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
<mailto:[email protected]>
For additional commands, e-mail: [email protected]
<mailto:[email protected]>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
