Jasperserver database configuration troubles

[2006 IR Open Dicussion]

By: mrr_zeus - mrr_zeus

Jasperserver database configuration troubles

2006-05-22 17:37

Hey Peoples,

 

I'm attempting to setup the Jasper Reports Server as outlined @ http://jasperintel.sourceforge.net/index.php?p_module=page&pageid=44

 

In my case, I need to change the database driver and settings found in context.xml and the hibernate dialect to match our in-house projects database.

 

Stats:

 

Tomcat 5.5.x

Jasperserver 0.9.2

JKD 1.4.2_05-b04

Microsoft SQL Server 2000

JTDS JDBC Type 4 Driver 1.2

 

Outlined below are my current settings for both:

 

~~Context.xml~~

<Context path="/jasperserver" docBase="jasperserver"

debug="5" reloadable="true" crossContext="true">

 

<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"

maxActive="100" maxIdle="30" maxWait="10000"

username="liuser" password="Us3rLI!" driverClassName="net.sourceforge.jtds.jdbc.Driver"

url="jdbc:jtds:sqlserver://htn755sql1.cce.cpqcorp.net:2048/LI"/>

</Context>

 

~~Hibernate.properties~~

metadata.hibernate.dialect=org.hibernate.dialect.SQLServerDialect

metadata.hibernate.dataSource.jndiName=jdbc/jasperserver

 

After applying these changes we rebundle the war and deploy to our Tomcat server. The following exceptions result:

 

May 22, 2006 4:18:35 PM org.apache.catalina.startup.HostConfig deployWAR

INFO: Deploying web application archive jasperserver.war

16:18:41,257 WARN JDBCExceptionReporter,ContainerBackgroundProcessor[standardEngine[Catalina]]:71 - SQL Error: 0, SQLState: null

16:18:41,264 ERROR JDBCExceptionReporter,ContainerBackgroundProcessor[standardEngine[Catalina]]:72 - Cannot load JDBC driver class 'net.sourceforge.jtds.jdbc.Driver'

16:18:41,269 WARN SettingsFactory,ContainerBackgroundProcessor[standardEngine[Catalina]]:103 - Could not obtain connection metadata

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'net.sourceforge.jtds.jdbc.Driver'

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)

...

...

...

 

We've verified that the JTDS driver has been bundled and deployed by checking the webapps/jasperserver/WEB-INF/lib directory.

 

We also use this same driver with to configure DBVisualizer to talk with our DB and that works just fine.

 

The exception would lead one to believe the apps having problems locating the database driver but that doesn't seem to be the case.

 

We were hoping someone out there with a bit more JasperServer experience may see something we miss before we take the deep dive into the code.

 

Any thoughts? Ideas?

 

Thanks much in advance.