ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver

java jdbc jtds
Dark Matter picture Dark Matter · Sep 6, 2013 · Viewed 31k times · Source

I have java code which connects to a MS-SQL database and procures some data.

Before running the code I set the class path in the Unix Server and it used to work fine.

But for some reason the same jar file which was working a few days back is throwing a Class not found exception java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver

I have un-jared the jar file and found that the driver class which I'm loading : 

Class.forName("net.sourceforge.jtds.jdbc.Driver");

is present in the specified package structure.

I don't understand how this is happening.

Can anyone suggest any tips to resolve this.

Answer

Shamim Ahmmed picture Shamim Ahmmed · Sep 6, 2013

The issue of java.lang.ClassNotFoundException might be the outcome of several reasons:

  • Jar file is not available in class path. (This is not your case. as you have mentioned).

  • Your jar file is corrupted.

  • Your environment variable value is not accessible by current user. (Permission revoked by administrator).

  • Current user don't have permission to read jar file.

Please verify the last three options.

Related questions

Create a jTDS connection string

my sql server instance name is MYPC\SQLEXPRESS and I'm trying to create a jTDS connection string to connect to the database 'Blog'. Can anyone please help me accomplish that? I'm trying to do like this: DriverManager.getConnection("jdbc:jtds:…

Read More
What is the jTDS JDBC Connect URL to MS SQL Server 2005 Express

I'm trying to connect to a MS SQL Server 2005 Express database that is running on the local host from a java program. I have tried the same connect URL (below) that I used on another system (same jave code) that …

Read More
A ResourcePool could not acquire a resource from its primary factory or source

I'm trying to connect to a database in Java, using jdbcTemplate and I'm gettin the error below. I have Googled for a long time and all solutions I found didn't solve my problem. I tried several different DBs (both SQLServer …

Read More