JNDI in Birt Report Designer

I followed the directions at this link:

http://wiki.eclipse.org/index.php/BIRT/FAQ/Data_Access#Q:_How_can_I_pass_a_connection_object_to_BIRT.3F

and several others, but the claim that setting the JNDI property in your report to: java:comp/env/jdbc/MySqlDB does not work as you are required to enter the url, name and password as well. How does one connect with JNDI? If I remove the url, name and password the report throws an exception because it claims it needs the url, name and password. If I only enter the jndi string in the datasource editor it says the driver can't parse it. Is there any way to get the jndi to work? I have seen this is a problem from multiple links all over the internet.

Thanks

Find more posts tagged with

Comments

Wenjie

JNDI only makes sense only after the rptdesign is deployed in Application Server, such as Tomcat, JBoss etc.

At design time, i.e. in Birt Report Designer, always use url/user/pwd properties to create connections.

LeinadJan

<blockquote class='ipsBlockquote' data-author="'stoddard'" data-cid="66277" data-time="1278623638" data-date="08 July 2010 - 02:13 PM">
I followed the directions at this link: 
 
<a class='bbc_url' href='http://wiki.eclipse.org/index.php/BIRT/FAQ/Data_Access#Q:_How_can_I_pass_a_connection_object_to_BIRT.3F'>http://wiki.eclipse.org/index.php/BIRT/FAQ/Data_Access#Q:_How_can_I_pass_a_connection_object_to_BIRT.3F</a> 
 
and several others, but the claim that setting the JNDI property in your report to: java:comp/env/jdbc/MySqlDB does not work as you are required to enter the url, name and password as well. How does one connect with JNDI? If I remove the url, name and password the report throws an exception because it claims it needs the url, name and password. If I only enter the jndi string in the datasource editor it says the driver can't parse it. Is there any way to get the jndi to work? I have seen this is a problem from multiple links all over the internet. 
 
Thanks </blockquote>
 
The JNDI is the datasource id on your servers. That means that BIRT will use the data source that is existing on your server with the same id. If you have 2 servers, one for test and the other for client use. Each server will have its own connexion to the database but will have the same JNDI id. Which mean you don't have to change anything in your report to make it work on both servers.