[
http://issues.apache.org/jira/browse/DERBY-1610?page=comments#action_12429998 ]
Tomohito Nakayama commented on DERBY-1610:
------------------------------------------
I read the test class, parameterMapping.java as next.
This test is executed for each types on which column of table was created.
Test items executed for each types is as next.
1. Test of getXXX method for null value
setNull is executed as type of column.
And then test getting from created record in this testing item as each of
all types which was prepared in get methods of ResultSet.
2. Test of getXXX method for none null value
Correspoindng set method of PreparedStatement for type of column is
executed.
And then test getting from created record in this testing item as each of
all types which was prepared in get methods of ResultSet.
3. Test of setNull method
This test item is executed for each of all types (including illegal type
which is illegal type value in JDBC).
Here, call it as the type of this test item group.
3-1. setNull is executed as the type of this test item group.
And then test getting from created record in this testing item as type
of this test item group.
3-2. setNull is executed as the type of this test item group. And addBatch is
executed.
And then test getting from created record in this testing item as type
of this test item group.
4 Test of setXXX method
This test item is executed for each of all types which was provided as set
method of PreparedStatement.
Here, call it as the type of this test item group.
4-1. Set method of the type of this test item group and executeUpdae is
executed.
And then test getting from created record in this testing item as type
of column.
Furthermore tries to set null value using setXXX method if possible in
that type.
4-2. Set method of the type of this test item group and executeUpdae is
executed. And addBatch is executed.
And then test getting from created record in this testing item as type
of column.
Furthermore tries to set null value using setXXX method if possible in
that type.
5 Test of stored procedure
This test item is for stored procedure. In this test, actual column of table
created is not used. But test is done for the type of column as same as 1-4.
5-1 Stored procedure which have IN INOUT OUT parameters which have type of
column is created.
5-2 This test item is executed for all of types.
Here call it as the type of this test item group.
5-2-1 INOUT parameter is registered by registerOutParameter as the type of this
test item group.
5-2-2 OUT parameter is registered by registerOutParameter as the type of this
test item gorup.
5-2-3 IN parameter is set as type of column.
5-2-4 Stored procedure is executed.
5-2-5 OUT parameter and INOUT parameter is retrieved as the type of this test
item gorup.
> Updating column typed as CHAR to value passed via setBinaryStream(notNull) is
> failed because of imcompatiblity of types though it was not taken as error
> when setBinaryStream(null)
> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1610
> URL: http://issues.apache.org/jira/browse/DERBY-1610
> Project: Derby
> Issue Type: Bug
> Components: Network Server, Network Client
> Reporter: Tomohito Nakayama
> Assigned To: Tomohito Nakayama
> Attachments: DERBY-1610.diff, DERBY-1610_2.diff,
> parameterMapping.diff, parameterMapping.diff, TestNullChar.java
>
>
> There exists difference between updating character typed column to value
> passed via setBinaryStream(notNullValue) and updating the column to value
> passed via setBinaryStream(null).
> This difference is problematic because it does not exist in Embedded mode.
--
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
