Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CallableStatement vs PreparedStatement.

843854Nov 28 2001 — edited Nov 28 2001

I've been working with callable statements for a project with a SQL server 2000 database.
I had to change all those callable statements to prepared statement.

The time to excute the project is way less with the prepared statement (22s vs 50s).

The database is small but with a lot of tables (80), and i had the same amount of stored procedures.
My JDBC driver is from Microsoft (a beta version of the Merant one).

Does anyone know why the prepared statements are faster ??

Thanks.

C�dric.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 26 2001

Added on Nov 28 2001

#java-database-connectivity-jdbc

1 comment

188 views