Hm...

Am I getting something wrong here? Or am I right saying that H2 already 
supports this via 

CREATE TRIGGER ... AS sourceCodeString

Check http://h2database.com/html/grammar.html#create_trigger


 
Am Dienstag, 17. Januar 2017 21:47:52 UTC+1 schrieb Yan:
>
> Fair enough Noel. 
>
> What about opening up inline java coding like alias/functions ? Currently 
> triggers must refer to an existing compiled class - the alternative to 
> provide the java code in the trigger creation statement would really be a 
> plus. 
>
> As an alias gets implicitly the connection, a trigger method would in 
> addition receive the old and new rows.
>
> On Monday, January 16, 2017 at 1:56:20 PM UTC-5, Noel Grandin wrote:
>>
>> we have triggers, we just don't have triggers implemented in some 
>> embedded SQL mini-language.
>>
>> http://h2database.com/html/grammar.html#create_trigger
>>
>> I don't think this is likely to happen any time soon, since I consider 
>> the current solution adequate, and I don't see the point in creating a 
>> half-baked trigger language when we can already use a full-featured 
>> language like Java.
>> ​
>>
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to