Re: Corrupt date value in Resultset

[Colin Williams <colinwilliams007@xxxxxxxxx>]

I have had a similar problem in the past, and that fixed it.

Colin.W


On 29/11/05, Jessica King <jking@xxxxxxxxxxxxxx> wrote:
>
> I had a similar issue recently. The fix that IBM suggested (and that
> worked)
> was to append the "date format" parameter to the connection string.
>
> For example:
> jdbc:as400://{db}/{db};prompt=false;translate binary=true;date format=iso;
>
>
> Hope this helps!
>
> -Jessica
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx [mailto:
> java400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Lára Björk Erlingsdóttir
> Sent: Tuesday, November 29, 2005 10:52 AM
> To: java400-l@xxxxxxxxxxxx
> Subject: Corrupt date value in Resultset
>
> I have a problem with date value from a Resultset which is returned from
> an
> SQL procedure, the date value is corrupt and all the fields and records
> after the first date value also contain corrupt data.
>
>
>
> I run a JDBC Sql statement from Java calling an sql procedure, using
> com.ibm.as400.access.AS400JDBCDriver driver.  The table on my iSeries
> contains 4 fields:  2 integer field, a date field and a sting field.  The
> value of the date fields in the table is 2005-11-28.  If I call the same
> sql
> procedure from the iSeries Navigator, the resultSet returns correct data
> and
> if I execute the same query, as the sql procedure contains, from a Java
> code
> (not using the sql procedure) the result is correct.
>
>
>
> Does anyone have an idea what is the solution for this problem?
>
>
>
> Thanks in advance,
>
> Lara
>
>
>
> **************************************************************************************************
> The contents of this email and any attachments are confidential.
> They are intended for the named recipient(s) only.
> If you have received this email in error please notify the system manager
> or  the
> sender immediately and do not disclose the contents to anyone or make
> copies.
>
> ** eSafe scanned this email for viruses, vandals and malicious content. **
>
> **************************************************************************************************
>
>
> --
> 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.
>
>