XPost: comp.databases.oracle.server, comp.lang.java.databases   
   From: me@my-deja.nospamcom   
      
   "Carlos"  wrote in message   
   news:1de5ebe7.0402160123.3bbc8557@posting.google.com...   
   > "Hawkeye"  wrote in message   
   news:...   
   > > I am investigating the Java Stored Procedure, first to gain better   
   > > understanding on what this is,   
   > > and also if it would be suitable for a new project which will be running   
   on   
   > > Sun One AS7   
   > > (Client is Swing)   
   > >   
   > > I have spent about a day reading through many docs, mostly in Oracle   
   site   
   > > and also the   
   > > past newsgroup discussions. Still, I am not clear really on who this   
   Java   
   > > Stored Proc   
   > > technology is intended for. Most of the example are toy examples really.   
   > > Any consensus on who this technology is aimed at and who should really   
   be   
   > > using it?   
   > >   
   > >   
   > > Would you use Java Stored Proc and have it contain lots of JDBC calls   
   inside   
   > > it and have it be   
   > > called either by a client or a EJB session bean?   
   > >   
   > > Any info based on experience  would be helpful   
   > >   
   > > THANKS   
   >   
   > The power of including java in the DB is difficult to explain but easy   
   > to understand for those who know Oracle and have experience in working   
   > on it. Basicaly, it opens a new world of functionalities that can be   
   > implemented inside the database just there, where PL/SQL lacks.   
   > It DOES NOT NEED to make JDBC calls to work, it can work without them   
   > (nevertheless, the built-in JDBC driver works quite fast).   
   >   
   > I will give you an example that is currently working OK in our DB:   
   >   
   > We needed a CRC to secure output XML files. Did we progammed a PL/SQL   
   > code to implement it? No. We used a java class that does it for us   
   > (CRC) and loaded it into the DB. Then we wrapped the class in a PL/SQL   
   > package and now we can call for the CRC for any object we need   
   > (varchar, clob, etc...). It took us 20 minutes all the process.   
      
   Does your java code contain any calls to the DB? if so, does it use JDBC   
   and/or SQLJ?   
   Or is it just java "helper" code   
      
   >   
   > Note that this is how many built-in Oracle procedures are stored.   
   >   
   > Regards.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)