Jaspersoft Studio 6.2.0 Setting up Connection
Posted on November 27, 2015 at 10:41am
I am trying to set up a connection using the Data Adapter but to no avail.
Driver: sun.jdbc.odbc.jdbcOdbcDriver
I have a DNS set up to a db2 database(Has worked in iReport 2.3 and 5.6)
When I test I get ClassNotFoundException sun.jdbc.odbc.jdbcOdbcDriver cannot be found by net.sf.jasperreports_6.2.0.final
Joined: Nov 27 2012 - 2:51pm
Last seen: 3 years 7 months ago
Posted on November 28, 2015 at 11:54pm
This probably isn't a JasperReports problem but with the JDK. Oracle decided to drop jdbc-odbc bridge. You'll need to get a different jdb-odbc bridge. You'll be able to find them by googling.
Joined: Apr 24 2010 - 4:31pm
Last seen: 4 years 3 months ago
Posted on November 30, 2015 at 6:29am
I have the jt400.jar file but how do I get the JasperSoft Studio to see it?
Joined: Nov 27 2012 - 2:51pm
Last seen: 3 years 7 months ago
Posted on December 1, 2015 at 1:21pm
On the Data Adapter Dialog (once you select Database JDBC Connection) you can add the driver JAR path in the "Driver Classplath" tab.
Or you can add the jar to project classpath in a standard eclipse way, in this way driver will be visible inside your project
Joined: Sep 13 2011 - 8:04am
Last seen: 4 years 11 months ago
