[TRAFODION-2076] [3rd party tool-Squirrel] call spj will return error though the procedure is actually executed successfully

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.1-incubating
• Component/s: client-jdbc-t4
• Environment: Squirrel 3.7 ; server info -- adv R2.1, centos6.7, hbase1.0, cdh5.4.8
• Assignee: mashengchen
• Reporter: Gao, Rui-Xian
• Created: 20/Jun/16 09:12
• Updated: 26/Jan/18 08:28

Description

create library qa_dfr file '/home/trafodion/QALibs/SPJ/dfr.jar'
Create procedure createTable()
external name 'TestDDL.createTable'
LIBRARY qa_dfr
language java
NO TRANSACTION REQUIRED
parameter style java;
call createTable();

Following error will be returned –
java.lang.ClassCastException: org.trafodion.jdbc.t4.TrafT4Statement cannot be cast to org.trafodion.jdbc.t4.TrafT4CallableStatement

But actually the table is created successfully.