Birt WebViewer Deployment - Driver not found

s_^_s

Hi Experts,<br />
<br />
I had developed some reports (using connection profile) on my windows machine and had then copied them into the Birt WebViewerExample tomcat application running on windows machine - it worked.<br />
Then I moved the same WebViewerExample app onto a linux machine.<br />
In the connectionProfileStore, I changed the path of jarlist to be correct on the linux environment. <br />
On the linux machine, 'tomcat' user is the owner of this file and the jarlist is accessible to 'tomcat':<br />
<br />
Now it says : class not found com.mysql.jdbc.Driver<br />
I had put fully qualified path as jarlist in the connection profile, but that didn't work.. I also tried many different relative paths but to no avail..<br />
Kindly guide.. <br />
Below is the stack trace, then my connection profile<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
WARNING: Unable to open a connection with the database connection profile.
org.eclipse.datatools.connectivity.oda.OdaException ;
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:113)
</pre>
<br />
Here's the connection profile<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<DataTools.ServerProfiles version = "1.0">
<profile autoconnect = "No" desc = "" id = "964e2101-81c4-11df-9fae-fa968b4ddc53" name = "cpdefault" providerID = "org.eclipse.datatools.enablement.mysql.connectionProfile">
<baseproperties>
<property name = "org.eclipse.datatools.connectivity.db.connectionProperties" value = ""/>
<property name = "org.eclipse.datatools.connectivity.db.savePWD" value = "true"/>
<property name = "org.eclipse.datatools.connectivity.drivers.defnType" value = "org.eclipse.datatools.enablement.mysql.5_1.driverTemplate"/>
<property name = "jarList" value = "/var/lib/tomcat5/webapps/WebViewerExample/mysql-connector-java-5.1.12-bin.jar"/>
<property name = "org.eclipse.datatools.connectivity.db.username" value = "dbuser"/>
<property name = "org.eclipse.datatools.connectivity.db.driverClass" value = "com.mysql.jdbc.Driver"/>
<property name = "org.eclipse.datatools.connectivity.db.databaseName" value = "mydbname"/>
<property name = "org.eclipse.datatools.connectivity.driverDefinitionID" value = "DriverDefn.org.eclipse.datatools.enablement.mysql.5_1.driverTemplate.MySQL JDBC Driver"/>
<property name = "org.eclipse.datatools.connectivity.db.password" value = "dbpwd"/>
<property name = "org.eclipse.datatools.connectivity.db.version" value = "5.1"/>
<property name = "org.eclipse.datatools.connectivity.db.URL" value = "jdbc:mysql://localhost:3306/mydbname"/>
<property name = "org.eclipse.datatools.connectivity.db.vendor" value = "MySql"/>
</baseproperties>
<org.eclipse.datatools.connectivity.versionInfo>
<property name = "server.version" value = "5.0.0"/>
<property name = "technology.name.jdbc" value = "JDBC"/>
<property name = "server.name" value = "MySQL"/>
<property name = "technology.version.jdbc" value = "3.0.0"/>
</org.eclipse.datatools.connectivity.versionInfo>
<driverreference>
<property name = "driverName" value = "MySQL JDBC Driver"/>
<property name = "driverTypeID" value = "org.eclipse.datatools.enablement.mysql.5_1.driverTemplate"/>
</driverreference>
</profile>
</DataTools.ServerProfiles>
</pre>
<br />
FYI: Had also mentioned same problem in Eclipse forum but awaiting response there. So please pardon the duplicity. <br />
<a class='bbc_url' href='http://www.eclipse.org/forums/index.php?t=rview&goto=543563'>http://www.eclipse.org/forums/index.php?t=rview&goto=543563</a><br />
<br />
Thanks<br />
Sebastian<br />
<br />
Someone please help !!<br />
<br />
FYI: This WebViewer came with Birt Runtime 2.5.2<br />
<br />
900+ views but no replies !! Atleast tell me what's wrong with this post that's discouraging any replies so that I can improve it

Linda Chan

Hi Sebastian,

Assuming it is not a file access permission problem with the JDBC jar file, it could be that the driver definition used has defined an incorrect jarList property value.
Look for the driver definition file under the Eclipse workspace in your deployment j2ee container:
<Eclipse_workspace>/.metadata/.plugins/org.eclipse.datatools.connectivity/driverStorage.xml
In the file, look for the driver definition entry that your profile has referenced:
"DriverDefn.org.eclipse.datatools.enablement.mysql.5_1.driverTemplate.MySQL JDBC Driver"
and update its jarList property value as appropriate.

Basically, if the driver definition referenced by a connection profile is found, its jarList property value gets used. Otherwise, the jarList property specified directly in the profile got used instead. The idea is to be able to share a common driver definition among multiple profile instances. So updates only need to be made directly on the shared driver definition, vs. in each profile.

Hope that helps.
Linda