Re: Log 4j prob

2006-03-08 Thread Eric Blue
Gregory, I've seen this problem happen when the log4j.properties file is no longer on the classpath (in the case of it being accidentally excluded from my .war file during an ant build).  Also, I seem to recall some classpath order problem with Eclipse where this had happened.  I basically had to

Re: Problem with Insert

2006-02-24 Thread Eric Blue
Hi Davis, Do you have autocommit enabled by default?  Trying Googleing 'db2 "not valid for operation"'.  I noticed quite a few references to an error message like this due to journaling/commit/rollback problems.On 2/24/06, Davis Chapman <[EMAIL PROTECTED] > wrote:I'm running into a perplexing prob

Re: Distributed DataSources and SQL Maps

2006-02-23 Thread Eric Blue
Hi Chris, I'm assuming that you're using the iBatis DAO framework.  If so, then you should probably have 2 SQL Map configuration files (each with their respective statements and database property configuration).  One file contains the Customer resultMap and related statements, and the other contai

Re: Does iBatis have a direct competitor?

2006-02-13 Thread Eric Blue
Troy, I've been using iBatis for well over a year now and have had nothing short of success on about a half dozen projects.  So, I really haven't had any great desire to look elsewhere at this point.  On a few of these projects, the object model was (in my view) somewhat complicated and iBatis wor

Getting object access to resultMap definitions

2006-01-27 Thread Eric Blue
Hi, Does anybody know if it's possible to get information about a given result map without parsing the XML configuration?  What I want to be able to do is get the property to column mapping based on the class name.  I essentially want to do validation and transformation of a pseudo-query language

Re: Multiple deletes? [signed]

2005-12-08 Thread Eric Blue
I do something similar for selects using iteration.  In this case I use a HashMap for my parameter class: ... select * from table where name in   #nameList[]# ... On 12/8/05, Vijai Senthil Padmanabhan Kalaiyarasi <[EMAIL PROTECTED]> wrote: Mike,try using $ instead of #, asDELETE FROM ALERTS WHER

Re: Join 2 tables with same column name

2005-08-16 Thread Eric Blue
Paul, What error are you getting? Did you try updating your query to reference a.id and b.id by aliases?  This should work. select a.id as id1, b.id as id2, b.company from prod a, prod_loc b where a.id = b.companyOn 8/16/05, Paul Glezen <[EMAIL PROTECTED]> wrote: Hi Folks, I'm struggling

Re: sql include #

2005-08-11 Thread Eric Blue
Henry, You should be able to escape the column with another #.  See: http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+POUND+or+DOLLAR+symbols+in+my+queries%3F On 8/11/05, Henry Lu <[EMAIL PROTECTED]> wrote: How do I use a SQL statemen including a column name with #:EXamp

Re: Bidirectional associations and circular references

2005-08-09 Thread Eric Blue
the OrderItem objects, then iterate through the OrderItemobjects and set the Order on them to the parent. Not real elegant, buteffective.Just curious: Why do you need this relationship in your objects? LarryOn 8/9/05, Eric Blue <[EMAIL PROTECTED]> wrote:> Hi,>>  I apoligize in advanc

Bidirectional associations and circular references

2005-08-09 Thread Eric Blue
Hi, I apoligize in advance if this problem has been addressed previously on this list.  But, I've come across a (more than likely) common situation where I have 2 Objects: Object 1 has a m:n relationship to Object2 AND Object 2 has a 1:1 relationship to Object1 In other words, Object1.getObject2

Re: DAO Objects - Hiding ?

2005-07-21 Thread Eric Blue
Steve, If I understand your question correctly, it seems that you want the POJO to know how to persist itself.  This certainly is one way to do it, however I would probably advise against it.  If I recall, one of Scott Ambler's books (The Object Primer, 2nd edition) detailed an architecture simila