Win a copy of Micro Frontends in Action this week in the Server-Side JavaScript and NodeJS forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Paul Clapham
  • Bear Bibeault
  • Jeanne Boyarsky
Sheriffs:
  • Ron McLeod
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Jj Roberts
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • salvin francis
  • Scott Selikoff
  • fred rosenberger

JDBC and Stored Procedure

 
Ranch Hand
Posts: 92
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

May I know about the different ways in JDBC for retrieving data from the database without using Stored Procedure / 'PL/SQL'?

Thanks & Regards

Prithiraj Sen Gupta
 
Rancher
Posts: 43016
76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Umm, the SQL SELECT statement?
 
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm not completely clear on your question, but are you referring to things that you can do in VB for example like simply specifying a table name instead of a complete SQL SELECT statement? If so, then no. JDBC requires that you actually execute SQL statements.

Hibernate (http://www.hibernate.org) is a framework that allows you do object/relational mapping from Java. It has a number of different ways that you can get data from the database.

Not sure if I understood your question right, but I hope this helps.
 
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Statement and PreparedStatement objects can be used to retrieve data from the database.
 
Prithiraj Sen Gupta
Ranch Hand
Posts: 92
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I know that to retrive data from database one should write Stored Prcocedures. But there are some other ways to do it. Bear Bibeault, Moderator of Html and JavaScript, told me that he dont uses stored procedure. He adviced me to Post a topic here. The discussion between With Him can be found HERE.

Thanks & Regards

Prithiraj
 
Ulf Dittmer
Rancher
Posts: 43016
76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I know that to retrive data from database one should write Stored Prcocedures.


How have you come to know that? Whether that's true or not depends a lot on the circumstances of the application. It's definitely not a case of "should do".
 
Prithiraj Sen Gupta
Ranch Hand
Posts: 92
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry, I meant

I knew

not

I know

 
Prithiraj Sen Gupta
Ranch Hand
Posts: 92
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you let me know any other way of retrieving.
 
Marshal
Posts: 70384
283
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have been doing a bit of Databases, and people recommend stored procedures because they can be reused. You get a stored procedure which reads likeWhat that does is to encapsulate the query into a procedure. If you miss out the encapsulation you can use the line starting SELECT on its own, followed by ";" or whatever your database uses as a line terminator.
[ May 01, 2007: Message edited by: Campbell Ritchie ]
 
Prithiraj Sen Gupta
Ranch Hand
Posts: 92
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes I know about stored procedures. But I want to know about alternate ways.

Thanks & Regards

Prithiraj Sen Gupta
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Alternate ways? Hasn't Ulf already answered that?

Originally posted by Ulf Dittmer:
Umm, the SQL SELECT statement?

 
You can thank my dental hygienist for my untimely aliveness. So tiny:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic