Re: Mysql Database not showing the inserted record

2007-12-12 Thread AVenkatesan
Thank For your reply Axel But at last i tried following whicvh got worked, sqlMapClient.startTransaction(); sqlMapClient.insert("Code.insertCode",code); sqlMapClient.flushDataCache(); sqlMapClient.commitTransaction(); sqlMapClient.endTransaction(); Thanks Venkates

AW: Mysql Database not showing the inserted record

2007-12-12 Thread Leucht, Axel
Instead of calling update() try Object primaryKey = sqlMapSession.insert("insertCode",code); /Axel

Mysql Database not showing the inserted record

2007-12-12 Thread AVenkatesan
iam trying to run a simple ibatis insert statement as follows: I have code as following try{ SqlMapSession sqlMapSession= sqlMapClient.openSession(); sqlMapSession.startTransaction(); int i=sqlMapSession.update("insertCode",code); sqlMapSession.commitTrans

Re: How do I customize the criteria

2007-12-12 Thread Jeff Butler
Here's one way to do it. First make this class... public class MyCriteria extends XYZExample.Criteria { public MyCriteria addCustomCriteria(String value) { addCriterion("col1 || \"\" like", value, "col1"); return this; } } Then use it like this... XYZExample example = new XYZExample

How do I customize the criteria

2007-12-12 Thread Vinaya Tirikkovalluru
Hi, I have a case where I need to do the following Select * from abc.XYZ where col1 || "" Like (some value) How do I do that? I tried extending the Example class and Criteria. Had some problems, though. Was hoping somebody might have done it earlier. Thanks Vinaya This elec

Re: On Before Get Connection

2007-12-12 Thread Jeff Butler
You could implement your own transaction manager and do the initiailzation there before returning the connection to iBATIS. Jeff Butler On Dec 12, 2007 4:19 AM, Denis Karpov <[EMAIL PROTECTED]> wrote: > I can't use ping query because i can't specify parameters in it. > > > That would be the pi

Re: On Before Get Connection

2007-12-12 Thread Denis Karpov
I can't use ping query because i can't specify parameters in it. That would be the ping query (to test if the connection is alive)? * * * * * * -Original Message- From: Denis Karpov [mailto:[

Re: AW: On Before Get Connection

2007-12-12 Thread Denis Karpov
I need to set up some environment (like current user, operation date...) in DB before executing any SQL. It is legacy system. In more simple words. I need to execute one stored procedure with parameters when iBatis gets connection from pool. What do you want to achieve? /Axel .

RE: On Before Get Connection

2007-12-12 Thread Meindert
That would be the ping query (to test if the connection is alive)? -Original Message- From: Denis Karpov [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 12, 2007 12:01 PM To: user-java

AW: On Before Get Connection

2007-12-12 Thread Leucht, Axel
What do you want to achieve? /Axel

Lambert Torres/NJ/NBA is out of the office.

2007-12-12 Thread Lambert Torres
I will be out of the office starting 08/02/2002 and will not return until 12/20/2007. I will be out of the office from 12/11 - 12/21. I will be back in the office 12/26. Please refer any concerns to Tak Yue Cheng or Helpdesk (x6123) in my absence. Thanks Celebrate NBA Heritage Week 2007 pr

On Before Get Connection

2007-12-12 Thread Denis Karpov
When iBatis gets a connection from the pool for processing, how can I execute some initialization SQL before this connection will be used by iBatis? Thanks