Using a third-party JDBC driver on iServer

Hello everyone, 
 
I design a report using BIRT RCP Report Designer (not a Professional). 
The report use a Microsoft SQL Server database as a data source so I've downloaded JDBC driver from Microsoft website and made it avialable in report design. Driver class is com.microsoft.sqlserver.jdbc.SQLServerDriver. Preview of the report works fine. 
 
The problem appears when I'm trying to run my report on iServer after deploying it. I get an error: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver. (Element ID:163)
</pre>
 
The BIRT and iServer documentation and forum suggest the only instruction: 
<pre class='_prettyXprint _lang-auto _linenums:0'>The iServer installation process installs and configures DataDirect Connect for
ODBC drivers and JDBC drivers. You can also use third-party drivers to connect
to data sources, but you must license, install, and configure them.
To connect BIRT reports to other JDBC data sources, place the .jar files for the
custom database driver in:
AC_SERVER_HOME\iServer\Jar\birt\platform\plugins
\org.eclipse.birt.report.data.oda.jdbc<version>\drivers</pre>
but that can't help me. I do place JDBC driver jar in different folders and restart iServer but there is no result. 
What am I doing wrong? 
Thanks! 
 
P.S. I'm using trial version of iServer for Windows.

Find more posts tagged with

Comments

RSiegler

Antilin,

Can you provide the path that the iServer is installed into on your machine?
Can you provide the path where you placed the jar file for your jdbc driver?

If it is in the correct spot, I would suggest opening a support case, but let's check to ensure that it is in the correct place first.

-Ryan

Antilin

iServer's home directory is Program Files\Actuate11SP3\iServer\ 
 
According to documentation I placed jdbc driver jar file in following folders: 
 
Program Files\Actuate11SP3\iServer\Jar\BIRT\platform\plugins\com.actuate.data.oda.jdbc.drivers_11.0.3.v20111028\ 
 
and 
 
Program Files\Actuate11SP3\iServer\Jar\BIRT\platform\plugins\com.actuate.data.oda.jdbc.drivers_11.0.3.v20111028\drivers (I had to create the folder drivers because there wasn't such folder that mentioned in documentation) 
 
and just tried the next one: 
 
Program Files\Actuate11SP3\iServer\Jar\BIRT\platform\plugins\com.actuate.data.oda.jdbc.drivers_11.0.3.v20111028\lib 
 
After each try I restart iServer (restart windows service "Actuate 11 BIRT iServer"). 
 
And I have to say that when I use Actuate's jdbc driver for MSSQL in my report design it works fine when runnig on iServer. I mean N_sqlserver.jar from folder lib. 
 
I suppose that something more has to be done, maybe I have to register my jar in some way...

RSiegler

Antilin,

My suggestion at this time would be to contact Actuate Support via the hotline at 650-645-3000 or via support@actuate.com with regards to this issue.

Looking over a sample installation I have in house using 11SP3 and a 3rd party driver (ojdbc14.jar for Oracle) and it works perfectly when placed in:

C:/Program Files (x86)/iServer11SP3/Jar/BIRT/platform/plugins/org.eclipse.birt.report.data.oda.jdbc_2.6.3.v20111028-0207/drivers/

The parent folder (org.eclipse.birt.report.data.oda.jdbc_2.6.3.v20111028-0207) has the folders:
drivers
META-INF
schema

And files:
.options
about.html
oda-jdbc.jar
plugin.properties
plugin.xml

If you are not seeing the same, it may be beneficial to contact support so that we can explore this further with you on a more official capacity.

Antilin

RSiegler, 
 
Thank you for your help, after reading your last post carefully I can see what I did wrong. 
 
The correct folder is 
C:/Program Files (x86)/iServer11SP3/Jar/BIRT/platform/plugins/org.eclipse.birt.report.data.oda.jdbc_2.6.3.v20111028-0207/drivers/ 
 
but I tried a folder with wrong name: 
Program Files\Actuate11SP3\iServer\Jar\BIRT\platform\plugins\com.actuate.data.oda.jdbc.drivers_11.0.3.v20111028\ 
 
After placing jar in the correct folder everything works fine. 
 
Thanks!