Re: SVN Trunk build error ?

2009-06-16 Thread DelGurth
Perhaps that is because you build for java 6 and not java 5? http://java.sun.com/javase/6/docs/api/java/sql/ResultSet.html#updateNClob(int,%20java.sql.NClob) Also see (probably among others): http://www.mail-archive.com/d...@ibatis.apache.org/msg03146.html DelGurth On Tue, Jun 16, 2009 at 10

Re: Help required

2009-06-12 Thread DelGurth
Btw, I think the problem is in the #date:VARCHAR# part. Why don't you put the date in as :DATE or :TIMESTAMP ? Did you try to put com.ibatis and java.sql log to debug, so you see the exact parameter going into the #date# parameter? DelGurth On Fri, Jun 12, 2009 at 4:44 PM, DelGurth

Re: Help required

2009-06-12 Thread DelGurth
To me that COUNT seems like an alias for the result of COUNT(CD) as in SELECT COUNT(CD) AS COUNT But, what is the error? DelGurth On Fri, Jun 12, 2009 at 3:35 PM, Brandon Goodin wrote: > I didn't look over it thoroughly but i noticed you appear to have a > misplaced "COUN

Re: ibator ant task help

2009-05-25 Thread DelGurth
On Mon, May 25, 2009 at 3:33 PM, Brad Balmer wrote: > I am trying to switch from using the eclipse plugin to using the ant task to > generate my files.  It seems that no matter what I do, ibator replaces my > existing .java and .xml files instead of only merging the new changes. > > Is this a side

Re: Mapping of a Set with enums

2009-05-18 Thread DelGurth
On Mon, May 18, 2009 at 7:40 PM, Mikael Andersson wrote: > Hi > > I'm having problems mapping to a property which is a Set of java5 enums. > > I have a class CounterpartyHedgeVO which has the property creditEvents which > is a Set. > > Not sure what the problem is but I'm guessing that iBATIS trie

Re: Using #PARAM# constructions within $DYNAMICSQL$

2009-05-05 Thread DelGurth
On Wed, Apr 29, 2009 at 12:24 AM, DelGurth wrote: > Hi, > > I was wondering if it was possible to use #PARAM# constructions within > a $DYNAMICSQL$ query.I'm currently using iBatis sqlmap 2.3.0. And I'm > trying to get the following to work: > > SELECT * FROM

Re: Using #PARAM# constructions within $DYNAMICSQL$

2009-04-29 Thread DelGurth
On Wed, Apr 29, 2009 at 4:58 PM, Jason King wrote: > Is there some reason you can't use the dynamic where clause feature in > iBatis. > > This is an example stolen directly from Clinton's book. > > > resultClass="Category"> > > SELECT * > > FROM category > > > > > > parentCategoryId IS NULL > >

Re: Oracle v$session and iBatis

2009-04-29 Thread DelGurth
I'm just wondering, how exactly are are monitoring the connections using v$session? Since 27/28 sessions already seems to be way more then what you configured: Do you filter for the user that you configured and checking the active/inactive status of the session? Wessel On Wed, Apr 29, 2009 at 1

Re: Using #PARAM# constructions within $DYNAMICSQL$

2009-04-29 Thread DelGurth
On Wed, Apr 29, 2009 at 2:44 PM, Chris O'Connell wrote: > I sympathize with your problem.  Perhaps you could just build a set of sql > includes, each of which is the correct sql for a particular use case.  Then, > rather than building the sql string in your code, you instead just pass a > paramete

Re: Using #PARAM# constructions within $DYNAMICSQL$

2009-04-29 Thread DelGurth
On Wed, Apr 29, 2009 at 5:30 AM, Nathan Maves wrote: > I have not tried this but I don't see why it would not work. > > > SELECT * FROM person >  WHERE person.lastname LIKE '%'||#lastname#||'%' > > the || is the concat operator for oracle.  it might be something else in > another vendor Probably

Using #PARAM# constructions within $DYNAMICSQL$

2009-04-28 Thread DelGurth
Hi, I was wondering if it was possible to use #PARAM# constructions within a $DYNAMICSQL$ query.I'm currently using iBatis sqlmap 2.3.0. And I'm trying to get the following to work: SELECT * FROM person $DYNAMICSQL$ With $DYNAMICSQL$ defined as: WHERE person.lastname LIKE '%#LASTNAME#%' So the