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

BIRT report on RTC, querying JDBC Datasource

Hi, I have problems to setup a correct configuration in RTC deployed on WAS 7 to report data from a DB2 Database, any advice for me ?

The report designed is showed correctly in RSA 803, Eclipse Based software, but I have no idea what I have to configure the connection properties or connection profile when I deploy the report template on RTC, the deployment in correct but when I try to build a report from this report template I get the next Exception

0000010a JndiDataSourc C getDriverJndiPropertyFile() /opt/ibm/WebSphere/AppServer/profiles/AppSrv01/temp/oc3108781420Node01/server1/ccm_war/ccm.war/eclipse/configuration/org.eclipse.osgi/bundles/239/1/.cp/drivers/jndi.properties canReadFile = false
0000010a JndiDataSourc I javax.naming.NoInitialContextException: Failed to create InitialContext using factory specified in hashtable {java.naming.provider.url=corbaloc:rir:/NameServiceServerRoot, java.naming.factory.url.pkgs=com.ibm.ws.naming:com.ibm.ws.runtime:com.ibm.iscportal.jndi}
0000010a JDBCDriverMan I getJndiDSConnection: Unable to get JNDI data source connection; java.sql.SQLException: Failed to create InitialContext using factory specified in hashtable {java.naming.provider.url=corbaloc:rir:/NameServiceServerRoot, java.naming.factory.url.pkgs=com.ibm.ws.naming:com.ibm.ws.runtime:com.ibm.iscportal.jndi}
0000010a JDBCDriverMan I Loading JDBC driver class: com.ibm.db2.jcc.DB2Driver
0000010a JDBCDriverMan I Driver class not in class path: com.ibm.db2.jcc.DB2Driver. Trying to locate driver in drivers directory
0000010a JDBCDriverMan E DriverClassLoader failed to load class: com.ibm.db2.jcc.DB2Driver

How I have to configure the RTC enviroment in WAS 7 for BIRT reporting data from DB2?

Thanks in advance.
Best regards.
David

0 votes


Be the first one to answer this question!

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.

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

Question asked: Oct 01 '11, 12:41 p.m.

Question was seen: 4,643 times

Last updated: Oct 01 '11, 12:41 p.m.

Confirmation Cancel Confirm