Jump to content
Changes to the Jaspersoft community edition download ×

Jasperserver database configuration troubles


Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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...