[DERBY-3125] registerOutputParameter with a specified scale does not adjust the scale of the output parameter

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.4.1.3
• Component/s: JDBC
• Labels: derby_triage10_5_2
• Urgency: Normal
• Issue & fix info: Repro attached
• Bug behavior facts: Deviation from standard
• Assignee: Unassigned
• Reporter: Katherine Marsden
• Created: 11/Oct/07 22:42
• Updated: 15/Feb/11 21:08

Description

Running the following program with either embedded or client does not adjust the scale of the output parameter.

public class DecimalOutParam {

public static void main(String[] args) throws Exception
{
//Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
//Connection conn = DriverManager.getConnection("jdbc:derby://localhost:1527/wombat;create=true");
Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:derby:wombat;create=true");
Statement s = conn.createStatement();
try

{ s.executeUpdate("DROP PROCEDURE DECPROC"); }

catch (SQLException se)
{

}
s.executeUpdate("CREATE PROCEDURE DECPROC(OUT DECIMAL(10,2)) parameter style java language java NO SQL external name 'DecimalOutParam.decProc'");

CallableStatement cs = conn.prepareCall("CALL DECPROC");
cs.registerOutParameter(1,java.sql.Types.DECIMAL, 0);
cs.executeUpdate();
System.out.println(cs.getBigDecimal(1));

}

public static void decProc(BigDecimal [] outDec)

{ outDec[0] = new BigDecimal("123.45"); }

}

C:/kmarsden/repro/DERBY-2073] java DecimalOutParam
23.45

Should be
23