|
Hello
Here are the JDBC Test,
excluding type get/set and Escape Syntax tests.
I hope those results help to
improve the driver.
0.-
Connection
OK
1.-
DatabaseMetaData
getUDTs
- Not Implemented (If the Driver does not support it, it must return empty
ResultSet)
getVersionColumns - Not Implemented (If the Driver does not support it,
it must return empty ResultSet)
2.-
ResultSetMetaData
OK
3.- Statement (excluding
get/set checks related to types)
Statement.executeQuery() that tries to insert a row must throw
SQLException
Statement.executeUpdate() that tries to select a row from the table must throw
SQLException
Statement.setFetchSize(negative) must throw SQLException.
Statement.setMaxFieldSize() don't set the value.
Statement.setMaxFieldSize(negative) must throw SQLException.
Statement.setMaxRows() don't set
the value.
Statement.setMaxRows(negative)
must throw SQLException
Statement.setQueryTimeout(negative) must throw SQLException. 4.-
PreparedStatement
PreparedStatement.clearParameters() don't work.
PreparedStatement.execute() if the preparedStatement has parameters and was not
set must throw SQLException
PreparedStatement.executeUpdate() if the preparedStatement has parameters and
was not set must throw SQLException.
PreparedStatement.executeQuery() if the preparedStatement has parameters and was
not set must throw SQLException.
5.- ResultSet (excluding type
get/set)
ResultSet.getType() not
implemented
ResultSet.setFetchSize(negative)
must throw SQLException.
Calling ResultSet.Last();
ResultSet.isLast(); on an empty ResultSet must return false.
6.- DateTime
OK
7.- BatchUpdate
PreparedStatement.executeBatch() with
a select statement must throw a
SQLException.
Statement.executeBatch() with a select statement must throw a
SQLException. CallableStatement.executeBatch() with
a procedure with an OUT parameter must throw a SQLException.
CallableStatement.executeBatch() with
a procedure with an INOUT parameter must throw a SQLException. executeBatch() does not return
the correct UpdateCount values.
8.-
Exception
8.1-
BatchUpdateException
Copy from
JDBC Test Suite=
"Get a
Statement object and call the addBatch() method with 4 SQL statements ,out
of which first 3 statements
are insert,update and delete statements followed by a select statement and call the executeBatch() method. This causes a BatchUpdateException being thrown and getUpdateCounts() method on this BatchUpdateException object should return an integer array of length 3 with each value indicating the number of corressponding rows affected by execution of 3 SQL statements in the same order as added to the batch." SAPDB Driver
does not throw the BatchUpdateException.
8.2.-
StatementException
OK
9.-
EscapeSyntax
Not
executed. Regards
Blas Rodriguez Somoza
|
