I'm on a project where in we have all the business logic and the tranasactions in the stored procs and we have COM components that call the stored procedures and client side scripts make calls to COM components. We are planning to migrate to the java platform and do all this using J2EE... Can we have the stored procs and make sssion bean scall these stored procedures or do we have to rewrite the sql code??? I'm looking for inputs regarding the design of this. Any design is welcome and I very much appreciate this. Thanks in advance... suzi lu
I don't really see the relevance of that link either. Yes, you can wrap stored procedure calls in session beans. To really move to J2EE however you will want to migrate out of the stored procs and into session & entity beans. But your idea of having session beans call the stored procs is a good first phase.
Hi, Thanks a lot for your response. I do understand that using session and entity beans is a good ides when migrating to J2EE...but i already have all the stored procedres written and I want to make use of those... Also, can entity beans handle all the data base transactions...i mean all the complex sql logic???Or is it that u want me to put all the logic using sql code in session beans??? Pl help me with more suggestions. Tx, Suzi
Ah, I misunderstood your question. The link I provided talked about how to implement something like stored proceedures in Java. You simply wanted to call through to pre-existing stored proceedures. --Mark firstname.lastname@example.org
Mark Herschberg, author of The Career Toolkit