Re: java.util.UUID to postgres uuid column

2010-02-11 Thread Vikram Subbarao
Does not work - com.ibatis.common.beans.ProbeException: There is no READABLE property named 'value' in class 'java.util.UUID' Niels Beekman wrote: Try #value#, this will use your parameter object directly. Using #id# tries to obtain the id property from it.

ibator best strategy with multiple table formats

2010-02-11 Thread A Bosetti
Hi all I am new to Ibatis and fairly new with java too so please bear it with me. I have Eclipse 3.4, Java 1.6.17, Ibatis 2.3.4 and Ibator, all wired up with Spring 2.5.6. I have an application that has an internal database and that also needs to connect to an external database. The external

RE: java.util.UUID to postgres uuid column

2010-02-11 Thread meindert
Hi Vikram, I don't use the UUID myself and can't answer your question from experience, but I think the real question would be how the ID is stored in the DB. IBATIS error message is is correct to say that the UUID object does not have a value (like a string or int object) and there is no UUID.

Re: iBatis 3.0 minimal complete example

2010-02-11 Thread Simone Tripodi
Great, I'll use your sample as the foundation of the JPetStore "iBaGuice version" Thanks a lot, very appreciated, Simo http://people.apache.org/~simonetripodi/ On Thu, Feb 11, 2010 at 2:21 AM, Clinton Begin wrote: > Anyone and everyone is welcome (and encouraged) to create a JPetStore > implem

Re: iBatis 3.0 minimal complete example

2010-02-11 Thread Guy Rouillier
On 2/10/2010 11:40 PM, Rick R wrote: certainly not very.) Feel free to let me know off-list how DI has 'really' helped - not some mythical Spinal Tap "Well this one goes to 11" argument. DI has made code simpler in the EJB3 world. With EJB2, to obtain a JNDI datasource, you had to do lookups

Re: ibator best strategy with multiple table formats

2010-02-11 Thread Guy Rouillier
On 2/11/2010 4:58 AM, A Bosetti wrote: The external database is provided by the customers and is made up of several tables (about 20) and it comes in two different formats (both formats are on Oracle), one that uses timestamps and the other one that uses a string representation of datetime. (Orac

Re: ibator best strategy with multiple table formats

2010-02-11 Thread Alessandro
Brilliant...thanks a million Alex Guy Rouillier wrote: On 2/11/2010 4:58 AM, A Bosetti wrote: The external database is provided by the customers and is made up of several tables (about 20) and it comes in two different formats (both formats are on Oracle), one that uses timestamps and the other

what to put in nullValue when date value is null

2010-02-11 Thread Bhaarat Sharma
I have following in my result mapping: setUpdateDate is accepting parameter of type Date update_date column can sometimes be null. In this case I want the date to be 01/01/1900. It is giving me an error: java.lang.RuntimeException: Error setting property 'setUpdateDate' What is the way to put

RE: what to put in nullValue when date value is null

2010-02-11 Thread Niels Beekman
Use a type handler. Better even, do not use nullValue at all and handle this case in your domain logic. 1900 sounds like a magic value to me. Niels From: Bhaarat Sharma [mailto:bhaara...@gmail.com] Sent: Thursday, February 11, 2010 9:24 PM To: user-java@ibati

now with ibatis3 - which sybase driver? - because of this issue

2010-02-11 Thread Rick R
Using the standard jconn3 sybase driver (the jtds driver is fine), I'm getting this error when attempting to get a List the following way without only adding default stuff (username, etc) SqlSession session = SqlSessions.metaDbSessionFactory.openSession(); SampleMapper mapper = ses

Re: java.util.UUID to postgres uuid column

2010-02-11 Thread Vikram Subbarao
The uuid in database is stored in a column of type uuid supported by postgres db. Now when i use the query below, i am passing a string and would become VARCHAR to database which results in postgres db complaining that it cannot compare 'Character Varying' and 'uuid' values. I understand implic