We have SQL Server here and this is what I found out when looking to do something similar. In order to do what you want you need to install the java extensions when the DB is installed. They may be able to be added later, I am not positive. SQL Server does NOT support java extensions, that whole Microsoft, java thing... You can still use extensions written in C++ though... Charles R. Backman Programmer/Web Developer James Tower Media Design 1730 James Drive North Mankato, MN 56003 507.386.9381 http://www.jtmd.com/ [EMAIL PROTECTED] -----Original Message----- From: Belinda Sloan [mailto:[EMAIL PROTECTED]] Sent: Friday, October 20, 2000 10:39 AM To: [EMAIL PROTECTED] Subject: Offtopic: invoke java from SQL Server DB extended stored proc Apologies for posting this here - I have searched high and low and posted questions to on-topic lists (Advanced Java and MS SQL Server sites) without response. I need to invoke a java pgm from a SQL Server 7.0 extended stored procedure. >From what I have found, it seems possible to invoke a C++ DLL from the same; but no talk of Java. Perhaps I should just call the java pgm from a C++ DLL and use this way of doing it? To provide more info: Certain events complete successfully on our database. We then need to send some Messages out to clients. In order to do this, we must invoke the Java pgm that will create a Message (an object with a listener attached) will be picked up by a MessageListener class. From there it's plain sailing. If you know where I could find this info / if you have an example of the above, it would be much appreciated. Thanks in advance, Belinda ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
Re: Offtopic: invoke java from SQL Server DB extended stored pro c
Backman, Charles R. (James Tower) Fri, 20 Oct 2000 10:00:52 -0700
