[DERBY-4958] Wrapper types not recognized when resolving procedures with OUT arguments.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.8.1.2
• Fix Version/s: 10.8.1.2
• Component/s: SQL
• Issue & fix info: Repro attached
• Bug behavior facts: Deviation from standard
• Assignee: Richard N. Hillegas
• Reporter: Richard N. Hillegas
• Created: 04/Jan/11 16:50
• Updated: 19/Apr/11 12:38
• Resolved: 05/Jan/11 17:39

Description

Derby does not recognize the wrapper objects when trying to match Java methods to the signatures of procedures with OUT arguments. For instance, the following procedure declaration

create procedure proc
(
out intCol int
)
language java
parameter style java
no sql
external name 'zz.proc'

is supposed to match both of the following Java signatures:

public static void proc( int[] arg )

{...}
public static void proc( Integer[] arg ) {...}

However, only the first signature is matched. I will attach a test case which shows this.

Issue Links

• blocks: DERBY-4869 Implement JDBC 4.1, the api increment introduced by Java 7
• relates to: DERBY-3652 Derby does not follow the SQL Standard when trying to map SQL routines to Java methods.