JDBC and Stored Procedure

[Prithiraj Sen Gupta]

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

[Ulf Dittmer]

Umm, the SQL SELECT statement?

[Jeff Ash]

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.

[Suman Sharma]

Statement and PreparedStatement objects can be used to retrieve data from the database.

[Prithiraj Sen Gupta]

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]

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]

Sorry, I meant

I knew

not

I know

[Prithiraj Sen Gupta]

Can you let me know any other way of retrieving.

[Campbell Ritchie]

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 like

CREATE PROCEDURE member_by_number (IN number INT)
LANGUAGE SQL
SELECT name, address FROM members WHERE members.number = number
;

What 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]

Yes I know about stored procedures. But I want to know about alternate ways.

Thanks & Regards

Prithiraj Sen Gupta

[Paul Sturrock]

Alternate ways? Hasn't Ulf already answered that?

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