Software

Ask something
Discussion Locked

Microsoft JDBC Type - 4 drivers

0 helpful
2 replies

by orasu

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

2 replies

by aparnat10

hi

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(ClassLoader.java:493)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:111)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:248)
at java.net.URLClassLoader.access$100(URLClassLoader.java:56)
at java.net.URLClassLoader$1.run(URLClassLoader.java:195)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:286)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
"

This discussion is closed to new replies.