Re :RE: jdbc driver problem

2007-02-14 Thread Rajesh Thakur
it is saying that jdbc 2.0 methods are not [EMAIL PROTECTED] wroteAre you getting any exceptions or related messages in a logfile?-Original Message-From: Rajesh Thakur [mailto:[EMAIL PROTECTED]: Wed 2/14/2007 11:09 PMTo: [EMAIL PROTECTED]: jdbc driver problemHi I am trying to use Ibatis

RE: jdbc driver problem

2007-02-14 Thread Chris Lamey
Are you getting any exceptions or related messages in a logfile? -Original Message- From: Rajesh Thakur [mailto:[EMAIL PROTECTED] Sent: Wed 2/14/2007 11:09 PM To: user-java@ibatis.apache.org Subject: jdbc driver problem Hi I am trying to use Ibatis with weblogic 8.1. I am not able

jdbc driver problem

2007-02-14 Thread Rajesh Thakur
Hi I am trying to use Ibatis with weblogic 8.1. I am not able to access database with weblogic.jdbc.oci.Driveralthough if i change drive to oracle.jdbc.OracleDriveribatis works fine.can anybody help why this is happening..Thanks...

Re :Re: [JDBC type = ARRAY / Java type = ?] howto : Degenerated case of heterogenous lists.

2007-02-14 Thread Rajesh Thakur
Hi I am trying to use Ibatis with weblogic 8.1. I am not able to access database with weblogic.jdbc.oci.Driveralthough if i change drive to oracle.jdbc.OracleDriveribatis works fine.can anybody help why this is [EMAIL PROTECTED] wroteThanks for the feedbackreal model is something likeCustomer {

Re: how to use ibatis to get data from multiple databases

2007-02-14 Thread Ashish Kulkarni
Hi Is there any source code for using properties when creating sql map client Ashish On 2/13/07, Larry Meadors <[EMAIL PROTECTED]> wrote: Use a properties object when you create the sql map client. Larry On 2/13/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote: > Hi > I have a web application

RE: XA transactions

2007-02-14 Thread Christopher . Mathrusse
I'm currently using Bitronix Transaction Manager (http://www.bitronix.be/)   And there is also Atomikos (http://www.atomikos.com/home.html) From: Mark Volkmann <[EMAIL PROTECTED]> [mailto:Mark Volkmann <[EMAIL PROTECTED]>] Sent: Wednesday, February 14, 2007 3:11 PMTo: user-java@ibatis.apac

Re: XA transactions

2007-02-14 Thread Mark Volkmann
On Feb 14, 2007, at 4:56 PM, [EMAIL PROTECTED] wrote: Yes, so long as you use an external transaction manager. Thanks! Can you give me a few examples of these products that I can google to get more information? From: Mark Volkmann <[EMAIL PROTECTED]> [mailto:Mark Volkmann <[EMAIL PROTECT

RE: XA transactions

2007-02-14 Thread Christopher . Mathrusse
Yes, so long as you use an external transaction manager. From: Mark Volkmann <[EMAIL PROTECTED]> [mailto:Mark Volkmann <[EMAIL PROTECTED]>] Sent: Wednesday, February 14, 2007 2:46 PMTo: user-java@ibatis.apache.orgSubject: XA transactions Can iBATIS work with XA transactions? I surfed the

XA transactions

2007-02-14 Thread Mark Volkmann
Can iBATIS work with XA transactions? I surfed the web and came up empty on this.

Re: problems with mappings

2007-02-14 Thread Nathan Maves
Why are you not specifying the column name or index? On 2/12/07, Jonathan Chase <[EMAIL PROTECTED]> wrote: I kind of figured out the problem and a solution. I had an abstract class (AbstractEntity) that my entity (Foo) extended. A simplified version of the classes looks like: public abstract

Re: how to create

2007-02-14 Thread Nathan Maves
Did not catch that thanks Daniel. Post the custom RH and your full sqlmap. Nathan On 2/14/07, Daniel Pitts <[EMAIL PROTECTED]> wrote: It looks like his problem is that every row adds a , which is incorrect behavior. But, It could also be that his CustomRowHandler is incorrectly implemented.

RE: how to create

2007-02-14 Thread Daniel Pitts
It looks like his problem is that every row adds a , which is incorrect behavior. But, It could also be that his CustomRowHandler is incorrectly implemented. From: Nathan Maves [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 14, 2007 2:20 PM To: user-java@ib

Re: how to create

2007-02-14 Thread Nathan Maves
Why do you want to remove that line. It should not be causing you any issues when parsing the xml file that is generated. Nathan On 2/14/07, disalle <[EMAIL PROTECTED]> wrote: Hi all, I have a simple table (for example PERSON) and I would like to create an xml file containing all table rows,

RE: howto : Degenerated case of heterogenous lists.

2007-02-14 Thread Thibaut Fagart
Yes I believe this is what was suggested in the other replies as well. Didn't think of it at first, but it indeed solves my case. Not sure how it compares to the current request in terms of permance, but it guess it would be fine. Todorovich, Milo wrote: > > You could also create one SQL stat

how to create

2007-02-14 Thread disalle
Hi all, I have a simple table (for example PERSON) and I would like to create an xml file containing all table rows, for example amleto .. .. I have used sqlMapClient.queryWithRowHandler and I have defined a CustomRowHandler but, I have noticed that IBatis for each row add the "" strin

Re: Direct-to-Field mappings now implemented.

2007-02-14 Thread Paul Benedict
Clinton, perhaps you opened the can of worms here :-) But I think the idea is very good and now we're seeing the feedback necessary to refine the enhancement. Upon reflection (pun intended), I believe the configuration option is becoming more and more necessary and so I expand my suggestion to be

Re: [JDBC type = ARRAY / Java type = ?] howto : Degenerated case of heterogenous lists.

2007-02-14 Thread Thibaut Fagart
Here is the sqlMap I'm trying THe idea was to try to create "virtual" classes Address1, Address2 and Address3, and having IBatis only set the relevant atttriute for each row, but it does not seem to work. > > "http://ibatis.apache.org/dtd/sql-map-2.dtd";> > > > >

Re: Direct-to-Field mappings now implemented.

2007-02-14 Thread Brandon Goodin
Yes, this is a repost... but now that the point has come up... To avoid the unpredictability of this functionality couldn't we add some configure options like: * a diretoryToMappintEnabled=true/false property on the SQL Map Config. This would set it globally. False would follow strict bean and (

RE: howto : Degenerated case of heterogenous lists.

2007-02-14 Thread Todorovich, Milo
You could also create one SQL statement like this: select customer.first_name, customer.last_name, address1.address_line1 as address_line1_1, address1.address_line2 as address_line2_1, address1.city as city_1, address2.address_line1 as address_line1_2, address2.addres

RE: Direct-to-Field mappings now implemented.

2007-02-14 Thread Niels Beekman
Clinton, I extracted the property get/set method logic (now in ClassInfo) to a separate property access strategy interface and class and created another implementation that accesses fields directly. However, this starts to look more and more like the classes already in the package com.ibatis.sqlma

Re: [JDBC type = ARRAY / Java type = ?] howto : Degenerated case of heterogenous lists.

2007-02-14 Thread Thibaut Fagart
Thanks for the feedback real model is something like Customer { properAssets : Assets // assets privately owned by the customer joinedAssets : Assets // assets collectively owned by the customer and his/her husband/spouse // and another one which I don't know the real meaning :) } The fact

Re: [JDBC type = ARRAY / Java type = ?] howto : Degenerated case of heterogenous lists.

2007-02-14 Thread Brandon Goodin
Oooh, I see what you are saying now. Jeff is dead nuts on. flatten out the results and map to your different address objects. Brandon On 2/14/07, Thibaut Fagart <[EMAIL PROTECTED]> wrote: Here is the sqlMap I'm trying THe idea was to try to create "virtual" classes Address1, Address2 an

Re: [JDBC type = ARRAY / Java type = ?] howto : Degenerated case of heterogenous lists.

2007-02-14 Thread Jeff Butler
I agree with Brandon - a list of addresses would be better. You've got a properly normalized DB and a de-normalized object model. Usually it's the other way around! However, you can accompish what you want in a single SQL statement. Assuming tables like this: create table customer ( customerI

Re: [JDBC type = ARRAY / Java type = ?] howto : Degenerated case of heterogenous lists.

2007-02-14 Thread Brandon Goodin
How is this solution any different? Indexes versus 1,2,3? It would be the same thing. There must be more that you are not describing. But, if it doesn't satisfy your requirement...okay. Brandon On 2/14/07, Thibaut Fagart <[EMAIL PROTECTED]> wrote: Thanks for the tip but I'm not happy with thi

Re: [JDBC type = ARRAY / Java type = ?] howto : Degenerated case of heterogenous lists.

2007-02-14 Thread Thibaut Fagart
Thanks for the tip but I'm not happy with this solutions, because in my case the 3 addresses have different meanings (just as you would have a main address and secondary ones). I'm trying to create a use case for what I'm trying to do, will post it later today or tomorrow Brandon Goodin wrote:

Re: howto : Degenerated case of heterogenous lists.

2007-02-14 Thread Brandon Goodin
It could be solved if you combined address1,2,3 into a list and used the groupby functionality. Customer { firstName : string lastName : string addresses : List } If you want to return the address through address1, 2, 3 getters you could always add the getters and have them

howto : Degenerated case of heterogenous lists.

2007-02-14 Thread Thibaut Fagart
Hi, I'm currently evaluating IBatis for the corporation I work with, and trying to use it to solve a case we have. We have a model like this Customer { firstName : string lastName : string address1 : Address address2 : Address address3 : Address } where Ad

Re: Direct-to-Field mappings now implemented.

2007-02-14 Thread Clinton Begin
Yes, we decided against a special syntax for fields. How did you do implement yours? Cheers, Clinton On 2/14/07, Niels Beekman <[EMAIL PROTECTED]> wrote: Hi Clinton, I have been using something like this (custom written) for over a year, and was happy to see it implemented in iBATIS, just whe

RE: Direct-to-Field mappings now implemented.

2007-02-14 Thread Niels Beekman
Hi Clinton, I have been using something like this (custom written) for over a year, and was happy to see it implemented in iBATIS, just when I was about to try the new syntax I saw your commit log: "Changed syntax of field mappings to be exactly the same as property mappings. It now decides to us