invoking a trigger

[Loh Ying Hui]

can anyone tell me how can i invoke a trigger in a Database from a servlet ? what kind of statement do i need to execute ?
thanks

[Tina Coleman]

Typically triggers are set to be invoked when someone inserts, updates, or deletes a row in the database. I don't think that triggers can be executed directly. If you need to do some sort of direct execution, use a stored procedure. Or execute the appropriate SQL from your code.

[Loh Ying Hui]

oh i see. can you tell me what's the difference between createStatement and createPreparedStatement ?

[Jamie Robertson]

createPreparedStatement --> no such method...which leads me to believe you may need to have a read through Sun's
JDBC tutorial for the basic's.
Jamie

[Loh Ying Hui]

oh! I didnt notice i wrote createPreparedStatement instead of preparedstatement. anywayz, thanx for the link!