db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <derby-...@db.apache.org>
Subject [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.'
Date Fri, 24 Feb 2006 17:49:41 GMT
    [ 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


Mime
View raw message