iBATIS no longer allows me to set java.sql.Timestamp property

2008-02-08 Thread MrNobody
I had suffered a hard drive meltdown a couple of weeks ago and had to restore a project I am working on which involves loading objects from an Oracle database using iBATIS. Now I finally got the database and the application back up and running (the database I was using to develop on was also a lo

How do you suggest working with enums?

2007-12-05 Thread MrNobody
If I have an enum to represent a lookup table, like: public enum Color { RED (1, "Red"), GREEN (2, "Green"), BLUE (3, "Blue"); } What is the best practice for both writing this enums into the database and instantiating enums for the values read from the databse, using iBATIS ? Somewhere,

Re: Can't get this selectKey element working

2007-11-20 Thread MrNobody
ss. > > If that helps, do I get a free Mt. Dew? > > If that doesn't help, can you post the bean class (if you aren't using > a Map), the mapped statement, and the java code used to call it? > > Larry > > > On Nov 20, 2007 1:50 PM, MrNobody <[EMAIL PR

Can't get this selectKey element working

2007-11-20 Thread MrNobody
I am trying to use selectKey to generate my ID from an Oracle sequence but I can't figure out the correct usage. Searching on the Internet yields many tutorials and when I try doing them EXACTLY as they instruct I get errors- probably due to version differences. Here's what I'm trying to do:

Inserting / not exist problem with date compare

2007-11-19 Thread MrNobody
I'm trying to do something where I insert rows only if certain parts of the data does not already exist. So I put a where not exists clause in my insert statement and it will work fine when I am comparing strings and/or numbers however when I introduce Timestamps it begans to act funny. So basica