JDBC sqlserver error on BIRT

Rafael Hernandez (32●2●22●32) | asked Feb 04 '14, 11:47 a.m.

Hello everyone,

Im doing some BIRT reports and im getting this trouble when i upload it to the server:

The following items have errors:

Table (id = 10):

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

In my report im using JDBC driver to get a conection to an external database, in my PC works fine, but when i upload the report im having the issue.

Any idea to solve this error? =S

Thx in advance

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Sandy Grewal (1.6k●11●23) | answered Feb 04 '14, 11:55 a.m.
JAZZ DEVELOPER

Hi Rafael,
From the error it looks like the SQL server driver cannot be loaded to make a connection to the DW database.
Check the IC, point 6 about configuring your server env and SQL server driver:
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m5/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_sql.html&scope=null
Hope that helps
Sandy

Comments

Rafael Hernandez commented Feb 04 '14, 12:08 p.m. | edited Feb 04 '14, 12:19 p.m.

Thx for your help Sandy

If i do a BIRT report from the DW the report works fine, but the trouble is that im trying to make a conection to another independent DB in other server,

im using a BIRT JDBC Data Source and in my PC works fine,

When i excecute the report on server im getting the error.

once again, thx for your help

Sandy Grewal commented Feb 04 '14, 12:56 p.m.

JAZZ DEVELOPER

You can check for a few things:
1. SQL server jdbc driver is set as per IC link above.
2. Create a dir: <Jazz_install_dir>/server/sqlserver and put the jars in there and re-start the server.
3. I also found a technote that explains where to put the jars to be made available specifically for Birt.
http://www-01.ibm.com/support/docview.wss?uid=swg21586908

It's all about the answers!

Related questions

JDBC sqlserver error on BIRT

One answer

Your answer