Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Getting list of trigger names

  
   Database Forums (Home) -> Java RSS
Next:  How to map the table classes have more than one c..  
Author Message
Sankar

External


Since: Apr 01, 2008
Posts: 3



(Msg. 1) Posted: Fri Apr 11, 2008 4:15 am
Post subject: Getting list of trigger names
Archived from groups: comp>lang>java>databases (more info?)
Hi,
pls help me how to get list of trigger names in a database through
JDBC.. I want to disable triggers for database migration ...

Regards
Sankar R

 >> Stay informed about: Getting list of trigger names 
Back to top
Login to vote
Thomas Kellerer

External


Since: Oct 31, 2007
Posts: 6



(Msg. 2) Posted: Fri Apr 11, 2008 1:26 pm
Post subject: Re: Getting list of trigger names [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Sankar, 11.04.2008 13:15:
> Hi,
> pls help me how to get list of trigger names in a database through
> JDBC.. I want to disable triggers for database migration ...
>
> Regards
> Sankar R
There is no JDBC function for that. You will need to write a SQL statement specific for your DBMS

Thomas

 >> Stay informed about: Getting list of trigger names 
Back to top
Login to vote
Arne_Vajhøj

External


Since: Aug 20, 2006
Posts: 40



(Msg. 3) Posted: Sat Apr 19, 2008 12:59 pm
Post subject: Re: Getting list of trigger names [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Sankar wrote:
> pls help me how to get list of trigger names in a database through
> JDBC.. I want to disable triggers for database migration ...

Many (but not all) databases will support:

SELECT * FROM INFORMATION_SCHEMA.TRIGGERS

Arne
 >> Stay informed about: Getting list of trigger names 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
trigger in Derby? - anybody knows how to create a trigger in Derby which sends emails to notify customers when certain conditions predefined met?

can you call a procedure from trigger in Pl/Sql - can you call a procedure from trigger in Pl/Sql

but how to call java program from PL/SQL Trigger? - i know we can call a java profram from function and procedure but how to call java program from PL/SQL Trigger? can any one give an example

query list of connected users to MySQL DB? - Does anyone know how to query the database within a java to display a list of users who have connections to the database?

How to bind jtextfield to Query result or List in EL sinta.. - Hello, I ask for help from a kindly issue. I must connect (binding) a jtexfield directly to a resultset that returns a list of objects (List)with NetBeans 6. I tried this: Object source: Query result Binding expression: $(resulList [1]. Name) But..
   Database Forums (Home) -> Java All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]