Jasperserver as a windows service

[dgiulian]

Hi everyone,

I'm trying to run tomcat and mysql as a windows services, (to run jasperserver 3.5.0). Both of them start without problems, and I can login in jasperserver, but when I try to run a report (Using a JDBC datasource that I added) I get the following message:

com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection

...big stack explaining where de error came from...

Caused By:  (I think this is important)

java.sql.SQLException: No suitable driver found for jdbc:jdbcprogress:T:localhost:3236:hrs

Aparently jasperserver cannot find the jar file for the Progress JDBC Driver(located in "jasperServer_dir"\apache-tomcat\common\lib).

But the odd thing is that when I start Jasperserver using the startup shortcut I have no problem, and I can run the report correctly.

I have my JAVA_HOME set to "jaspersever_dir"/java.

 

Can anyone give me a hint to solve this issue? Thanks.

Post Edited by dgiulian at 09/23/2009 14:40