Jump to content

Where to put JDBC driver jars or add to path?


Recommended Posts

 I am using the standalone Jaspersoft Studio (rather than the Eclipse plugin) and want to connect to set up a data source for MySQL.

I already have various JDBC drivers for MySQL and am familiar with setting up drivers in Eclipse. In the standalone Studio the options under Preferences:Java:Build Path:User Libraries looked familiar enough. I added a user library and added the mysql-connector jar to it. However, I still get a class not found error when I try to create a new Data Adapter for MySQL and test it.

What is the correct way to add a JDBC driver to the JasperSoft Studio classpath?


Link to comment
Share on other sites

  • Replies 5
  • Created
  • Last Reply

Top Posters In This Topic

Thanks for the reply. I missed the "Driver Classpath" tab in the Data Adapter dialog. Obvious really!

It would still be useful to add the driver to the classpath so it is always available. The only thing I could find which looks anything like the standard Eclipse way was in Preferences as I mentioned above. Can you be more specific about where to set this up?

Stacktrace attached.


Link to comment
Share on other sites

  • 3 months later...

the standard eclipse way to add jars to classpath, is to use Project Properties, Java Build Path pages

right click on you project, on the bottom you have Properties, go to "Java Build Path" pages, the best way is to create a lib folder inside your project and put there your drivers, in this way you can share your configuration on CVS, SVN, GIT, etc.

you can also have classpath settings for each DataAdapter, in this case you have to use paths relative to your current filesystem


Link to comment
Share on other sites

  • 5 years later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...