[BEEHIVE-1185] SQLParameter of type OUT with null value causes NPE durning generation of log message

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0, 1.0.1, 1.0.2
• Fix Version/s: V.Next
• Component/s: System Controls
• Assignee: matt c
• Reporter: Chad Schoettger
• Created: 28/Mar/07 15:50
• Updated: 25/May/07 20:19
• Resolved: 28/Mar/07 16:40

Description

Steps to reproduce:

1) In the JDBC control drts, in the
o.a.b.c.s.j.u.results.StoredProcsDBResultsTest

2) Modify the following line testSPOutParams,

params[1] = new JdbcControl.SQLParameter(new String[8], Types.VARCHAR, JdbcControl.SQLParameter.OUT);

to
params[1] = new JdbcControl.SQLParameter(null, Types.VARCHAR, JdbcControl.SQLParameter.OUT);

The following stack trace occurs:

java.lang.NullPointerException
at org.apache.beehive.controls.system.jdbc.parser.SqlStatement.createPreparedStatementString(SqlStatement.java:252)
at org.apache.beehive.controls.system.jdbc.JdbcControlImpl.execPreparedStatement(JdbcControlImpl.java:280)
at org.apache.beehive.controls.system.jdbc.JdbcControlImpl.invoke(JdbcControlImpl.java:228)
at org.apache.beehive.controls.system.jdbc.test.results.ResultsTestCtrlBean.getProductsByColor(ResultsTestCtrlBean.java:1329)
at org.apache.beehive.controls.system.jdbc.units.results.StoredProcsDBResultsTest.testSPOutParams(StoredProcsDBResultsTest.java:117)
</error>