ClassNotFoundException when connecting to MS SQLServer using JDBC

Question

I'm trying to connect to a MSSQL using the MS JDBC Driver (Microsoft SQL Server JDBC Driver 3.0: http://www.microsoft.com/download/en/details.aspx?id=21599) but what every i do i get java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver when i run the project in Netbeans.

I am running Netbeans 7.1 on Windows 7 Enterprise 64-bit. I have gone through quite a few guides on the web on how to setup the MSSQL JDBC driver but I know I'm missing something. Does anyone have a fool/idiot proof guide to setting this up, I don't care how basic it is. I'm sure its something in my enviroment that isn't correct and I'm only just starting out with Java and Netbeans so I suspect I've overlooked something.

Check whether the Driver Jar file lies in your classpath.

Shashank Kadne
– Shashank Kadne

2012-02-23 06:05:46 +00:00
Commented Feb 23, 2012 at 6:05 — Shashank Kadne
– Shashank Kadne, Commented Feb 23, 2012 at 6:05

drew · Accepted Answer · 2012-02-23 06:09:40Z

6

You might have the package for the SQLServerDriver class incorrect. Try "com.microsoft.sqlserver.jdbc.SQLServerDriver" instead of "com.microsoft.jdbc.sqlserver.SQLServerDriver".

answered Feb 23, 2012 at 6:09

drew

1462 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

drew Over a year ago

Also as Shashank pointed out, ensure the sqljdbc4.jar or sqljdbc.jar are in your classpath.

Adam_B Over a year ago

Thanks a lot for that, it's got me over that hurdle, i knew it was going to be something simple.

drew Over a year ago

No problem! Another note... jar files are really just zip files. So if you change the extension to .zip, you can look inside and see the organization of the class structure. That's what I did in this case and I've never used this particular driver ;)

Deepak · Accepted Answer · 2012-02-23 06:17:43Z

3

I your project tree listing pane, under libraries see if the JDBC package is listed if not right click on the library node -> Add JAR/Folder. Then browse the right package from your computer and import it. I think this should solve the problem.

And as you asked this link might be helpful Creating a Simple Application Using MYSQL DB

edited Feb 23, 2012 at 6:17

answered Feb 23, 2012 at 6:11

Deepak

6,82718 gold badges71 silver badges121 bronze badges

Comments

Rem Sadikov · Accepted Answer · 2016-08-26 15:56:44Z

0

In NETBEANS add path in the Project properties -> libraries -> compile tab screen image -> [https://i.sstatic.net/g6BH3.jpg]

edited Aug 26, 2016 at 15:56

answered Aug 26, 2016 at 15:49

Rem Sadikov

415 bronze badges

Collectives™ on Stack Overflow

ClassNotFoundException when connecting to MS SQLServer using JDBC

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related