ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rich Midwinter" <rich.midwin...@gmail.com>
Subject Ibatis freezing on insert
Date Tue, 30 Oct 2007 08:22:35 GMT
Hi

I'm struggling with an insert statement that's freezing my
application. This is the last of the SQL debug output:

16:00:33,367 DEBUG Connection:26 - {conn-100079} Connection
16:00:33,369 DEBUG Connection:26 - {conn-100079} Preparing Statement:
       insert into EVENTS
(type,cost,status,date,client,user,time,duration,location,paid)
 values         (?,?,?,?,?,?,?,?,?,?)
16:00:33,371 DEBUG PreparedStatement:26 - {pstm-100080} Executing
Statement:          insert into EVENTS
(type,cost,status,date,client,user,time,duration,location,paid)
 values         (?,?,?,?,?,?,?,?,?,?)
16:00:33,372 DEBUG PreparedStatement:26 - {pstm-100080} Parameters:
[Treatment, 125, Appointment, 2007-10-28 00:00: 00.0, 1, 1, 1600, 60,
Treatment 1, false]
16:00:33,373 DEBUG PreparedStatement:26 - {pstm-100080} Types:
[java.lang.String, java.lang.String, java.lang.String,
java.sql.Timestamp, java.lang.Long, java.lang.Long , java.lang.String,
java.lang.Integer, java.lang.String, java.lang.Boolean]

This is the relevant XML configuration:

   <insert id="insertEvent" parameterClass="Event">
       insert into EVENTS
(type,cost,status,date,client,user,time,duration,location,paid)
       values

(#type#,#cost#,#status#,#date#,#client#,#user#,#time#,#duration#,#location#,#paid#)
   </insert>

It's completely repeatable. I'm using a MySQL database and when I
manually enter the query it works fine.

Can anyone suggest where I might be going wrong? Thanks

Rich

Mime
View raw message