Forums Register Login

Not clear about PreparedStatement

+Pie Number of slices to send: Send
Can anyone please clarify whats exact difference between a Statement and a PreparedStatement?? From what i can understand Statements are parsed and compiled every time it is executed while PreparedStatement is precompiled. Does that mean that if same querry is executed by multiple clients at different instances of time and if it is executed using PreparedStatement it will not be parse compiled for each client request?? Is this a guranteed behaviour across different JDBC drivers and databases??
+Pie Number of slices to send: Send
Yes, you are correct regarding prepared statements.
All of life is a contant education - Eleanor Roosevelt. Tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1165 times.
Similar Threads
What exactly we mean by Precompiled SQL Statement
Prepared Statements
statement Vs prepared statement for ordinary select queries
PreparedStatement
Queries regarding PreparedStatement
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 19, 2024 00:58:02.