Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Developing Analytics Applications
Using a third-party JDBC driver on iServer
Migrateduser
Hello everyone,<br />
<br />
I design a report using BIRT RCP Report Designer (not a Professional).<br />
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.<br />
<br />
The problem appears when I'm trying to run my report on iServer after deploying it. I get an error:<br />
<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>
<br />
The BIRT and iServer documentation and forum suggest the only instruction:<br />
<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.<br />
What am I doing wrong?<br />
Thanks!<br />
<br />
P.S. I'm using trial version of iServer for Windows.
Find more posts tagged with
Comments
There are no comments yet