Re: Java Stored Procedures

From: x <x_at_x.hr>
Date: Wed, 18 Feb 2004 09:00:39 +0100
Message-ID: <c0v5vo$bth$1@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 - 02:00:39 CST