[FRIDAY OT ANN] My new project is beta

roomity.com to check it out. it should help you use mail lists. It's RiA/JDNC (it uses iBatis :-)). There should be updates weekly and it should release in days. hope you like. .V

Result as Xml, and lower/upper case

Hi, According to the documentation it is possible to name xml nodes with mix of upper/lower case, i.e Johnson But it doesn't work for me. All nodes are lower case: SELECT AFFR.AFFAIR_NO AS affairNumber ,DEBT.LASTNAME as lastName FROM AFFAIRS AFFR LEFT JOIN D

Using SQL select to populate values in a contained object

List:   I am using Oracle and I want to run an sql statement that looks similar to this:   Select     price as "product.price" From     ProductPrices   My intention is that the "product" object inside my resultClass="" will have it's setPrice() method called.  If I

Re: iBatis help on list

Yep.  Version 2.1.5 can be released any time.  I think everyone just got really busy in the last couple of weeks.  We'll try to release it ASAP. Cheers, Clinton On 7/15/05, Gana <[EMAIL PROTECTED]> wrote: I am wondering any future releases on the way We are abt implementfor new release if the

iBatis help on list

I am wondering any future releases on the way We are abt implement for new release if the beta is available... - Gana.

[ignore] Just a test

message, please ignore it.

Re: connection fails with sybase

I too had the same problem with MySQL and having the driver jar in classpath solved it :-) Guido García Bernardo wrote: Is your driver in the classpath? Dropping the driver .jar file into your TOMCAT_HOME\common\lib directory should work fine... Regards Bertulu Gianluca wrote: Hi, I'm usin

Re: check if one of two fields are null

I'd do it in Java, before the mapped statement is called. Larry On 7/15/05, Nathan Maves <[EMAIL PROTECTED]> wrote: > I need to have a dynamic query that appends a where clause if one of > two fields are null. > > I could only come up with > > > DO THIS > > > > DO THIS >

check if one of two fields are null

I need to have a dynamic query that appends a where clause if one of two fields are null. I could only come up with DO THIS DO THIS This is obviously wrong since the code could be appended twice. I need to combine these two statement so that DO THIS is only executed if

Re: multiple delete in sqlmap

According to that what I know mysql in version 3.xx doesn't support constraints at all:), also subqueries, triggers and so on ... Version 4.xx has some of that futures. Check documentation. I'm not up to date with mysql now:) But, check i.e here. Probably it is not supported http://groups.google

RE: Using WHERE IN along with AND

Can you not use R.ORD_ID = O.ORD_ID Steve... -Original Message-orderIdList From: Rao, Satish [mailto:[EMAIL PROTECTED] Sent: Thu 7/14/2005 4:23 PM To: user-java@ibatis.apache.org Subject: Using WHERE IN along with AND I have the following and it throws a UncategorizedSQL

SV: multiple delete in sqlmap

Hi there! Is it related rows you are trying to delete ? Then you should define FK's between the NUM_OBJ's on the tables and use casade delete, and delete the row in the main table (FUN_OBJECT ??) = only one delete statement But not sure if MySQL have cascade delete ?? Take care, E

R: multiple delete in sqlmap

Maybe it's a limitation of MySql...   Fab Da: olivier ZILLER [mailto:[EMAIL PROTECTED] Inviato: venerdì 15 luglio 2005 15.50A: user-java@ibatis.apache.orgOggetto: Re: multiple delete in sqlmap you're right : it doesn't works...it seems i'll have to create mutliple delete statements...thank

Re: multiple delete in sqlmap

you're right : it doesn't works... it seems i'll have to create mutliple delete statements... thanks Larry Meadors a écrit : did you try to do this through JDBC? Larry On 7/13/05, olivier ZILLER <[EMAIL PROTECTED]> wrote: hello, i'm using sqlmap and mysql and try to execute a

R: is Ibatis right for this?

It's very easy to do that in iBATIS. I can suggest you two different methods to do it: 1) Use resultClass="java.util.HashMap" and then, in your jsp, iterate within its keys/values. 2) Let iBATIS convert the results in XML, using the following attributes: resultClass="xml" xmlResultName=”myroot”

is Ibatis right for this?

Hello my project manager asks me if I can do this with iBatis... I have to make a generic search + result web app I have to build a form reading from db the tables of the from clause, the fields to read and the where parameters (everything...) with this request parameters I have to b