Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

JDBC sqlserver error on BIRT

Questions
Tags
Users
Badges
Rafael Hernandez
(32●2●24●34) 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

0 votes

1 answer
10,792 views
0 votes

One answer

Permanent link
Sandy Grewal
JAZZ DEVELOPER (1.6k●12●23) 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:
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

1 vote

Comments
Rafael Hernandez
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
JAZZ DEVELOPER 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. http://www-01.ibm.com/support/docview.wss?uid=swg21586908

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 11,106
× 324
× 12

Question asked: Feb 04 '14, 11:47 a.m.

Question was seen: 10,792 times

Last updated: Feb 04 '14, 12:56 p.m.

Confirmation Cancel Confirm