0

I am using jasper server CP 5.0.0. I have configured the data source properties like this

Set Data Source Type and Properties

Driver (required):com.mysql.jdbc.Driver
URL (required):jdbc:mysql://localhost:3306/jasperserver

The connection is failed when clicked on test connection

When I am running the report I am getting a error 

Error Message

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

Error Message
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Error Trace

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at

I have been searching this for a long time with no success.

BoJack Horseman
  • 4,406
  • 13
  • 38
  • 70
syncdm2012
  • 445
  • 2
  • 10
  • 22

1 Answers1

1

You should add mysql drivers jar file to the build path of your project.

Bhushan
  • 6,151
  • 13
  • 58
  • 91
  • Ok, I restarted the server with adding the jar file now I have the error.com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection and Error Message java.sql.SQLException: Access denied for user 'jasperadmin'@'localhost' (using password: YES) – syncdm2012 Jan 23 '13 at 09:29
  • this is because you are not providing password in mysql connection, provide username and password with connection string of mysql – Bhushan Jan 23 '13 at 10:13
  • there are so many questions asked for `...(using password: YES)` this error, so i will suggest you to refer to those questions on StackOverflow and if you still can't find solution then ask separate question for this exception – Bhushan Jan 23 '13 at 10:17
  • Thanks a lot guys.. u saved my day..It's just like 'talaash' the answer lies within.. – syncdm2012 Jan 23 '13 at 10:30