If you are using oracle 10 with OC4J then I reckon the best approach is to keep the business logic in PL/SQL stored procs and create for them web-services via Jdeveloper; this is a point and click process.
Once you have a web-services interface then you can the stored procs directly from the cocoon sitemap. Have a look at the Web Site Syndication block for examples on how to call the web services. There are a few bugs in this block so check my earlier post for easy work-a-rounds. Regards Calum Miller --- birdy <[EMAIL PROTECTED]> wrote: > I think I have been round this loop but with mysql. > As my simple needs > increased so my approach changed. If you invest the > time to learn hibernate > www.hibernate.org you will unlock a powerfull > mechanism to be able to access > a database through beans. Once you have a bean you > can easly integrate the > bean into Cocoon using XSP's, Flow script, or > CForms. I know this does not > directly answer your question, but the more you > invest up front the you will > realise the power of technologies such as Cocoon. > > If you don't want to go hibernate for a quick > method, look at the SQL > Transformer. The beauty of hibernate is that it > allows you to build 3 tier > applications with clear seperations between database > buisness logic and > presentation. > > Gareth. > > ----- Original Message ----- > From: "Schultz, Gary - COMM" > <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, August 06, 2004 9:01 PM > Subject: Cocoon and Oracle > > > > I know to develop something that will grab data > from a table in Oracle and > > display results in a table in a web page. I can go > the PHP route and have > it > > done in a very short period of time. But I would > like to start learning > > about and working with Cocoon and databases. > Problem is, I can't seem to > > find resources to cover everything I need to learn > on Cocoon and > databases. > > > > Where are the best resources to learn about > working with Cocoon and > > databases. I've looked at a great deal of > documentation, but I don't seem > to > > find something complete enough to help me get > started and I'm having > > difficulty putting different pieces together. > > > > As I said earlier in this message, I could just > use PHP and be done with > it, > > but I would like to give Cocoon a try. I need to > get a project done > > relatively soon, and if I can't do it in Cocoon I > will be forced to use > PHP > > which becomes a set back to learning more about > Cocoon. > > > > Any direction is greatly appreciated. > > > > Gary T. Schultz > > Web Technical Administrator / GIS Coordinator > > Wisconsin Department of Commerce > > 6th Floor > > P.O. Box 7970 > > Madison, WI > > 1-608-266-1283 > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
