db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1450) jdbcapi/parameterMetaDataJdbc30.java fails with 10.1 client and 10.2 server
Date Mon, 26 Jun 2006 12:28:30 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1450?page=comments#action_12417800 ] 

Knut Anders Hatlen commented on DERBY-1450:

This is caused by a test case for DERBY-44 which is supposed to test
  a) that Derby understands the LIKE/ESCAPE syntax
  b) that an empty escape string causes SQLException with SQL state 22019, not IndexOutOfBoundsException

However, since the test only executes the statement and doesn't fetch data, b is never triggered
in 10.1 (neither with the embedded driver nor with the client driver). In 10.2, the client
driver pre-fetches data (DERBY-822) hence b is triggered. In the 10.2 code line, the test
is also updated so that b is triggered regardless of pre-fetching (the exception is also raised
by the embedded driver).

> jdbcapi/parameterMetaDataJdbc30.java fails with 10.1 client and 10.2 server
> ---------------------------------------------------------------------------
>          Key: DERBY-1450
>          URL: http://issues.apache.org/jira/browse/DERBY-1450
>      Project: Derby
>         Type: Test

>     Versions:,
>  Environment: derbyclient.jar and derbyTesting.jar from 10.1
> all other jars from 10.2
>     Reporter: Deepa Remesh

> Test fails with following exception:
> SQLSTATE(22019):org.apache.derby.client.am.SqlException: Invalid escape sequence, ''.
The escape string must be exactly one character. It cannot be a null or more than one character.
> 	at org.apache.derby.client.am.Statement.completeSqlca(Statement.java:1371)
> 	at org.apache.derby.client.net.NetStatementReply.parseOpenQueryError(NetStatementReply.java:605)
> 	at org.apache.derby.client.net.NetStatementReply.parseOPNQRYreply(NetStatementReply.java:229)
> 	at org.apache.derby.client.net.NetStatementReply.readOpenQuery(NetStatementReply.java:56)
> 	at org.apache.derby.client.net.StatementReply.readOpenQuery(StatementReply.java:49)
> 	at org.apache.derby.client.net.NetStatement.readOpenQuery_(NetStatement.java:151)
> 	at org.apache.derby.client.am.Statement.readOpenQuery(Statement.java:1038)
> 	at org.apache.derby.client.am.PreparedStatement.flowExecute(PreparedStatement.java:1396)
> 	at org.apache.derby.client.am.PreparedStatement.executeX(PreparedStatement.java:893)
> 	at org.apache.derby.client.am.PreparedStatement.execute(PreparedStatement.java:884)
> 	at org.apache.derbyTesting.functionTests.tests.jdbcapi.parameterMetaDataJdbc30.main(parameterMetaDataJdbc30.java:146)

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

View raw message