Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[SQL0181] Value in date, time, or timestamp string not valid. on AS/400

843859Feb 5 2008 — edited Nov 20 2014
hi

i having trouble with my resultset after an query is made.


that when i try to process my data in the resultset i am able to

resultset.next() up to 108
but after that i recieve an

[SQL0181] Value in date, time, or timestamp string not valid.
error

rsmd = rset.getMetaData();
numberOfColumns = rsmd.getColumnCount();

while (rset.next()) {
++i; System.out.println("record count: " + i);
if(wrkset.equals("AS400ict")){

System.out.println("AS400ict");

AS400dbFields asobj = new AS400dbFields();
asobj.addICTItems(rset);
System.out.println(asobj.getICTItems());
String str = Integer.toString(i);
rsetqmap.put(str, asobj);



}


please help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2008
Added on Feb 5 2008
1 comment
1,103 views