nested iterate over 2 different properties

Hello, I am using ibatis 2.1.7, and I have the following sql statement:         SELECT                           TABLA.$agrupaciones[]$             FROM $tabla[]$ TABLA     WHERE         TABLA.A IN ('A','B','C','D','W','G')     where:     $tabla[]$ = { "PENDIENTES", "ANULADAS" }    

Problem with complex properties mapping

Hi, I am new to DataMapper and it might be that my problem is rather easy to spot so please bear with me if the problem is trivial but I was not able to solve it for a few days now and I would be glad for any help. I am running queries against an AS/400 using com.ibm.as400.access.AS400JDBCDriver

AW: Problem with complex properties mapping

Hi Torsten, i thnk you're missing a parameterMap or parameterClass attribute in getColorForArticle statement. gruss michal -Ursprüngliche Nachricht- Von: Torsten Michelmann [mailto:[EMAIL PROTECTED] Gesendet: Montag, 8. Mai 2006 11:55 An: user-java@ibatis.apache.org Betreff: Problem wi

Re: Problem with complex properties mapping

Hallo Torsten, you could substitute " Greetings, OlafOn 5/8/06, Michal Bartmanski <[EMAIL PROTECTED]> wrote: Hi Torsten,i thnk you're missing a parameterMap or parameterClass attribute in getColorForArticle statement.grussmichal-Ursprüngliche Nachricht-Von: Torsten Michelmann [mailto: [E

Re: nested iterate over 2 different properties

Hello Guido, shouldn't it be #agrupaciones[]# instead of $agrupaciones[]# ? Greetings, OlafOn 5/8/06, Guido García Bernardo <[EMAIL PROTECTED]> wrote: Hello, I am using ibatis 2.1.7, and I have the following sql statement:         SELECT                           TABLA.$agrupacion

RE: nested iterate over 2 different properties

No, the use of $’s is required because it is begin used to specify columns and tables in the SELECT-clause. #’s would pass the columns as a parameter for the prepared statements, this would cause an SQLException.   This is definitely related to the iterate-tag, I believe some rework is do

Re: Problem with complex properties mapping

Hi Olaf, thanks for your reply. Unfortunately the error message is still the same. Greetings Torsten > --- Ursprüngliche Nachricht --- > Von: "Olaf Bey" <[EMAIL PROTECTED]> > An: user-java@ibatis.apache.org > Betreff: Re: Problem with complex properties mapping > Datum: Mon, 8 May 2006 15:37:49

Re: AW: Problem with complex properties mapping

Hi Michael, I tried to implement your suggestion and it seems that I am now on the next level of the problem. Hi I followed your suggestion as follows: now I get com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in so/global/persistence

RE: nested iterate over 2 different properties

Hi!   If you want a workaround for your problem and you need it now, can recompile the code from source. The source code for iBatis 2.1.7 is included in the zip file you downloaded from iBatis web site. You will need to modify the files in iBatis by downloading the files in issue IBATIS-281.

RE: AW: Problem with complex properties mapping

I had those kinds of problem when I didn't have a normal getter and setter for a property in my class. Check the getters and setters called by your CPL.readArticles_Result and getColor_Result maps and check if the setter are like this one. public void setProperty(Object o) { this.property =

Re: nested iterate over 2 different properties

I don't think the iterate tag has any notion of restarting the iteration.  So I think this is another example of the brokenness of the dynamic tags.  I am looking at this, but it is quite complex and there are many issues.  So there's not a quick fix.   Right now I'm collecting test cases of broke

Re: nested iterate over 2 different properties

I agree - I think Christian's patches will solve this particular problem.   Jeff Butler  On 5/8/06, Poitras Christian <[EMAIL PROTECTED]> wrote: Hi!   If you want a workaround for your problem and you need it now, can recompile the code from source. The source code for iBatis 2.1.7 is included i

Complex properties and stored procedures...

Hi everyone, I have a nested query...(Client having multiple addresses) but which uses stored procedures, problem is that the two parameters that are retrieved form the first query (client_id and current_address_id) are not being passed to the parameterMap on the getAddresses query(they are both

some ways for storing the states, transitions and any hierarchical structure

I have to decide for my project if it is worth it to store some of my objects directly in mysql using iBATIS.The usecase is just a web application accepting HTTP GET/POST requests and depending on given states it executes some code and move the client to a new state (I am using commons-scxml [1] fo

Next steps on REFCURSOR support?

Title: Next steps on REFCURSOR support? Can one of the committers comment on whether / when / how REFCURSOR support will appear in iBATIS?  Details at e.g. http://opensource.atlassian.com/confluence/oss/display/IBATIS/Oracle+REF+CURSOR+Solutions Background: my team maintains Java dev tools

Re: Next steps on REFCURSOR support?

Ross, Jonathan C. wrote: Can one of the committers comment on whether / when / how REFCURSOR support will appear in iBATIS? Details at e.g. _http://opensource.atlassian.com/confluence/oss/display/IBATIS/Oracle+REF+CURSOR+Solutions_ Background: my team maintains Java dev tools at Fidelity In

Re: some ways for storing the states, transitions and any hierarchical structure

I think maybe you're a little confused about the function if iBATIS.  iBATIS does not directly store objects in database tables, rather it is used to map attributes of classes to relational columns.  So typically there is a table for each class and the columns in the table match the attributes of t

Re: some ways for storing the states, transitions and any hierarchical structure

Oh that sounds good I will need to take a closer look at iBATIS then.Thanks a lot!On 5/8/06, Jeff Butler < [EMAIL PROTECTED]> wrote:I think maybe you're a little confused about the function if iBATIS.  iBATIS does not directly store objects in database tables, rather it is used to map attributes of

Re: Next steps on REFCURSOR support?

If you're all comfortable with the solution as it is in the Wiki, I may be able to implement it.I have a list of things after TSSJS that I just haven't had a chance to look at yet, and this is one of them.  Most of these are things that I depend upon external testing for.  But if two of you are tel

Need help in mapping of one object to Two tables

  Hi,   I need to map one Person object to Two tables. Is it possible in Ibatis? Here i am giving the complete info.   I have one Person Object with both static properties and dynamic properties. The static properties are  - id, name,  the dynamic properties are propertyname, property val

I am new to iBatis. Is it possible to insert into multiple tables using one parameter class using iBatis

I have two classes : One is Product and other is Service. One product can have multiple services.   Product details are stored in product table. Service details in service details. Service table has foreign key referencing prioduct_id which is primary key in product table.   While d

Re: I am new to iBatis. Is it possible to insert into multiple tables using one parameter class using iBatis

public class Product {    private String name;    private Integer id;    public String getName() {    return name;    }    public void setName(String name) {    this.name = name;    }    public Integer getId() {    return id;    }    public void setId(Integer id) {    this.id = id;

Re: I am new to iBatis. Is it possible to insert into multiple tables using one parameter class using iBatis

While some of the drivers might support multiple statements I would suggest against it.I would write this into the DAO level of your code.something likepublic void insertProduct(Product p) {  startTransaction();  executeInstert("insertProduct", p);  for(Service s:p.getServices()) {    executeIn

Re: I am new to iBatis. Is it possible to insert into multiple tables using one parameter class using iBatis

hahah disregard that, didn't really answer the question. Just like I said, I just woke up. On 5/8/06, Jerome Gagner < [EMAIL PROTECTED]> wrote:public class Product {     private String name;    private Integer id;    public String getName() {    return name;    }    public void setName(String n