Re: ResultSet problem

[Dieter.Bender@xxxxxxxxxxx (Dieter Bender)]

Hi,

might be a problem with the date format and diffrent ranges. You cam specify 
*ISO with the driver properties.

Dieter

On Wednesday 09 July 2003 16:10, you wrote:
> I have a table on my iSeries that has date fields with a value of
> 0001-01-01 (default value) in some of the records.  When I run a JDBC SQL
> statement against this I don't get the same amount of records when I do the
> SQL from a green screen.  I get 2 records in the resultset from the Java
> program and 15 (the correct amount) when I do it from the green screen. 
> When I change the date fields to have a more current date like 2003-07-07
> it works just fine from the Java program.
>
> Anybody clue me in as to what is happening?
>
> Aaron Bartell
> _______________________________________________
> 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.

-- 
mfG

Dieter Bender


DV-Beratung Dieter Bender
Wetzlarerstr. 25
35435 Wettenberg
Tel. +49 641 9805855
Fax +49 641 9805856
www.bender-dv.de