how to call a java method using jdbc in sql server 2008 using a trigger event (insert/update)?

Question

as the questions says I want to call a java method/function when a register in the SQL Server 2008 is inserted or updated so i can process the info through java. Is there a way to do this?? For the moment I'm polling the database every 5 seconds for changes in bit fields (false to true), but I'm having problems with excessive memory usage due to queries. Any help would be appreciated. Thanks in advance

Stephen C · Accepted Answer · 2011-12-10 02:24:08Z

1

Is there a way to do this??

I think that the answer is No.

JDBC doesn't provide any way to do callbacks from the database into the JDBC client, so the only option would be to run the Java in the database server. I don't think you can do that with SQL Server.

answered Dec 10, 2011 at 2:24

Stephen C

723k95 gold badges849 silver badges1.3k bronze badges

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

Comments

Chip McCormick · Accepted Answer · 2011-12-10 02:27:11Z

1

Not really. Triggers are built into the database server and can't call to external code unless the database supports that. Not suprisingly SQL Server doesn't have that kind of integration with Java.

PL/SQL and Java on the other hand would work.

answered Dec 10, 2011 at 2:27

Chip McCormick

7444 silver badges17 bronze badges

1 Comment

Roberto Over a year ago

Thanks anyway, i guess i'll stick with polling the database

Collectives™ on Stack Overflow

how to call a java method using jdbc in sql server 2008 using a trigger event (insert/update)?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related