It's all about the answers!

Ask a question

JDBC sqlserver error on BIRT

Rafael Hernandez (3222233) | 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: Cannot load JDBC Driver class:

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

permanent link
Sandy Grewal (1.6k1223) | answered Feb 04 '14, 11:55 a.m.
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:
Hope that helps

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.

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.

Your answer

Register or to post your answer.