home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,102 of 2,288   
   x to All   
   Re: Java Stored Procedures   
   18 Feb 04 09:00:39   
   
   XPost: comp.databases.oracle.server, comp.lang.java.databases   
   From: x@x.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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca