Urgent and Immediate: SQL92 trigger not fired.

[lchlee]

Hi Everyone!!
I posted first thread in my life. There's no response.
I think that my explanation is so sophiscated so nobody answer me.
I again try to explain my situation.

My system
IBM AIX 4.3.3
Progress 9.1B
Patch : 9.1C16
JDK 1.3.1

First table
create table test1 (f1 varchar(20));

Triggered table
create table test_trig (f1 varchar(20), f2 date);

Trigger
CREATE TRIGGER tri_test1
AFTER INSERT ON test1
REFERENCING NEWROW
FOR EACH ROW
IMPORT
import java.sql.*;
BEGIN
String f1;
f1 = (String) NEWROW.getValue(1, CHAR);
SQLIStatement stmt = new SQLIStatement(
"insert into test_trig (f1,f2) values (?,systimestamp)"
);
stmt.setParam(1, f1);
stmt.execute();
END;
commit;

This is my source code...
I think there's no problem with my code.
Whenever I try to fire trigger by inserting value to test1,
I've got error message which is like...
insert into test1 values('ddd');

=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210022
[JDBC Progress Driver]:.

I think that there's problem with environment such as path..
I am really urgent to solve this error..
If any angel who is familiar with this error is in this world, I really
look forward to receiving any comment.
Thanks for reading this stuff..
In advance, I hope I can be the person who help others.

:chat:

 

[Gabor Topor]

Hi,

There are reasons written in KBase 21181. It seems your LIBPATH/PROLIBPATH settings are not correct.

http://www.progress.com/services/support/cgi-bin/techweb-kbase.cgi/dispentry.p?kbid=21181

Anyway, how could you install patch 9.1C16 on 9.1B?

Regards,
Gabor