JDBC Driver jt400 Jasperserver

[pumaking]

Hello,

 

I'm new to Jasper*. I'm trying to improve our reporting and the things I have seen so far Jasper Reports/Server seems to be a good product to achieve this.

 

So, here's my problem. I succesfully installed and configured IReports and added the com.ibm.as400.access.AS400JDBCDriver driver with jt400.jar. So far no problem, everything works fine.

 

Now I want to add the driver to jasperserver. So I imported the datasource from Ireports to Jasperserver and saved a report to the server. When I run this report I get the error: java.lang.ClassNotFoundException: com.ibm.as400.access.AS400JDBCDriver

 

I tried to edit the mondrian.properties file as follows:

JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver,com.ibm.as400.access.AS400JDBCDriver;

Then I restarted Jasperserver but the error remains.

 

I also put the jt400.jar file in every lib directory I could find.

 

So I'm sure I'm doin something wrong because I'm new to this, perhaps you can tell me what it is ;-)

[jens_noering]

We are using jasperserver with the jt400 driver and everything works fine.

 

So it should'nt be a jasperserver problem.

 

Make sure you copied the driver in the /webapps/jasperserver/WEB-INF/lib

folder and that you restart jasperserver after that.

 

driver class name as you posted it. if that doesn't work maybe there is a problem with your jt400 driver version.

 

hth,

 

jens

[pumaking]

Great, thank you. I just didn't know where to put the jt400.jar file.