Jasper 4.2: com.mysql.jdbc.Driver problem

0

 We installed jasperserver 4.2 and we imported the reports. We want to run the reports on jasperserver we get the following error:

com.jaspersoft.jasperserver.api.JSExceptionWrapper: com.mysql.jdbc.Driver

We installed the mysql connector: "mysql-connector-java-5.1.18" in the.."/buildomatic/conf_source/db/mysql/jdbc/" directory. 

The datasource is defined as: 

Driver: com.mysql.jdbc.Driver

url: jdbc:mysql://localhost/im8

When I test this in jasperserver I get the message "connection failed".

When I test this in iReport de "connection test was succesfull"

 

Can anyone help me?

swenf's picture
11
Joined: Aug 14 2009 - 5:42am
Last seen: 2 weeks 9 hours ago

2 Answers:

1

I'm not exactly sure how you installed JasperServer. But the MySQL JDBC driver issue can be a little confusing. However, if you JasperServer is already up and running, then (in the case of Tomcat 6 or 7) you can copy a mysql jdbc driver to:

 

<tomcat>/lib

tkavanagh's picture
1106
Joined: Jul 7 2006 - 8:54am
Last seen: 1 month 2 weeks ago
0

 This works. Thans

swenf's picture
11
Joined: Aug 14 2009 - 5:42am
Last seen: 2 weeks 9 hours ago
Feedback