Re: Ibatis : multiple insert

I think you need to iterate over the bookList in your Java code and call your insert multiple times. Take the out of the insert. Maybe this will help you: http://www.mail-archive.com/user-java@ibatis.apache.org/msg04760.html Also, what's with the WHERE clause in your INSERT statement? I'm n

Ibatis : multiple insert

hi, I have to do multiple insert in same time and for the moment I not found how do it. exemple : for one student I have to do insert all books Student student { Sring name . List bookList; } (studentTable ) 1-- n(bookTable) whene I insert a student I need

Re: java.sql.SQLException: ORA-01722: invalid number

Thanks for the reply.   Actually I did without having the to_number() but still it is giving me the issue. I am trying to do the following inside select statement:   select (case when #endDate# - least(#startDate# + (nDays * #granularity#), #endDate#) < #granularity# then #endDate# - (#granular

Re: java.sql.SQLException: ORA-01722: invalid number

When you subtract two dates the result already is a number. Using to_number on the result will make Oracle do an implicit conversion to CHAR and then trying to convert it back again. Depending on your NLS-parameters that implicit conversion will break stuff. Regards, Joakim On Sat, 2008-08-23 a