RE: ResultSet problem

Try to specify JDBC connection property as 'date format=iso'. 
You can do it as part of connection url as 'jdbc:as400://youras400name;date 
format=iso'
This should solve the problem

Alex

-----Original Message-----
From: Bartell, Aaron L. (TC) [mailto:ALBartell@xxxxxxxxxxxxxx]
Sent: Wednesday, July 09, 2003 10:20 AM
To: 'Java Programming on and around the iSeries / AS400'
Subject: RE: ResultSet problem


That makes sense, but why wouldn't it still give me all 15 records when all
the other fields in those records contain valid data?  Can just one null
field cause the whole process to act weird/puke?  By act weird/puke I mean
that I am not getting any exception errors.

Aaron

-----Original Message-----
From: Buck [mailto:buck.calabro@xxxxxxxxxxxx]
Sent: Wednesday, July 09, 2003 9:38 AM
To: java400-l@xxxxxxxxxxxx
Subject: Re: ResultSet problem


> 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?

I am guessing that the records with the default date are also null.
Remembering always that NULL and the value of the field are not the same
thing, is it possible that the JDBC side is taking NULL into account but the
green side is not?
  --buck



_______________________________________________
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.
_______________________________________________
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.