RE: Database Connection reset on Oracle 10g AS using Oracle 11g database

2009-10-07 Thread Jasmin Mehta
=logAbandoned value=false/ property name=validationQuery value=select 1/ /bean Hope it helps From: Jasmin Mehta [mailto:jasmin_me...@nexweb.org] Sent: 06 October 2009 04:05 PM To: user-java@ibatis.apache.org Cc: lmead...@apache.org Subject: Database Connection reset on Oracle

Database Connection reset on Oracle 10g AS using Oracle 11g database

2009-10-06 Thread Jasmin Mehta
Larry, I saw an answer for one of the thread http://www.mail-archive.com/user-java@ibatis.apache.org/msg03522.html I have something similar, How do I modify spring.xml file to use BasicDataSource feature to ping the query? I have J2EE application running on OC4J application server. Where

RE: Database Connection reset on Oracle 10g AS using Oracle 11g database

2009-10-06 Thread Jasmin Mehta
/ property name=validationQuery value=select 1/ /bean Hope it helps From: Jasmin Mehta [mailto:jasmin_me...@nexweb.org] Sent: 06 October 2009 04:05 PM To: user-java@ibatis.apache.org Cc: lmead...@apache.org Subject: Database Connection reset on Oracle 10g AS using Oracle 11g database Larry

ORA-00923: FROM keyword not found where expected

2009-10-06 Thread Jasmin Mehta
From: Jasmin Mehta/VAB/HQ/NEXNET To: user-java@ibatis.apache.org Date: 10/06/2009 01:57 PM Subject: RE: Database Connection reset on Oracle 10g AS using Oracle 11g database I have changed my spring.xml accordingly: bean id=dataSource class=org.apache.commons.dbcp.BasicDataSource

Re: Database Connection reset on Oracle 10g AS using Oracle 11g database

2009-10-06 Thread Jasmin Mehta
That worked.. Thanks. From: Larry Meadors larry.mead...@gmail.com To: user-java@ibatis.apache.org Date: 10/06/2009 02:23 PM Subject: Re: Database Connection reset on Oracle 10g AS using Oracle 11g database Use select 1 from dual instead. On Tue, Oct 6, 2009 at 10:57 AM, Jasmin Mehta

Check database before INSERT in iBatis

2009-03-31 Thread Jasmin Mehta
Hi, I have customer registration web application. Where it takes 3 pages to complete the process before submit. Once customer is registered, i.e. the records are inserted into 3 different tables then user can edit the registration. Right now, I have a code that retrieves the record from each

How to Compare database record before UPDATE using iBatis?

2009-03-31 Thread Jasmin Mehta
I thought the Subject line of my question earlier was kind of misleading. Here is the same question with suitable subject line. From: Jasmin Mehta jasmin_me...@nexweb.org To: user-java@ibatis.apache.org Date: 03/31/2009 07:50 AM Subject: Check database before INSERT in iBatis Hi, I have

Re: How to Compare database record before UPDATE using iBatis?

2009-03-31 Thread Jasmin Mehta
Sent from my iPhone On Mar 31, 2009, at 4:54 AM, Jasmin Mehta jasmin_me...@nexweb.org wrote: I thought the Subject line of my question earlier was kind of misleading. Here is the same question with suitable subject line. From: Jasmin Mehta jasmin_me...@nexweb.org To: user-java

How to define alias in resultMap

2009-03-27 Thread Jasmin Mehta
Hi, With below code how do I get correct value for dependent first name and dependent last name? Right now as both qol_customer and qol_dependet has same field name for FIRST_NAME and LAST_NAME, I am getting qol_customer's FIRST_NAME and LAST_NAME populated in

Re: How to define alias in resultMap

2009-03-27 Thread Jasmin Mehta
I can not change the column names of table QOL_DEPENDENT from FIRST_NAME to DEP_FIRST_NAME It has to be the same. From: Brandon Goodin brandon.goo...@gmail.com To: user-java@ibatis.apache.org Date: 03/27/2009 11:59 AM Subject: Re: How to define alias in resultMap typeAlias alias=customerVo

Re: How to define alias in resultMap

2009-03-27 Thread Jasmin Mehta
Silver Mind Software http://www.silvermindsoftware.com bgoo...@silvermindsoftware.com 615-306-3652 http://www.linkedin.com/in/bgoodin On Fri, Mar 27, 2009 at 11:03 AM, Jasmin Mehta jasmin_me...@nexweb.org wrote: I can not change the column names of table QOL_DEPENDENT from FIRST_NAME

Transaction Rollback not working with iBatis + Spring

2009-03-05 Thread Jasmin Mehta
Hi, I have 2 tables CUSTOMER and DEPENDENT. In CUSTOMER table the primary key is cust_id which is foreign key to DEPENDENT table. I would like to make insert to both tables together as a batch and also if one fails than other must roll back. If I remove the constraints of having cust_id as

Mutiple resultset in select - how to

2009-01-28 Thread Jasmin Mehta
Hi, I have two tables for which I would like to run one select query by joining them thru primary keys but would like to use two separate Value Objects to store them. That requires to have more than one 'resultMap' attribute in select tag. Is it possible? I am using iBATIS 2.3.0. Here is code