CODEWITHSUNDEEP
databasejdbcibm-midrange
idiotgenius
idiotgenius

Reputation: 499

AS400 Database access via jdbc

I am trying do a query on a table via jdbc in my java program.

I know there are three rows in that table.

I've got the resultset, and can read and process data of the first row. but when I try to move the resultset to next row, an exception is thorwn.

the exception pointed [SQL0181]

Upvotes: 0

Views: 1671

Answers (2)

user5437585
user5437585

Reputation: 1

I know this is an old question, but it's a top search result for SQL0181, and the answers is wrong.

The problem is the date being retrieved can't be represented in the date format being used. The IBM i allows several non-ISO date formats, which can't handle things like the beginning & ending of time. The error stems from trying to use one of them.

You can either have your user profile changed or use ISO on your JDBC settings. "jdbc:as400://RCHASSLH;date format=iso;time format=iso;"

ref: http://www-01.ibm.com/support/docview.wss?uid=nas8N1017268

Upvotes: 0

James Allman
James Allman

Reputation: 41168

You can use the SQL Message Finder to look up message codes.

The SQL0181 message text is:

Value in date, time, or timestamp string not valid.

This indicates you have a value in a row that can not be represented as an SQL Datetime value.

It is not uncommon for legacy HLL programs to introduce these sorts of errors as they are capable of writing directly to the table row without the same validation enforced by the SQL interface.

See also this previously asked SO question: Why am I getting a “[SQL0802] Data conversion of data mapping error” exception?

Upvotes: 3

Related Questions