How to use a function on a parameter in an "update" mapped statement?

Hi, I want to convert a string containing a date in the format dd/month/year into a mySQL date format (/mm/dd) in an update statement. I tried: update jobs set clientid=#clientId#, summary=#summary#, jobduedate=str_to_date(#dueDate#, '%d/%m/%Y') where jobid=#id#

Re: autoCommit

Why not use BaseDaoiBATIS class from the Spring framework and specify transaction levels from xml file to do auto commit??   So no manual code is required to commit   Makes life easier   Sam - Original Message - From: Cornel Antohi To: [email protected] Se

Re: Null parameter value to stored procedure

Hi,    In ur sqlmap dao u can write   IF(object != null) {Do what ever u want}The object through which u r passing or getting value Other catch the exception through exception block . now it is upto u ki u want to catch exception at sql level or java level.Regards,Puneet Arya [EMAIL PROTECTED] wrot

many-to-many relationship practice

  Hi ibatiser,   Just a simple question on the general practice of implementing many-to-many relationship in ibatis.   I have a category object that can have many item, an item can belong to many category, hence many-to-many relationship. So I introduced an association class named Categorized