• Post Reply Bookmark Topic Watch Topic
  • New Topic

Stored Procedures and EJB

 
suzi lu
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Mark Herschberg
Sheriff
Posts: 6037
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Something like was was recently dscussed at:
http://www.javaranch.com/ubb/Forum15/HTML/000056.html
--Mark
hershey@vaultus.com
 
suzi lu
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I saw the discussion that u directed me to, but that didn't make much sense to me...Can you pl give some inputs specific to my problem??
Tx,
Suzi
 
suzi lu
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Can some body help me with this...
Tx,
Suzi
 
Jim Baiter
Ranch Hand
Posts: 532
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
suzi lu
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Mark Herschberg
Sheriff
Posts: 6037
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
hershey@vaultus.com
 
suzi lu
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi can some body come up with some design suggestions?
Tx,
Suzi
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!