I'm on a project where in I have a all the business logic and the tranasactions in the stored procs and we have COM components that call the stored procedures and scripts(ASP) to call COM components.
We are planning to do the same using J2EE...I'm looking for inputs regarding the design of this.
Where to call Stored procedures from....etc...
Thanks in advance...
suzi su
-
Stored Procedures (2 messages)
- Posted by: Madhavi Gupta
- Posted on: January 05 2001 13:03 EST
Threaded Messages (2)
- Stored Procedures by Doan LyDuc on January 07 2001 19:59 EST
- Stored Procedures by Madhavi Gupta on January 08 2001 11:24 EST
-
Stored Procedures[ Go to top ]
- Posted by: Doan LyDuc
- Posted on: January 07 2001 19:59 EST
- in response to Madhavi Gupta
Hi,
You can call the stored procedure from any java program: eg EJB, Servlet, applet: Using JDBC.
JDBC support CallableStatement.prepareCall() to register a stored procedure, register in,Out parameter. . . .
Hope this will hepl -
Stored Procedures[ Go to top ]
- Posted by: Madhavi Gupta
- Posted on: January 08 2001 11:24 EST
- in response to Doan LyDuc
HI,
thanks a lot for ur resposne...
u suggest i should call stored procs from session beans and use JSP in place of scripts????
OR use entity beans instaeda of stored procs???
Any help is very much appreaciiated...
Tx,
Su