General discussion


Microsoft JDBC Type - 4 drivers

We are converting our legacy application to run on Java. We use ODBC drivers shipped with SQL Server 2000 to connect to the database. On the java side we began to use JDBC type 4 drivers. WE noticed that the sql statements being sent over to the database via jdbc uses sp_executesql. There are significant spikes in performance. I profiled the database for both these drivers and found that we have severe performance hits when using JDBC. SQL Statements are not being cached when using JDBC drivers. Has anyone seen this behaviour? Is there some kind of property that allows caching of sql statements.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

i have the same problem

by cesar_forero In reply to Microsoft JDBC Type - 4 d ...

Hello, i have the same problem with jdbc, i liked to know what did you do to fix that problem.

Collapse -

Microsoft JDBC Type

by aparnat10 In reply to Microsoft JDBC Type - 4 d ...


can u please let me know how to access the database(SQL Server) using the Java application
I use jdk1.5.0_06 version and sql server 2000
while compiing it is not giving any error, but at the time of running the program i am getting an error

Kindly please help me....Its Urgent

The error is :-
"Exception in thread "main" java.lang.UnsupportedClassVersionError: database (Unsuppor
ted major.minor version 49.0)
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(
at Method)
at java.lang.ClassLoader.loadClass(
at sun.misc.Launcher$AppClassLoader.loadClass(
at java.lang.ClassLoader.loadClass(
at java.lang.ClassLoader.loadClassInternal(

Related Discussions

Related Forums