• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DatabaseMetaData and Finding Triggers

 
Yoo-Jin Lee
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
If I use the DatabaseMetaData interface is there a method or an easy way to get triggers and stored procedures? Right now I have to create a vendor-specific SQL statement.
Thanks for your help.
-Yoo-Jin.
 
Adam Hardy
Ranch Hand
Posts: 567
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
from the docs:


after a quick look i couldn't see anything about triggers, but i'd be interested to know if you find it. otherwise if you're using oracle or sql server & perhaps other dbs that i don't know, you can query the db dictionary like a normal table - you just have to know the codes & the column names
 
Yoo-Jin Lee
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Looks like there isn't a method to find triggers I even asked the company where we purchased our jdbc drivers. Perhaps this could be something that could be added to the DatabaseMetaData interface - it's fairly easy enough to do.
cheerios,
Yoo-Jin
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic