Blocking one -help needed on dynamic changing of conjuction property

2008-12-02 Thread yuvraj.shinde
HI all, I am using criteria querry and following is the where clause for the same. sql id=Criteria_Where_Clause iterate property=oredCriteria conjunction=or prepend=where removeFirstPrepend=iterate ( iterate prepend=and property=oredCriteria[].criteriaWithoutValue

Re: Blocking one -help needed on dynamic changing of conjuction property

2008-12-02 Thread Jeff Butler
iBATIS does not support changing the XML attributes at runtime. It looks like you've started with the abator generated where clause. You can probably accomplish what you want to do with a little boolean algebra and changing the values of the parameter object. Jeff Butler On Tue, Dec 2, 2008

RE: Blocking one -help needed on dynamic changing of conjuction property

2008-12-02 Thread yuvraj.shinde
Thanks a lot... But if I want to construct the query such as ( Table.columname1=ABC or Table.columnam1=EFG ) and (Table.columname2=123 or Table.columname2=456 ) How I should construct this querry. And also queries become more complex as no of columns goes on increasing.

Re: Problem with date format.

2008-12-02 Thread Tokajac
Hello! I'm mapping columns of types DATE(10), TIME(8): parameterMap parameter property=ORGDEPDT jdbcType=DATE javaType=java.sql.Date mode=OUT/ parameter property=ORGDEPTM jdbcType=TIME javaType=java.sql.Time mode=OUT/ /parameterMap and i get Exception: javax.servlet.ServletException: *

Re: Best practice for using Ibatis in Web application

2008-12-02 Thread Kai Grabfelder
for me combining Spring with iBATIS is pretty much my standard way for using iBATIS in web applications. The webframework differs (may it be Wicket, Stripes or Struts) but iBATIS and Spring dependency injection always stays the same ;-). See the jpetstore (an example contained in the Spring

Re: Best practice for using Ibatis in Web application

2008-12-02 Thread Rinaldo
I agree with Kai, for me Spring and Ibatis are the better way to use Ibatis in a web Application. Regards -- Rinaldo Bonazzo Il giorno mar, 02/12/2008 alle 22.24 +0100, Kai Grabfelder ha scritto: for me combining Spring with iBATIS is pretty much my standard way for using iBATIS in web

Abator Code Generation for Whole Schema

2008-12-02 Thread Petr V.
Hi, I just downloaded Abator tool and was able to generate code . But I have 100+ tables and project is in development stage so it would be really hard to maintain the abatorConfig.xml file. I can only specify one table at a time. Would it mean I do need to create one config file for each table,

Re: Abator Code Generation for Whole Schema

2008-12-02 Thread Jeff Butler
Yes - you are definitely missing something. There can be unlimited table elements. You can also specify SQL wildcards to generate code for all tables in a schema like this: table schema=MySchema tableName=%/ Jeff Butler On Tue, Dec 2, 2008 at 7:50 PM, Petr V. [EMAIL PROTECTED] wrote: Hi,

Re: Best practice for using Ibatis in Web application

2008-12-02 Thread Zoran Avtarovski
+1 Spring and ibatis make life much simpler when used together. Z. I agree with Kai, for me Spring and Ibatis are the better way to use Ibatis in a web Application. Regards

Re: AS400 Column Mapping Resultset DATE TIME

2008-12-02 Thread Gregor Cremosnik
Hi Imre, the probem meigth be come from the table or DB definition on AS400. So you have to tell the AS400 JDBC Driver to use the correct date parameters. URL = jdbc:as400:ipAddress;date format=iso;time format=iso; You will find more informations here:;