Create mssql trigger from java program

Question

Is it possible to create a trigger from java using mssql jdbc driver?

I am having one audit trigger which is saved in a .sql file. The UI will show all the tables available in client db. Sometimes they need to enable the auditing for some specific tables, so I need to run the sql script by replacing the table name with the user selected one. The client needs this to be achieved from our java software. As I am new to JDBC, I am unable to figure this out. Any better ideas/help appreciated

yes, it is possible, just run create trigger as ordinary query — Iłya Bursov
– Iłya Bursov, Commented Sep 3, 2014 at 7:01

Community · Accepted Answer · 2017-05-23 12:29:29Z

0

Execute trigger creation SQL as a plain query. You may also need to wrap the SQL with exec('...') as mentioned in: https://stackoverflow.com/a/951956/92063

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Sep 3, 2014 at 7:05

heikkim

2,9852 gold badges25 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create mssql trigger from java program

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related