Erin Drummond wrote: > @Igor: I think you misunderstood. I only have one connection to the > database (provided by the JDBC driver). I only care about and use that > one connection (no other applications access the database). I was > wondering if database trigger could be used to notify the application > (for example, have a trigger (via CREATE TRIGGER etc) that gets > triggered when a table is updated).
Yes, you can have a trigger calling a user-defined function. Though it's not clear why you would need to go to these lengths: if your application is the one making changes, can't it just notify itself at the same time? Before you ask, I have no idea how or whether one can create a user-defined function with Java binding. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
