Interested to Buy Any Domain ? << Click Here >> for more details...
How we say that PreparedStatment is Precompiled? where it
will be compiled?
- 4 Answers
- 7052 Views
- Logica CMG, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / venkatesh.t
prepared Statements are compiled at database server side.
Once the statement is passed to the database the Statement
is parsed for validness and checked weather the table exist
or not .if the statement is valid the server holds the
statement object and process the multiple request from the
client.
Finally parsing of the statement is done at server side that
to only once.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / dsr
When ever call the preparedstatement at firsttime,at that
time, the statement will be parsing as a query string and
create the object. This function will be doing in
serverside.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / natraj
Hi,
In parsings there are two types.One Hard Parsing and second
is softparsing. Firt time hard parsing will happen.That
means wheather this query is syntatically correct or not +
what is the table name,no of cols,what are the index for
that table,any sequences and foreign key related details
etc. , and firt time only hard parsing and after that it is
going to cache it at database side only,from next time
onwards only soft parsing that means only specified record
values it will retrive.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / paks chaudhary
prepared Statements are compiled at database server side.
Once the statement is passed to the database the Statement
is parsed for valid and checked weather the table exist
or not .if the statement is valid the server holds the
statement object and process the multiple request from the
client.
| Is This Answer Correct ? | 1 Yes | 0 No |
please tell me the name and url path for type-4 driver ?
What is JDBC Batch Processing and what are it’s benefits?
What is an encrypted internet connection?
How can we set null value in jdbc preparedstatement?
Statement, PrepareStatement and Callable all these are interfaces. Thought it is a interface how come we are creating objects and calling methods("preparestatement()") in it. In which class this method is defined. Please let me know. Thanks in advance. example: PreparedStatement pre = con.prepareStatement( "UPDATE COFFEES SET SALES = ? WHERE COF_NAME LIKE ?");
How do I check in my code whether a maximum limit of database connections have been reached?
Name the method, which is used to prepare a callablestatement.
What is sqlwarning and discuss the procedure of retrieving warnings?
how can we connect to db without using getConnection() method
How many categories of jdbc drivers are there?
what is JDBC?
There is a method getColumnCount in the JDBC API. Is there a similar method to find the number of rows in a result set?
Core Java 
