[ http://issues.apache.org/jira/browse/DERBY-877?page=all ]
Kathey Marsden updated DERBY-877:
---------------------------------
Attachment: TestEnc.java
Updated repro
- Adds getString, getTimestamp, getTime and getDate calls for
TIME/DATE/TIMESTAMP
- Allows user to set output.encoding System property to allow more readable
output on Windows and z/OS
To repro on Windows, You must run with jdk 1.5
java -Dfile.encoding=UTF-16 -Doutput.encoding=US-ASCII TestEnc
COLUMN 1:TS TIMESTAMP
java.lang.StringIndexOutOfBoundsException: String index out of range: 14
at java.lang.String.charAt(String.java:558)
at
org.apache.derby.client.am.DateTime.timestampBytesToTimestamp(Unknown Source)
at org.apache.derby.client.am.Cursor.getStringFromTIMESTAMP(Unknown
Source)
at org.apache.derby.client.am.Cursor.getString(Unknown Source)
at org.apache.derby.client.am.ResultSet.getString(Unknown Source)
at TestEnc.checkGetters(TestEnc.java:75)
at TestEnc.go(TestEnc.java:49)
at TestEnc.main(TestEnc.java:26)
To repro on z/OS
java -Doutput.encoding=Cp500 TestEnc
Note this repro shows a bug that getTImetamp() on a TIME column will show date
1900-01-01-01.
I will file a separate bug for that.
> zOS - with DerbyClient getDate(#) fails with IllegalArgumentException -
> unsupported date format - resultset.java
> ----------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-877
> URL: http://issues.apache.org/jira/browse/DERBY-877
> Project: Derby
> Type: Bug
> Components: Network Client
> Versions: 10.1.1.0
> Environment: OS/390 with classic (IBM) jvm142
> Reporter: Myrna van Lunteren
> Assignee: Kathey Marsden
> Attachments: TestEnc.java
>
> 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' .
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
