Hello,
I have the following error message from the t_jdbcsp component :
Exception in component t_JDBCSP_1
Java.sql.SQLException : Parameter 1 cannot be registered to be of type OTHER because it maps to type DECIMAL and they are incompatible.
In the Parameter tab of the component the checkbox function is checked and the result has to be returned in the lastexcrat column of the output schema.
In the output schema the column lastexcrat has the type BigDecimal (The f_excrat function which is called in the component returns a BigDecimal value ; it works fine when called from the Netbeans IDE).
Excerpt of the code generated :
// Start of branch "lastexcrat"
if (lastexcrat != null) {
/**
* start
*/
currentComponent = "tJDBCSP_1";
// lastexcrat
// lastexcrat
if (execStat) {
runStat.updateStatOnConnection("lastexcrat"
+ iterateId, 1, 1);
}
statement_tJDBCSP_1.registerOutParameter(1,
java.sql.Types.OTHER);
if (lastexcrat.finacc_credat == null) {
statement_tJDBCSP_1.setNull(2,
java.sql.Types.DATE);
} else {
Any idea on what is wrong ?
TOS Version: 5.4.1 Build id: r111943-20131212-1133
Bet regards,
Marc.
