java - 如何使我的触发器在类路径(h2 数据库)中可用

Question

当我调用查询时:

st.execute("create trigger myTrigger after insert on NEWPOPULATION for each row call "\NewPopulationTrigger\" ");

控制台写入:未找到Class NewPopulationTrigger

我应该如何遵循这句话"The trigger class must be available in the classpath of the database engine" - 我该如何实现它？

我的研究: The example of my issue/
adding classpath in scala

Answer 1

包必须在类名的左侧给出。

在 H2 示例中。包是org.h2.samples，类是TriggerSample

CREATE TRIGGER INV_INS AFTER INSERT ON INVOICE
FOR EACH ROW CALL "org.h2.samples.TriggerSample"

在您的情况下，最干净的方法是询问 java 中的全名:

st.execute("create trigger myTrigger after insert on NEWPOPULATION for each row call \""+NewPopulationTrigger.class.getName()+"\"");