aspose file tools*
The moose likes JSF and the fly likes Doubts in stored procedure use in visual jsf Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSF
Bookmark "Doubts in stored procedure use in visual jsf" Watch "Doubts in stored procedure use in visual jsf" New topic
Author

Doubts in stored procedure use in visual jsf

nkarthi123
Greenhorn

Joined: Nov 26, 2008
Posts: 13
hello,
how to use mysql stored procedure used in visual jsf
Bauke Scholtz
Ranch Hand

Joined: Oct 08, 2006
Posts: 2458
JSF is just a component based MVC framework, not some database access API. Consult the documentation of the database access API which you're using.
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16233
    
  21

"nkarthi123",

Welcome to the JavaRanch. We don't have many rules here at the JavaRanch, but we do insist that you use you Real Name and not some sort of "handle" or obvious alias. If you're not sure about this, see http://www.javaranch.com/name.jsp .

Stored Procedures are a very useful and powerful thing, but all too often they're abused. I've got an app right now that has to run on 2 different OS's because the database part is all done in Microsoft SQL Server stored procedures. Microsoft doesn't do SQL Server for Linux, I can't keep the database on the Linux box - I have to keep a second machine running Windows just for the database. Converting the stored procedures so I could use an OS-agnostic DBMS like MySQL or Oracle would be cost-prohibitive.

On top of that, the program is a <censored> to maintain. About half the program logic isn't even in the program - it's in the database.


Customer surveys are for companies who didn't pay proper attention to begin with.
 
 
subject: Doubts in stored procedure use in visual jsf