Re: Boolean to DB2?

[Franco Biaggi <fbiaggi@xxxxxxxxxx>]

Hi,
this seem to be the JTOpen implementation:

public boolean getBoolean()
    throws SQLException
    {
        truncated_ = 0;

        // If value equals "true", "false", "1", or "0", then return the
        // corresponding boolean, otherwise an empty string is
        // false, a non-empty string is true.
        String trimmedValue = getString().trim();       
        return((trimmedValue.length() > 0)
               && (! trimmedValue.equalsIgnoreCase("false"))
               && (! trimmedValue.equals("0")));
    }



albartell wrote:

>The 1A field is the route I go and then I place 'T' or 'F' in there to
>denote the boolean feel.  I use Hibernate as my ORM layer and in the data
>access object I create a getter and setter that uses the Java boolean data
>type but underneath the covers it converts it to a T or F before writing it
>to the database.
>
>HTH,
>Aaron Bartell
>
>
>-----Original Message-----
>From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx]
>On Behalf Of RPower@xxxxxxxxxx
>Sent: Friday, October 21, 2005 8:10 AM
>To: Java Programming on and around the iSeries / AS400
>Subject: Boolean to DB2?
>
>Hello all again.
>I have a DB2 Physical file that I need to assign Boolean variables.  Can I
>create a 1A field in the physical file to contain the value of the Boolean
>variable in my object in Java?  If so, what will the value of the 1A field
>be if true or false?
>
>Ron Power
>Programmer
>Information Services
>City Of St. John's, NL
>P.O. Box 908
>St. John's, NL
>A1C 5M2
>709-576-8132
>rpower@xxxxxxxxxx
>http://www.stjohns.ca/
>___________________________________________________________________________
>Success is going from failure to failure without a loss of enthusiasm. - Sir
>Winston Churchill
>--
>This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
>mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe,
>unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/java400-l
>or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
>moment to review the archives at http://archive.midrange.com/java400-l.
>
>  
>