prepared or general statement in JDBC

[Rajaram csse]

which one is heavier prepared / Statement
what about the maximum number of queries that could be run per connection in JDBC.

[Shailesh Chandra]

Did you try searching on web this first hit on web

both have different purpose and this is written on asktom

The use of a Statement in JDBC should be 100% localized to being used for DDL (ALTER, CREATE, GRANT, etc) as these are the only statement types that cannot accept BIND VARIABLES.

PreparedStatements or CallableStatements should be used for EVERY OTHER type of statement (DML, Queries). As these are the statement types that accept bind variables.

This is a fact, a rule, a law -- use prepared statements EVERYWHERE. Use
STATEMENTS almost no where.

about the maximum number of queries there is no practicle limit


Shailesh
[ June 19, 2006: Message edited by: Shailesh Chandra ]