Re: Many DB sessions are left

2007-12-06 Thread Makoto Takiuchi
Hi, It came to move well. such as follows Thank you Makoto Takiuchi [EMAIL PROTECTED] さんは書きました: >The JDBC implies explicit trasnaction control...this is in the code? > Thank you, >Christopher > >~ >Christopher McCauley >Unisys Consultant >GSA - Federal Acqui

RE: MySQL related question - constraint violation

2007-12-06 Thread Poitras Christian
My guess is that something changed between those version. Either LAST_INSERT_ID() changed or how foreign keys are managed. In either case, you'll find better information on MySQL list or release notes. It could also be something not directly linked to the message like triggers. Christian -

RE: MySQL related question - constraint violation

2007-12-06 Thread Brian Parkinson
HI Toby: Yes - the exact same SQL script is used to set up both databases (and yes - InnoDB). Same SQL script to set up the databases and tables (and created from scratch each time). Same Java code unit tests - the only difference is Debian (5.0.32) as opposed to Windows/Mac (5.0.45). Weird, huh

Re: MySQL related question - constraint violation

2007-12-06 Thread Toby Thain
On 6-Dec-07, at 11:46 AM, Brian Parkinson wrote: Hello - Wondering if someone out there has some MySQL experience - running into a weird issue, and I'm stumped. This is perhaps not exactly an iBATIS issue, but I received no response over at the MySQL forums, so it's worth a shot: I have a

Re: Many DB sessions are left

2007-12-06 Thread chris . mccauley
The JDBC implies explicit trasnaction control...this is in the code? Thank you, Christopher~Christopher McCauleyUnisys ConsultantGSA - Federal Acquisition ServiceCP3 11028B(703) 605 9160[EMAIL PROTECTED][EMAIL PROTECTED]-"Makoto Takiuchi" <[EMAIL PROTECTED]> wrote: -To: [EMA

MySQL related question - constraint violation

2007-12-06 Thread Brian Parkinson
Hello - Wondering if someone out there has some MySQL experience - running into a weird issue, and I'm stumped. This is perhaps not exactly an iBATIS issue, but I received no response over at the MySQL forums, so it's worth a shot: I have a very simple data model working in iBATIS (getting famili

Walter Heestermans/TMME is out of the office.

2007-12-06 Thread Walter . Heestermans
I will be out of the office starting 06/12/2007 and will not return until 07/12/2007. I will respond to your message when I return. For urgent issues, contact WebSphere Support group.

RE: A couple newbie questions

2007-12-06 Thread Brian Parkinson
Hi Larry: I wasn't going to use column indexes (fragile) but this solution is perfect. Thanks. parki... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Meadors Sent: Wednesday, December 05, 2007 11:06 PM To: user-java@ibatis.apache.org Subject: R

Re: Many DB sessions are left

2007-12-06 Thread Makoto Takiuchi
Hi, I am using the following Out system has 100/tps transactions. Always Oracle sessions was left (abount 300-500 sessions) >Are you using a connection pool that is created outside of iBATIS? > >Larry > > >On Dec 5, 2007 7:13 PM, 瀧内誠 <[EMAIL PROTECTED]> wrote: >> >> Hi, >> >