I am creating an application (in Java) and need a method of updating
the database (i.e. changing table structure add /removing triggers etc).

Most of this sort of stuff is simple to manage through JDBC with
simple SQL statements. What has got me stuck is how to create
triggers/procedures from within the application. Every thing I've
tried so far has resulted in "token unknown" errors.

Has anyone been able to do this sort of thing? If so, how???

Before someone says to dive into something like the isql tool and do
the modifications there, that is the sort of solution I am trying to
avoid.

Any ideas would be apreciated.

Gavin.