Is there any way for a trigger to work on creation/drop table? i saw
something on DDL being able to do something about it? Please help, thanks!
Can event listener be used to monitor the database and when there is a
creation/drop of table? So when creation/drop event happen, the setProgress
metho
Hi,
Thanks i will try it out.
By the way, is trigger about to be used in server mode? When i tried running
my database in server mode and another application connect to it and do a
delete/update/insert statement, this error came out.
Exception in thread "main" org.h2.jdbc.JdbcSQLException: Error
i have tested the trigger with embedded mode and it is working fine but when
i use auto_server=true mode which also meant server mode, the trigger don't
work. it keep having this error:
Exception in thread "main" org.h2.jdbc.JdbcSQLException: Error creating or
initializing trigger "AFTERTRIGGER"
does anyone know why does this happen? is it because Trigger can't be used in
server mode?
--
View this message in context:
http://h2-database.66688.n3.nabble.com/Trigger-work-with-h2-server-tp4028200p4028206.html
Sent from the H2 Database mailing list archive at Nabble.com.
--
You received t
Hi,
I have placed my jar file in the jre i am using and also placed the path in
the classpath but i still get this error.
--
View this message in context:
http://h2-database.66688.n3.nabble.com/Trigger-work-with-h2-server-tp4028200p4028214.html
Sent from the H2 Database mailing list archive
alueLob.java:775)
Regards,
Wei Ren
On Tuesday, January 28, 2014 12:14:04 PM UTC+8, Vonmist wrote:
>
> Hi, i have created a Trigger on a specific database and it will insert
> data into another database once a trigger is invoked. This is working fine
> using java but if i were to delete
Does anyone know how to solve this problem? Thanks
On Tuesday, January 28, 2014 12:14:04 PM UTC+8, Vonmist wrote:
>
> Hi, i have created a Trigger on a specific database and it will insert
> data into another database once a trigger is invoked. This is working fine
> using java but
Hi all,
I am currently using h2 version 1.3.174 and faced this error when i am
working on Trigger class whereby a UPDATE statement is at the fire() method.
I have searched the net and was told h2 v1.3.174 shouldnt have this problem
but even when i changed back to 1.3.174, the error still surface
On Thursday, March 20, 2014 7:48:12 PM UTC+8, Vonmist wrote:
>
> Hi all,
>
> I am currently using h2 version 1.3.174 and faced this error when i am
> working on Trigger class whereby a UPDATE statement is at the fire() method.
> I have searched the net and was told h2 v1.3
Hi Noel
The exception trace is as shown from previous post.
Thanks
On Thursday, March 20, 2014 8:06:25 PM UTC+8, Vonmist wrote:
>
>
>
> On Thursday, March 20, 2014 7:48:12 PM UTC+8, Vonmist wrote:
>>
>> Hi all,
>>
>> I am currently using h2 version 1.
Inside my fire() method, there is a preparedStatement that execute a update
statement to the database.
On Thursday, March 20, 2014 8:09:46 PM UTC+8, Noel Grandin wrote:
>
> that exception is in your code:
>at
> com.auctorizium.database.server.TestTrigger.fire(TestTrigger.java:41)
>
>
--
The update statement have been tested and was working outside of the
Trigger Class but when it was run at the fire() method inside the Trigger,
the error appear.
Thanks
On Thursday, March 20, 2014 8:12:40 PM UTC+8, Vonmist wrote:
>
> Inside my fire() method, there is a preparedStatemen
12 matches
Mail list logo