JDBC driver is not recognize sql server drives

Hi All

i'm tring to understand want i'm doing wrong , my steps are :

1.installing the jasper 5.1 server & IReport 

2.install the lateste JRE ( the current version is 7.21)

3.download the JDBC 4.0 version

4.coyied the sqljdbc4.jar file to the "Program Files\jasperreports-server-5.1\java\jre\lib\ext" folder

5.refresh tomcat & postgreSql services

6.tring to create a sql datasources connecting   with com.microsoft.sqlserver.jdbc.SQLServerDriver  

the drive selection item is in red color and i cannot create the datasource (getting a message that the drive is missing)



amit.barkai's picture
Joined: Feb 27 2013 - 8:33am
Last seen: 8 years 4 months ago

4 Answers:

you have to place the driver either in the tomcat director (sth. like <jasperserver-install>/apache-tomcat/lib/) or in the libs-dir of the webapplication (sth. like <jasperserver-install>/apache-tomcat/webapps/jasperserver/WEB-INF/lib/)

both should work

Cheers, Thomas


Thomas Zimmer's picture
Joined: Oct 2 2012 - 1:35am
Last seen: 2 days 21 hours ago

still having the same problem

i placed the sqljdbc4 file on:

1.Program Files\jasperreports-server-5.1\apache-tomcat\lib  ( on this folder there was another file sqljdbc-1.6-2206.100.jar)

2.Program Files\jasperreports-server-5.1\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib

3.Program Files\jasperreports-server-5.1\java\jre\lib\ext

and still i cannot create a datasource for sql server


amit.barkai's picture
Joined: Feb 27 2013 - 8:33am
Last seen: 8 years 4 months ago

it finally worked !!

i guess the last step fixed the problem ,

just did the most common thing that fixes all problems ... restart :) 

thanks for the help


amit.barkai's picture
Joined: Feb 27 2013 - 8:33am
Last seen: 8 years 4 months ago

sorry I forgot to say, that you have to restart the application server after including the libs ... :-)

Thomas Zimmer - 9 years 10 months ago

Yep.. Actuallly restarting tomcat is needed. That process is described here: http://community.jaspersoft.com/wiki/connecting-jasperreport-server-your... and since the driver is in the tomcar/lib folder it will allow you to create JNDI connections which have better performance since they benefit from the application server connection pooling.

Also is important to note that since you are using 5.1 there is a new feature that allows you to upload and dynamically use JDBC drivers from the Jasperserver UI. You need to be logged in as a superuser and you have the option to add drivers when you create your datasource. The process is described in the JasperServer Admin Guide Chapter 4.1 (section 4.1.2) http://community.jaspersoft.com/documentation

marianol's picture
Joined: Sep 13 2011 - 8:04am
Last seen: 4 years 5 months ago