amit.barkai Posted May 22, 2013 Share Posted May 22, 2013 Hi Alli'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 version4.coyied the sqljdbc4.jar file to the "Program Filesjasperreports-server-5.1javajrelibext" folder5.refresh tomcat & postgreSql services6.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)thanks Link to comment Share on other sites More sharing options...
Thomas Zimmer Posted May 22, 2013 Share Posted May 22, 2013 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 workCheers, Thomashttp://www.thomaszimmer.net Link to comment Share on other sites More sharing options...
amit.barkai Posted May 22, 2013 Author Share Posted May 22, 2013 still having the same problemi placed the sqljdbc4 file on:1.Program Filesjasperreports-server-5.1apache-tomcatlib ( on this folder there was another file sqljdbc-1.6-2206.100.jar)2.Program Filesjasperreports-server-5.1apache-tomcatwebappsjasperserver-proWEB-INFlib3.Program Filesjasperreports-server-5.1javajrelibextand still i cannot create a datasource for sql serverthasnks Link to comment Share on other sites More sharing options...
amit.barkai Posted May 22, 2013 Author Share Posted May 22, 2013 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 Link to comment Share on other sites More sharing options...
Thomas Zimmer Posted May 22, 2013 Share Posted May 22, 2013 sorry I forgot to say, that you have to restart the application server after including the libs ... :-) Link to comment Share on other sites More sharing options...
marianol Posted May 22, 2013 Share Posted May 22, 2013 Yep.. Actuallly restarting tomcat is needed. That process is described here: http://community.jaspersoft.com/wiki/connecting-jasperreport-server-your-database 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now