You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Ole Solberg (JIRA)" <de...@db.apache.org> on 2006/02/15 12:02:08 UTC
[jira] Created: (DERBY-988) jdbcapi/parameterMapping.java fails on
Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string
representation of a datetime value is incorrect.'
jdbcapi/parameterMapping.java fails on Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.'
------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: DERBY-988
URL: http://issues.apache.org/jira/browse/DERBY-988
Project: Derby
Type: Bug
Versions: 10.2.0.0
Environment: OS: Microsoft(R) Windows(R) Server 2003, - 5.2.3790 Service Pack 1 Build 3790 - CYGWIN_NT-5.2 1.5.12(0.116/4/2) 2004-11-10 08:34 Cygwin, JVM: Sun Microsystems Inc. 1.5.0_04
Reporter: Ole Solberg
Priority: Minor
"Signature":
********* Diff file jdbcapi/jdbcapi/parameterMapping.diff
*** Start: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:02:02 ***
1918a1919,1922
> P2=cs.getTime=13:26:42 was null false
> P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
1920,1922d1923
< INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
< OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
< P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
2152a2154,2157
> P2=cs.getTime=13:26:42 was null false
> P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
2154,2156d2158
< INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
< OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
< P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
Test Failed.
*** End: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:03:09 ***
http://www.multinet.no/~solberg/public/Apache/Derby/Limited/testSummary-377800.html [CYGWIN_NT-5.2 i686-unknown]
--
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
[jira] Commented: (DERBY-988) jdbcapi/parameterMapping.java fails
on Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the
string representation of a datetime value is incorrect.'
Posted by "Myrna van Lunteren (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-988?page=comments#action_12367684 ]
Myrna van Lunteren commented on DERBY-988:
------------------------------------------
I found it hard to see what's happening here based on the diff above, so here's my analysis:
With the no_NO locale set, when the INOUT parameter is registered as CHAR(60) or VARCHAR(60), if we issue callableStatement.getTime() and callableStatement.wasNull() we do *not* get an error 22007 (syntax of the string representation of the datetimevalue isincorrect), but we see the correct values.
We get the error with en_US locale, and we do get the error even in no_NO when using cs.getTime() and cs.wasNull() on the OUT parameter. Just not on the INOUT.
I'll prod at this a little more, my questions are:
- which call is causing the error to come up in en_US, cs.getTime() or cs.wasNull()
- what is the value that causes the error in the first place (i.e. what are we getting that seems incorrect)
- how come the value that comes out with the INOUT parameter in norwegian looks ok, but it's wrong with an OUT parameter? i.e. what's the difference between IN and INOUT in this case?
> jdbcapi/parameterMapping.java fails on Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.'
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-988
> URL: http://issues.apache.org/jira/browse/DERBY-988
> Project: Derby
> Type: Test
> Components: Regression Test Failure
> Versions: 10.2.0.0
> Environment: OS: Microsoft(R) Windows(R) Server 2003, - 5.2.3790 Service Pack 1 Build 3790 - CYGWIN_NT-5.2 1.5.12(0.116/4/2) 2004-11-10 08:34 Cygwin, JVM: Sun Microsystems Inc. 1.5.0_04
> Reporter: Ole Solberg
> Priority: Minor
>
> "Signature":
> ********* Diff file jdbcapi/jdbcapi/parameterMapping.diff
> *** Start: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:02:02 ***
> 1918a1919,1922
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 1920,1922d1923
> < INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> 2152a2154,2157
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 2154,2156d2158
> < INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> Test Failed.
> *** End: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:03:09 ***
> http://www.multinet.no/~solberg/public/Apache/Derby/Limited/testSummary-377800.html [CYGWIN_NT-5.2 i686-unknown]
--
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
[jira] Updated: (DERBY-988) jdbcapi/parameterMapping.java fails on
Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string
representation of a datetime value is incorrect.'
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-988?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-988:
-------------------------------------
Component/s: (was: Test)
JDBC
Changed component from Test to JDBC since this appears to be a problem with the product and not with the test.
> jdbcapi/parameterMapping.java fails on Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.'
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-988
> URL: https://issues.apache.org/jira/browse/DERBY-988
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.1.6
> Environment: OS: Microsoft(R) Windows(R) Server 2003, - 5.2.3790 Service Pack 1 Build 3790 - CYGWIN_NT-5.2 1.5.12(0.116/4/2) 2004-11-10 08:34 Cygwin, JVM: Sun Microsystems Inc. 1.5.0_04
> Reporter: Ole Solberg
> Priority: Minor
> Attachments: D988.java
>
>
> "Signature":
> ********* Diff file jdbcapi/jdbcapi/parameterMapping.diff
> *** Start: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:02:02 ***
> 1918a1919,1922
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 1920,1922d1923
> < INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> 2152a2154,2157
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 2154,2156d2158
> < INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> Test Failed.
> *** End: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:03:09 ***
> http://www.multinet.no/~solberg/public/Apache/Derby/Limited/testSummary-377800.html [CYGWIN_NT-5.2 i686-unknown]
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-988) jdbcapi/parameterMapping.java fails
on Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the
string representation of a datetime value is incorrect.'
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12843557#action_12843557 ]
Knut Anders Hatlen commented on DERBY-988:
------------------------------------------
The same problem is seen with the locales sv_SE, de_DE, ja_JP, zh_CN, fr_FR and nl_NL. I don't see it with en_CA, zh_TW or it_IT.
> jdbcapi/parameterMapping.java fails on Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.'
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-988
> URL: https://issues.apache.org/jira/browse/DERBY-988
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.1.6
> Environment: OS: Microsoft(R) Windows(R) Server 2003, - 5.2.3790 Service Pack 1 Build 3790 - CYGWIN_NT-5.2 1.5.12(0.116/4/2) 2004-11-10 08:34 Cygwin, JVM: Sun Microsystems Inc. 1.5.0_04
> Reporter: Ole Solberg
> Priority: Minor
> Attachments: D988.java
>
>
> "Signature":
> ********* Diff file jdbcapi/jdbcapi/parameterMapping.diff
> *** Start: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:02:02 ***
> 1918a1919,1922
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 1920,1922d1923
> < INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> 2152a2154,2157
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 2154,2156d2158
> < INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> Test Failed.
> *** End: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:03:09 ***
> http://www.multinet.no/~solberg/public/Apache/Derby/Limited/testSummary-377800.html [CYGWIN_NT-5.2 i686-unknown]
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-988) jdbcapi/parameterMapping.java fails on
Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string
representation of a datetime value is incorrect.'
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-988?page=all ]
Rick Hillegas updated DERBY-988:
--------------------------------
Fix Version/s: 10.2.3.0
(was: 10.2.2.0)
Move to 10.2.3.0.
> jdbcapi/parameterMapping.java fails on Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.'
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-988
> URL: http://issues.apache.org/jira/browse/DERBY-988
> Project: Derby
> Issue Type: Test
> Components: Regression Test Failure
> Affects Versions: 10.2.1.6
> Environment: OS: Microsoft(R) Windows(R) Server 2003, - 5.2.3790 Service Pack 1 Build 3790 - CYGWIN_NT-5.2 1.5.12(0.116/4/2) 2004-11-10 08:34 Cygwin, JVM: Sun Microsystems Inc. 1.5.0_04
> Reporter: Ole Solberg
> Priority: Minor
> Fix For: 10.2.3.0
>
>
> "Signature":
> ********* Diff file jdbcapi/jdbcapi/parameterMapping.diff
> *** Start: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:02:02 ***
> 1918a1919,1922
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 1920,1922d1923
> < INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> 2152a2154,2157
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 2154,2156d2158
> < INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> Test Failed.
> *** End: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:03:09 ***
> http://www.multinet.no/~solberg/public/Apache/Derby/Limited/testSummary-377800.html [CYGWIN_NT-5.2 i686-unknown]
--
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
[jira] Updated: (DERBY-988) jdbcapi/parameterMapping.java fails on
Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string
representation of a datetime value is incorrect.'
Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-988?page=all ]
Rick Hillegas updated DERBY-988:
--------------------------------
Fix Version/s: 10.2.2.0
(was: 10.2.1.0)
Moving to 10.2.2.0.
> jdbcapi/parameterMapping.java fails on Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.'
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-988
> URL: http://issues.apache.org/jira/browse/DERBY-988
> Project: Derby
> Issue Type: Test
> Components: Regression Test Failure
> Affects Versions: 10.2.1.0
> Environment: OS: Microsoft(R) Windows(R) Server 2003, - 5.2.3790 Service Pack 1 Build 3790 - CYGWIN_NT-5.2 1.5.12(0.116/4/2) 2004-11-10 08:34 Cygwin, JVM: Sun Microsystems Inc. 1.5.0_04
> Reporter: Ole Solberg
> Priority: Minor
> Fix For: 10.2.2.0
>
>
> "Signature":
> ********* Diff file jdbcapi/jdbcapi/parameterMapping.diff
> *** Start: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:02:02 ***
> 1918a1919,1922
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 1920,1922d1923
> < INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> 2152a2154,2157
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 2154,2156d2158
> < INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> Test Failed.
> *** End: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:03:09 ***
> http://www.multinet.no/~solberg/public/Apache/Derby/Limited/testSummary-377800.html [CYGWIN_NT-5.2 i686-unknown]
--
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
[jira] Updated: (DERBY-988) jdbcapi/parameterMapping.java fails on
Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string
representation of a datetime value is incorrect.'
Posted by "Ole Solberg (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-988?page=all ]
Ole Solberg updated DERBY-988:
------------------------------
Component: Regression Test Failure
type: Test (was: Bug)
> jdbcapi/parameterMapping.java fails on Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.'
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-988
> URL: http://issues.apache.org/jira/browse/DERBY-988
> Project: Derby
> Type: Test
> Components: Regression Test Failure
> Versions: 10.2.0.0
> Environment: OS: Microsoft(R) Windows(R) Server 2003, - 5.2.3790 Service Pack 1 Build 3790 - CYGWIN_NT-5.2 1.5.12(0.116/4/2) 2004-11-10 08:34 Cygwin, JVM: Sun Microsystems Inc. 1.5.0_04
> Reporter: Ole Solberg
> Priority: Minor
>
> "Signature":
> ********* Diff file jdbcapi/jdbcapi/parameterMapping.diff
> *** Start: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:02:02 ***
> 1918a1919,1922
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 1920,1922d1923
> < INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> 2152a2154,2157
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 2154,2156d2158
> < INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> Test Failed.
> *** End: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:03:09 ***
> http://www.multinet.no/~solberg/public/Apache/Derby/Limited/testSummary-377800.html [CYGWIN_NT-5.2 i686-unknown]
--
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
[jira] Updated: (DERBY-988) jdbcapi/parameterMapping.java fails on
Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string
representation of a datetime value is incorrect.'
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-988?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-988:
-------------------------------------
Attachment: D988.java
This test does not fail anymore in no_NO locale because DERBY-323 made all tests in the old framework run with -Duser.language=en -Duser.country=US, and because DERBY-2333 rewrote it to JUnit, probably without preserving the logic that detected unexpected success.
I'm attaching a stand-alone test case that reproduces this problem on head of trunk. It runs the same sequence of commands first with locale en_US and then with locale no_NO. Here's the output I see with Java 1.7.0-ea-b85 on OpenSolaris:
> Running test in locale en_US...
> cs.getTime(2) failed: java.sql.SQLDataException: The syntax of the string representation of a datetime value is incorrect.
> cs.getTime(3) failed: java.sql.SQLDataException: The syntax of the string representation of a datetime value is incorrect.
>
> Running test in locale no_NO...
> cs.getTime(2) returned 13:26:42
> cs.getTime(3) failed: java.sql.SQLDataException: The syntax of the string representation of a datetime value is incorrect.
The value returned for parameter 2 (an INOUT parameter of type CHAR(60)) is the string "13:26:42P2-PMAP", which I believe is supposed to raise an exception when converted to java.sql.Time regardless of locale. So I think we have a bug here.
The parameter that fails in both locales (#3, an OUT parameter of type CHAR(60)) contains the string "P3-PMAP". If I change it to return "13:26:42P3-PMAP", it fails too, so the problem is not limited to INOUT.
> jdbcapi/parameterMapping.java fails on Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.'
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-988
> URL: https://issues.apache.org/jira/browse/DERBY-988
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.2.1.6
> Environment: OS: Microsoft(R) Windows(R) Server 2003, - 5.2.3790 Service Pack 1 Build 3790 - CYGWIN_NT-5.2 1.5.12(0.116/4/2) 2004-11-10 08:34 Cygwin, JVM: Sun Microsystems Inc. 1.5.0_04
> Reporter: Ole Solberg
> Priority: Minor
> Attachments: D988.java
>
>
> "Signature":
> ********* Diff file jdbcapi/jdbcapi/parameterMapping.diff
> *** Start: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:02:02 ***
> 1918a1919,1922
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 1920,1922d1923
> < INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> 2152a2154,2157
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 2154,2156d2158
> < INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> Test Failed.
> *** End: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:03:09 ***
> http://www.multinet.no/~solberg/public/Apache/Derby/Limited/testSummary-377800.html [CYGWIN_NT-5.2 i686-unknown]
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-988) jdbcapi/parameterMapping.java fails on
Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string
representation of a datetime value is incorrect.'
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-988?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dag H. Wanvik updated DERBY-988:
--------------------------------
Issue Type: Bug (was: Test)
> jdbcapi/parameterMapping.java fails on Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.'
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-988
> URL: https://issues.apache.org/jira/browse/DERBY-988
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.2.1.6
> Environment: OS: Microsoft(R) Windows(R) Server 2003, - 5.2.3790 Service Pack 1 Build 3790 - CYGWIN_NT-5.2 1.5.12(0.116/4/2) 2004-11-10 08:34 Cygwin, JVM: Sun Microsystems Inc. 1.5.0_04
> Reporter: Ole Solberg
> Priority: Minor
>
> "Signature":
> ********* Diff file jdbcapi/jdbcapi/parameterMapping.diff
> *** Start: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:02:02 ***
> 1918a1919,1922
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 1920,1922d1923
> < INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> 2152a2154,2157
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 2154,2156d2158
> < INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> Test Failed.
> *** End: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:03:09 ***
> http://www.multinet.no/~solberg/public/Apache/Derby/Limited/testSummary-377800.html [CYGWIN_NT-5.2 i686-unknown]
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-988) jdbcapi/parameterMapping.java fails on
Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string
representation of a datetime value is incorrect.'
Posted by "Mike Matrigali (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-988?page=all ]
Mike Matrigali updated DERBY-988:
---------------------------------
Fix Version/s: 10.2.1.0
> jdbcapi/parameterMapping.java fails on Win2003 with 'P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.'
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-988
> URL: http://issues.apache.org/jira/browse/DERBY-988
> Project: Derby
> Issue Type: Test
> Components: Regression Test Failure
> Affects Versions: 10.2.1.0
> Environment: OS: Microsoft(R) Windows(R) Server 2003, - 5.2.3790 Service Pack 1 Build 3790 - CYGWIN_NT-5.2 1.5.12(0.116/4/2) 2004-11-10 08:34 Cygwin, JVM: Sun Microsystems Inc. 1.5.0_04
> Reporter: Ole Solberg
> Priority: Minor
> Fix For: 10.2.1.0
>
>
> "Signature":
> ********* Diff file jdbcapi/jdbcapi/parameterMapping.diff
> *** Start: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:02:02 ***
> 1918a1919,1922
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 1920,1922d1923
> < INOUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT CHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> 2152a2154,2157
> > P2=cs.getTime=13:26:42 was null false
> > P3=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> > INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> > OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> 2154,2156d2158
> < INOUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < OUT VARCHAR(60) registerOutParameter(Types.TIMESTAMP) -- OK
> < P2=SQLSTATE(22007): SQL Exception: The syntax of the string representation of a datetime value is incorrect.
> Test Failed.
> *** End: parameterMapping jdk1.5.0_04 jdbcapi:jdbcapi 2006-02-14 22:03:09 ***
> http://www.multinet.no/~solberg/public/Apache/Derby/Limited/testSummary-377800.html [CYGWIN_NT-5.2 i686-unknown]
--
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