[DERBY-877] zOS - with DerbyClient getDate(#) fails with IllegalArgumentException - unsupported date format - resultset.java

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.1.1.0
• Fix Version/s: 10.1.3.1, 10.2.1.6
• Component/s: Network Client
• Environment: OS/390 with classic (IBM) jvm142
• Assignee: Katherine Marsden
• Reporter: Myrna van Lunteren
• Created: 26/Jan/06 22:35
• Updated: 12/Jul/06 01:40
• Resolved: 19/Feb/06 05:49

Description

The test lang/resultset.java fails with DerbyNetClient on zOS
because ResultSet.getDate(#) fails with an
java.lang.IllegalArgumentException - unsupported date format.

This is the stack trace with 10.2 debug version (but it fails
with 10.1 also):
------------------
....
getBytes(dt) got exception
Data Conversion SQLException
FAIL – unexpected exception:
java.lang.IllegalArgumentException: Unsupported date format!
java.lang.IllegalArgumentException: Unsupported date format!
at
org.apache.derby.client.am.DateTime.dateBytesToDate(DateTime.java:63)
at
org.apache.derby.client.am.Cursor.getDATE(Cursor.java:400)
at
org.apache.derby.client.am.Cursor.getDate(Cursor.java:712)
at
org.apache.derby.client.am.ResultSet.getDate(ResultSet.java:687)
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.resultset.main(Unknown Source)
------------------
Note: does not fail with jcc.

Also, test lang/updatableResultSet.java failed with e.g.:

• instead of 'Got expected exception : Illegal Conversion' :
  'Got expected exception : Unsupported date format!' .
• instead of 'Got expected exception : Illegal Conversion' :
  'Got expected exception : nanos > 99999999999 or < 0' .