This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes SQL server 7.0 and Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL server 7.0 and Java" Watch "SQL server 7.0 and Java" New topic

SQL server 7.0 and Java

Saima Khan

Joined: Jan 15, 2002
Posts: 6
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 .
Tina Coleman
Ranch Hand

Joined: Dec 12, 2001
Posts: 150
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

Joined: Jan 15, 2002
Posts: 6
Thanks a lot Tina.
I am not using the SQL server documentation for extended stored procedures.
Let's pray for me.

Have you checked out Aspose?
subject: SQL server 7.0 and Java
It's not a secret anymore!