File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Prepared Statement Compilation Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Prepared Statement Compilation" Watch "Prepared Statement Compilation" New topic

Prepared Statement Compilation

Josweth Reddy
Ranch Hand

Joined: Nov 02, 2005
Posts: 30
Hai ,
We know that PreparedStatement is a precompiled statement..
But who provides the implementation for the compiled PreparedStatement
I mean as it is in "java.sql" ,Will java compiles and provides the implentation??.

Please clarify...

Thanking you,
Josweth Reddy
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
Actually, the PreparedStatement Java object is (usually) not the compiled SQL statement itself. Instead, it contains a handle or reference to the compiled statement that exists within the database itself. The major possible exceptions to this are embedded Java databases (where the PreparedStatement implementation mighthold the compiled SQL statement), and database drivers that don't support true compilation (where PreparedStatement is implemented as a wrapper class around Statement).

It's the driver writer's responsibility to get all this right; you just have to get the right driver for your database.
I agree. Here's the link:
subject: Prepared Statement Compilation
It's not a secret anymore!