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