This week's book giveaway is in the Cloud/Virtualization forum.
We're giving away four copies of Kubernetes in Action and have Marko Luksa on-line!
See this thread for details.
Win a copy of Kubernetes in Action this week in the Cloud/Virtualization forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Doubts in stored procedure use in visual jsf  RSS feed

 
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello,
how to use mysql stored procedure used in visual jsf
 
Ranch Hand
Posts: 2458
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Bartender
Posts: 18898
78
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!