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!

resultset Date format

843854May 11 2004 — edited May 13 2004
I'm trying to get a Date field from an Informix Database. DBDATE is set DMY2.

I have tried something like this:

Properties pr = new Properties();
pr.put("DBDATE","DMY2");
conn = DriverManager.getConnection(Url, pr);
.
.
.
java.sql.Date d = r.getDate(2);

However I get an error:
System or internal error java.sql.SQLException: Not enough tokens are specified in the string representation of a date value. "N"

When I have used the date field and same code with the tables mirrored on Access I can get the Date fields with no problems at all.

David

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 10 2004
Added on May 11 2004
5 comments
703 views