Multiple where clause

2006-09-26 Thread Pradheep
hi   how do we implement multiple where clause in a single xml file.based on the conditions, where clause has to be appended with the select query.   i have a select query and on different conidtions, i need to append the where clause to the SELECT statement.   how do we do that.   PraDheep

iBATIS - Joins ?

2006-09-21 Thread Pradheep
hey   can anyone let me know how to work on joins in iBATIS.   this is the query i am goin to use.   select a.versionnumber, a.releasedate, a.releasenotes, b.releasetype from versioninfo as a, releaseinfo as b where a.productid = 1 and a.releaseid = b.releaseid;   C ya  P R A D

Re: Gazzag - Rahesh Kumar invited you to join his/her friends network!

2006-09-05 Thread Pradheep
REJECTED - Original Message - From: Rahesh Kumar To: pradheep Sent: Wednesday, September 06, 2006 9:51 AM Subject: Gazzag - Rahesh Kumar invited you to join his/her friends network! Hi pradheep,Rahesh Kumar [EMAIL PROTECTED] invited you to join his

How to use CGLIB with iBATIS

2006-08-03 Thread Pradheep
Dear All   can you pls put an example or help me on how to use CGLIB with ibatis.   Regards  P R A D H E E P A P P L I E D    D E V E L O P M E N T  Team LeaderChennai, Indiae: [EMAIL PROTECTED] l: 00 91 44 39125333m: 00 91 94862 08089

Reuse SQL

2006-08-02 Thread Pradheep
wats the benefit of using the both? SELECT COUNT(*) AS total FROM items WHERE parentid = 6 SELECT id, name FROM items WHERE parentid = 6 -

Re: Probs connecting

2006-07-25 Thread Pradheep
is looking for commons-logging, which has not been a part of iBATIS for many months.Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory I'd suggest getting a newer version of iBATIS.LarryOn 7/25/06, Pradheep < [EMAIL

Re: Probs connecting

2006-07-25 Thread Pradheep
/06, Pradheep < [EMAIL PROTECTED]> wrote: yoyo   my application is simply using a DAO object and getting 3 values and inserting into database.   am using this code   Database: MySQL Framework: iBATIS   DAOManager.java

Re: Probs connecting

2006-07-25 Thread Pradheep
- Original Message - From: Pradheep To: user-java@ibatis.apache.org Sent: Tuesday, July 25, 2006 2:00 PM Subject: Probs connecting yoyo   my application is simply using a DAO object and getting 3 values and inserting into database.   am

Probs connecting

2006-07-25 Thread Pradheep
yoyo   my application is simply using a DAO object and getting 3 values and inserting into database.   am using this code   Database: MySQL Framework: iBATIS   DAOManager.java reader = Resources.getResourceAsReader(resource); sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);   its throw

Re: iBATS & CGLIB

2006-07-11 Thread Pradheep
Clinton   Thanks for your suggestion and now tried using Batch Process. 5000 records and its 2696 msecs.   Regards Pradheep - Original Message - From: Clinton Begin To: user-java@ibatis.apache.org Sent: Wednesday, July 12, 2006 10:28 AM Subject: Re: iBATS

iBATS & CGLIB

2006-07-11 Thread Pradheep
Dear   i am inserting some 5000 records and the table has only 2 columns with the id and name where id is autoincremented and name is also added with the auto number [say pradheep+i] i just checked a sample of 5000 records and the time it took vaires accordingly Inserting 5000 records