Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL server 7.0 and Java

 
Saima Khan
Greenhorn
Posts: 6
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello All,
Is there any way to fire a triger to a Java Application throug a SQL server 7.0 when a database goes below certain value .Higly appreciate if any body have any experience .
Saima
 
Tina Coleman
Ranch Hand
Posts: 150
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There's a concept of an extended stored procedure, which is essentially a DLL that you write that SQL Server can execute. You would then write your trigger to execute the extended stored procedure if your condition was met, and your extended stored procedure would then trigger your Java code.
Unfortunately, I have no experience doing this sort of thing, so can't give you too much more info. But thought it was a direction worth looking into.
 
Saima Khan
Greenhorn
Posts: 6
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks a lot Tina.
I am not using the SQL server documentation for extended stored procedures.
Let's pray for me.

Saima
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic