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 Statement, PreparedStatement, CallableStatement 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 "Statement, PreparedStatement, CallableStatement" Watch "Statement, PreparedStatement, CallableStatement" New topic

Statement, PreparedStatement, CallableStatement

Tony Morris
Ranch Hand

Joined: Sep 24, 2003
Posts: 1608
The inheritance hierarchy for JDBC statements puzzles me a little.
Specifically, why would PreparedStatement and CallableStatement want to inherit some of the methods of Statement?

For example, I tried the following:

I tried code similar to the above with MS SQL Server 2000 driver, only to be given an exception.
Why does the JDBC API allow this behaviour?
Is there ever a reason why you'd do such a thing?
Is it a fair statement that some of the Statement methods should never be called on a PreparedStatement (and CallableStatement) instance?

Advice is most appreciated.

Tony Morris
Java Q&A (FAQ, Trivia)
I agree. Here's the link:
subject: Statement, PreparedStatement, CallableStatement
It's not a secret anymore!