Re: Ordering guaranteed in queryForList results?

2005-03-25 Thread Clinton Begin
Yes, the order is preserved. Clinton On Fri, 25 Mar 2005 13:56:02 -0800 (PST), Karen Koch <[EMAIL PROTECTED]> wrote: > I'm curious as to whether I can count on the immediate results of a call to > queryForList always preserving the order specified in the ORDER BY clause of a > SQL statement... ?

Ordering guaranteed in queryForList results?

2005-03-25 Thread Karen Koch
I'm curious as to whether I can count on the immediate results of a call to queryForList always preserving the order specified in the ORDER BY clause of a SQL statement... ? Thanks in advance. :-) Karen

Stored Procedure question

2005-03-25 Thread Archana Pachraiya
HI,       I have one stored procedure which returns a list of object+output parameters( such as return code, return message, etc). Is it possible to get the output parameters which can retrieved in Java application using registereOutputParameter. I am able to get the list of object using queryForL

Re: Passing parameters to sub selects

2005-03-25 Thread Scott Zhu
Hi, Phil, Can I ask you what was your work around for this problem? I have a situation that the table name in the sub query needs to be dynamically set.

Re: Integer to Boolean conversion is opposite from expected behavior

2005-03-25 Thread Mike Zatko
Yea, you're right. I goofed. I even was wrong about how it is in C... it is actually 1=true and everything else is false. I must be losing it. Brandon Goodin wrote: Generally when representing a boolean as a CHAR in the database 0=false and 1 and greater = true. But, with my stuff it's more like

Re: Struggling with insertion of Clob into the database. PS:

2005-03-25 Thread Brandon Goodin
We are already using JIRA for issue tracking. Dev list traffic is minimal. Brandon On Fri, 25 Mar 2005 10:39:20 -0500, John Fereira <[EMAIL PROTECTED]> wrote: > At 08:10 AM 3/25/2005 -0700, Clinton Begin wrote: > >Yes. Absolutely. > > > >I've never been a fan of MoinMoin. It's crap. > > > >C

Re: Integer to Boolean conversion is opposite from expected behavior

2005-03-25 Thread Brandon Goodin
Generally when representing a boolean as a CHAR in the database 0=false and 1 and greater = true. But, with my stuff it's more like 1 = true and everything else is false. But, i usually stick to looking for '0' or '1' in my code for explicit and then assuming false if it is anything other. Also ano

Re: Struggling with insertion of Clob into the database. PS:

2005-03-25 Thread John Fereira
At 08:10 AM 3/25/2005 -0700, Clinton Begin wrote: Yes. Absolutely. I've never been a fan of MoinMoin. It's crap. Confluence is big, slow and overcomplicated. But at least it works. :-) Yes, Confluence (and especially when you add Jira) is big. I also found it to be slow when I first deploye

Re: Integer to Boolean conversion is opposite from expected behavior

2005-03-25 Thread Karen Koch
Having 0 = true seems to me to be the opposite of what I would ever expect... --- Mike Zatko <[EMAIL PROTECTED]> wrote: > I have a db table that has a field that has a SMALLINT datatype. This > field is being used as a true/false flag. 0 would be true, anything else > would be false as would typ

Re: Integer to Boolean conversion is opposite from expected behavior

2005-03-25 Thread Clinton Begin
You should use a custom type handler for conversion from text to boolean. We'll be including a standard one in a future release. Clinton On Fri, 25 Mar 2005 10:20:46 -0500, Mike Zatko <[EMAIL PROTECTED]> wrote: > I have a db table that has a field that has a SMALLINT datatype. This > field is b

Integer to Boolean conversion is opposite from expected behavior

2005-03-25 Thread Mike Zatko
I have a db table that has a field that has a SMALLINT datatype. This field is being used as a true/false flag. 0 would be true, anything else would be false as would typically happen in C. I set up a result map that looks like the following: I was thrilled that it worked, but

Re: Struggling with insertion of Clob into the database. PS:

2005-03-25 Thread Clinton Begin
PS: We've applied for a confluence OSS license. Clinton On Fri, 25 Mar 2005 08:10:02 -0700, Clinton Begin <[EMAIL PROTECTED]> wrote: > Yes. Absolutely. > > I've never been a fan of MoinMoin. It's crap. > > Confluence is big, slow and overcomplicated. But at least it works. :-) > > Anyo

Re: Struggling with insertion of Clob into the database. PS:

2005-03-25 Thread Clinton Begin
Yes. Absolutely. I've never been a fan of MoinMoin. It's crap. Confluence is big, slow and overcomplicated. But at least it works. :-) Anyone else have experience with good Wiki solutions? (This thread should probably be moved to the ibatis-dev list). Cheers, Clinton On Fri, 25 Mar 2005

Re: Struggling with insertion of Clob into the database. PS:

2005-03-25 Thread Brandon Goodin
We are currently discussing that with the apache infrastructure group. In the past they have been reluctant to use it because it consumes significant resources. There has been a recent change in the hardware being used. So, maybe we will get a chance to use confluence. Brandon On Fri, 25 Mar 200

Re: Struggling with insertion of Clob into the database. PS:

2005-03-25 Thread John Fereira
At 12:39 PM 3/24/2005 -0700, Nathan Maves wrote: Well I have started on a simple example for the wiki. http://wiki.apache.org/ibatis/ How_do_I_use_a_Custom_Type_Handler_with_a_BLOB_or_CLOB We have been experiencing some problems with the wiki but this faq seem to be working. This is the second ti

Re: Struggling with insertion of Clob into the database. PS:

2005-03-25 Thread Nathan Maves
Well I have started on a simple example for the wiki. http://wiki.apache.org/ibatis/ How_do_I_use_a_Custom_Type_Handler_with_a_BLOB_or_CLOB We have been experiencing some problems with the wiki but this faq seem to be working. More to come on this faq when I get some free time. Nathan On Mar 2