JDBC Test

[Blas Rodriguez Somoza]

Hello       Some days ago, I ask if the JDBC Test Suite is a TODO for the JDBC Driver, and Marco answers that it is.       I'm working on a general JDBC manager/editor and I want to test drivers without a J2EE server, so I'm preparing a tool to do it.        I begin implementing those tests included in the Test Suite, because those are the official ones, excluding those that check get/set of datatypes (9).       I did the following tests, with the following results:       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.             In a couple of days I'll send the remaining tests. (ResultSet, exception, escapeSyntax, dateTime, batchUpdate)   Regards Blas Rodriguez Somoza