Re: Java Stored Procedures

What is the DB you need to connect to? I work for an ODBC Driver vendor (Openlink Software) and we are used in Oracle HS on a regular basis. The drivers can be less expensive than you might think. Visit our Website www.openlinksw.com , Or email me directly if you need any answers.

"x" <x_at_x.hr> wrote in message news:<c0v5vo$bth$1_at_ls219.htnet.hr>...
> I read somewhere in documetation that PL/SQL is better for
> database-intensive operations, and JSP for logic-intensive operations.
>
> I can tell you what I use JSP for. We have some XML exchange with our
> vendors. Every time new order is created, trigger calls JSP that creates XML
> and sends it to servlet on Apache/Tomcat server (outside firewall) which
> forwards XML to our vendors. With java classes, it's very easy to program
> things like that. Possible that it can be done with PL/SQL, but this way
> it's easyer.
>
> Right now, I'm planing to connect my oracle with non-oracle database. Since
> I'm on UNIX, lack of ODBC driver prevents me from using heterogeneous
> connectivity. I'm trying to load JDBC driver for this non-Oracle database,
> and connecto to it through JSP.
Received on Wed Feb 18 2004 - 21:19:25 CET