hsqldb call procedure java.lang.ClassCastException

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

hsqldb call procedure java.lang.ClassCastException

parker
This post has NOT been accepted by the mailing list yet.
I got the message below,and I don't what is the reason, hsqldb version is 2.3.2.
"
SQL Error                                                                                                                                                                                                        
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
java.lang.ClassCastException: java.lang.Long cannot be cast to org.hsqldb.result.Result java.lang.ClassCastException: java.lang.Long cannot be cast to org.hsqldb.result.Result / Error Code: -458 / State: S1000

1 row(s) in 3 ms"

when "call test_2(1)"

table:

create table if not exists error_log_message(
id BIGINT IDENTITY,
dataid VARCHAR(50),
date timestamp default current_timestamp,
serviceType INTEGER,
errorStatus integer,
location VARCHAR(10),
ip varchar(50),
channel ingeger,
costtime INTEGER
);

procedure:
create procedure test_2 ( in id bigint)
READS SQL DATA
begin atomic
declare curs cursor with return for select id,dataid from ERROR_LOG_MESSAGE where ERROR_LOG_MESSAGE.ID=id;
open curs;
end
Loading...