The Artima Developer Community
Articles | News | Weblogs | Books | Forums
Artima Forums | Articles | Weblogs | Java Answers | News
Sponsored Link •

Java Answers Forum
How and where the statement compiled

1 reply on 1 page. Most recent reply: Aug 26, 2003 4:49 AM by Senthoorkumaran Punniamoorthy

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 1 reply on 1 page
Himanshu Gupta

Posts: 1
Nickname: injunscor
Registered: Aug, 2003

How and where the statement compiled Posted: Aug 26, 2003 3:18 AM
Reply to this message Reply
Advertisement
Hi,

1) I want to know ,where the statements(Normal statement,Prepared statement,Precompiled statement) get compiled.
2) Why prepared statement call as a precompiled statement.What is meaning of "precompiled" over here.
3) What is difference between normal statement,prepared statement and callable statement.
4) The driver load .dll/api in class.forname() for windows enviroment.

Regards
Himanshu


Senthoorkumaran Punniamoorthy

Posts: 335
Nickname: senthoor
Registered: Mar, 2002

Re: How and where the statement compiled Posted: Aug 26, 2003 4:49 AM
Reply to this message Reply
1) I want to know ,where the statements(Normal statement,Prepared statement,Precompiled statement) get compiled.

Senthoor>> if it is a callable statement its going to call a Stored Procedure and that’s compiled in the Database. Other than that according my knowledge I don't think anything else get compiled (of course when you compile the Java class you get a class file but I am sure you are not referring to that)

2) Why prepared statement call as a precompiled statement. What is meaning of "precompiled" over here.

Senthoor>> when you execute a SQL query in the back end a SQL plan will be created. When you use the PreparedStatement only the first time the SQL plan will be created and the next time it will use the already created plan. May be that’s why its called the Precompiled statement. But you have to be careful not to use any dynamic value in the query itself and rather you should use bind variables to achieve the same effect.

3) What is difference between normal statement,prepared statement and callable statement.

The difference is the reuse of SQL Plan

4) The driver load .dll/api in class.forname() for windows enviroment.

????

Flat View: This topic has 1 reply on 1 page
Topic: JFrame Previous Topic   Next Topic Topic: Apache Tomcat
Sponsored Links


Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use