db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "JdbcFourOneTesting" by lilywei
Date Tue, 22 Mar 2011 16:03:54 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The "JdbcFourOneTesting" page has been changed by lilywei.
http://wiki.apache.org/db-derby/JdbcFourOneTesting?action=diff&rev1=5&rev2=6

--------------------------------------------------

  || <<Icon(checkmark.png)>> ||'''Connection.setNetworkTimeout(Executor)'''||Optional
new method. Sets the client timeout.||Throw SQLFeatureNotSupportedException.Test:ConnectionMethodsTest||Small||Lily||
  || <<Icon(checkmark.png)>> ||'''Connection.setSchema(String)'''||Mandatory new
method. Sets the name of the session's schema.||Add to JSR 169 implementation.Test:ConnectionMethodsTest||Small||Lily||
  || <<Icon(checkmark.png)>> ||'''Connection.setTypeMap(Map)'''||Spec clarification.||No
action needed.(Throw SQLFeatureNotSupportedException) Test:ConnectionTest(added)J2EEDataSourceTest||None||Lily||
- || <<Icon(angry.png)>> ||'''DBMD.generatedKeyAlwaysReturned()'''||Mandatory
new method. Reports whether Statement.getGeneratedKeys() always returns a ResultSet even after
Statement.execute(String query, String[] columnNames) is called with columnNames that are
not identity columns.||Embedded Derby throws an exception if you call execute(String,String[])
with columnNames that are not identity columns, so the return value of getGeneracase, getGeneratedKeys()
returns a ResultSet with generated values. Note that Derby only allows you to define one identity
column per table. Because of the network behavior, I think that DBMD.generatedKeyAlwaysReturned()
should return true.||Small||Lily||
+ || <<Icon(checkmark.png)>> ||'''DBMD.generatedKeyAlwaysReturned()'''||Mandatory
new method. Reports whether Statement.getGeneratedKeys() always returns a ResultSet even after
Statement.execute(String query, String[] columnNames) is called with columnNames that are
not identity columns.||Embedded Derby throws an exception if you call execute(String,String[])
with columnNames that are not identity columns, so the return value of getGeneracase, getGeneratedKeys()
returns a ResultSet with generated values. Note that Derby only allows you to define one identity
column per table. Because of the network behavior, I think that DBMD.generatedKeyAlwaysReturned()
should return true.Test:DatabaseMetaDataTest||Small||Lily||
- || <<Icon(angry.png)>> ||'''DBMD.getPseudoColumns(String,String,String,String)'''||Mandatory
new method. Shows the hidden columns in a table.||Derby doesn't have hidden columns. Return
an empty ResultSet with the correct column structure. ||Small||Lily||
+ || <<Icon(checkmark.png)>> ||'''DBMD.getPseudoColumns(String,String,String,String)'''||Mandatory
new method. Shows the hidden columns in a table.||Derby doesn't have hidden columns. Return
an empty ResultSet with the correct column structure.Test:DatabaseMetaDataTest ||Small||Lily||
- || <<Icon(angry.png)>> ||'''DBMD.getColumns(String,String,String,String)'''||Changed
method. New field reports whether a column is generated as defined by the SQL Standard, part
2, section 4.14.8. These are columns defined by generation clauses built out of deterministic
expressions involving other columns in the row. These are what Derby call generaated colmns||Add
this field to the metadata query.||Small||Lily||
+ || <<Icon(checkmark.png)>> ||'''DBMD.getColumns(String,String,String,String)'''||Changed
method. New field reports whether a column is generated as defined by the SQL Standard, part
2, section 4.14.8. These are columns defined by generation clauses built out of deterministic
expressions involving other columns in the row. These are what Derby call generaated colmns||Add
this field to the metadata query.Test:DatabaseMetaDataTest||Small||Lily||
- || <<Icon(angry.png)>> ||'''DBMD.getProcedureColumns(String,String,String,String)'''||Spec
clarification.||Nothing to do.||None||Lily||
+ || <<Icon(checkmark.png)>> ||'''DBMD.getProcedureColumns(String,String,String,String)'''||Spec
clarification.||Nothing to do.Test:DatabaseMetaDataTest||None||Lily||
- || <<Icon(angry.png)>> ||'''DBMD.supportsStatementPooling()'''||Spec clarification.||Nothing
to do.||None||Lily||
+ || <<Icon(checkmark.png)>> ||'''DBMD.supportsStatementPooling()'''||Spec clarification.||Nothing
to do.Test:DatabaseMetaDataTest||None||Lily||
  || <<Icon(checkmark.png)>> ||'''Driver.getParentLogger()'''||Optional new method.
Returns the root logger for this Driver.||Derby doesn't use java.util.logging so this method
can throw SQLFeatureNotSupportedException.||Small||Lily||
- || <<Icon(angry.png)>> ||'''!PreparedStatement.execute()'''||Should throw a
SQLTimeoutException if the query runs beyond the limit set by setQueryTimeout().||The timeout
work done for Statement.execute() should apply here.||Small||-||
+ || <<Icon(angry.png)>> ||'''!PreparedStatement.execute()'''||Should throw a
SQLTimeoutException if the query runs beyond the limit set by setQueryTimeout().||The timeout
work done for Statement.execute() should apply here.||Small||Lily||
- || <<Icon(angry.png)>> ||'''!PreparedStatement.executeQuery()'''||Should throw
a SQLTimeoutException if the query runs beyond the limit set by setQueryTimeout().||The timeout
work done for Statement.execute() should apply here.||Small||-||
+ || <<Icon(angry.png)>> ||'''!PreparedStatement.executeQuery()'''||Should throw
a SQLTimeoutException if the query runs beyond the limit set by setQueryTimeout().||The timeout
work done for Statement.execute() should apply here.||Small||Lily||
- || <<Icon(angry.png)>> ||'''!PreparedStatement.executeUpdate()'''||Should throw
a SQLTimeoutException if the query runs beyond the limit set by setQueryTimeout().||The timeout
work done for Statement.execute() should apply here.||Small||-||
+ || <<Icon(angry.png)>> ||'''!PreparedStatement.executeUpdate()'''||Should throw
a SQLTimeoutException if the query runs beyond the limit set by setQueryTimeout().||The timeout
work done for Statement.execute() should apply here.||Small||Lily||
- || <<Icon(angry.png)>> ||'''ResultSet.absolute(int)'''||If the argument is 0,
then the ResultSet is positioned before the first row.||Verify that Derby behaves this way.
If it doesn't, make this change. Note that Derby does behave this way. This is verified by
!ScrollCursors2Test.testScrollInsensitivePositive()||Small||-||
+ || <<Icon(angry.png)>> ||'''ResultSet.absolute(int)'''||If the argument is 0,
then the ResultSet is positioned before the first row.||Verify that Derby behaves this way.
If it doesn't, make this change. Note that Derby does behave this way. This is verified by
!ScrollCursors2Test.testScrollInsensitivePositive()||Small||Lily||
- || <<Icon(angry.png)>> ||'''ResultSet.getObject(int,Class)'''||Optional new
method. Returns the column as an object of the requested type, provided that the coercion
is supported in Appendix B, table B-1.||Add this overload to the JDBC 4 implementation (uses
generics). Some testing may be required to verify that Derby really supports the required
coercions.||Medium||-||
+ || <<Icon(angry.png)>> ||'''ResultSet.getObject(int,Class)'''||Optional new
method. Returns the column as an object of the requested type, provided that the coercion
is supported in Appendix B, table B-1.||Add this overload to the JDBC 4 implementation (uses
generics). Some testing may be required to verify that Derby really supports the required
coercions.||Medium||Lily||
- || <<Icon(angry.png)>> ||'''ResultSet.getObject(String,Class)'''||Mandatory
new method. Behaves like getObject(int,Class).||The work done for getObject(int,Class) should
apply here.||Small||-||
+ || <<Icon(angry.png)>> ||'''ResultSet.getObject(String,Class)'''||Mandatory
new method. Behaves like getObject(int,Class).||The work done for getObject(int,Class) should
apply here.||Small||Lily||
  || <<Icon(angry.png)>> ||'''Statement.addBatch(String)'''||Clarifies that this
method can't be called on a !PreparedStatement or !CallableStatement.||Verify that Derby behaves
this way. If it doesn't, make this change.||Small||-||
  || <<Icon(angry.png)>> ||'''Statement.closeOnCompletion()'''||Mandatory new
method. Automatically close the Statement when its dependent objects (like ResultSets) are
closed.||Implement this behavior.||Medium||-||
  || <<Icon(angry.png)>> ||'''Statement.execute(String)'''||Throw SQLTimeoutException
when the statement times out. Also don't allow this method to be called on !PreparedStatements
or !CallableStatements.||Implement this behavior.||Medium||-||

Mime
View raw message