JNDI Database Connections

After adding a JNDI URL to a JDBC data source profile, I can never get it to use this connection. 
 
Whenever I change the JDBC URL to a non-existent database in order for it to attempt connect using the JNDI connection, it gives a connection refused. No where in the logs does it indicate that it tried using the JNDI connection, only JDBC. 
 
I have tried this on numerous application servers with the same results. 
 
Below are the application servers tested with: 
 
Glassfish 
JBoss 
Tomcat 
 
I tried both run time files from MyEclipse Version 7.1.1 Build id: 7.1.1-20090310, and the Eclipse run time files contained in the birt.war of the birt-runtime-2_3_2_1.zip file downloaded from <a class='bbc_url' href='http://www.eclipse.org/downloads/download.php?file=/birt/downloads/drops/R-R1-2_3_2_1-200904141342/birt-runtime-2_3_2_1.zip'>Eclipse downloads - mirror selection</a>. 
 
This is a requirement for our application to go live and any help would be greatly appreciated.

Find more posts tagged with

Comments

beachbumm

Example Tomcat and report configuration used based on 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:'>BIRT/FAQ/Data Access - Eclipsepedia</a> 
 
webapps/birt/meta-inf/context.xml 
 
<Resource name="jdbc/CRSDS" 
auth="Container" 
type="javax.sql.DataSource" 
maxActive="5" maxIdle="-1" maxWait="10000" 
username="crs" password="Testcrs!" 
driverClassName="oracle.jdbc.driver.OracleDriver" 
url="jdbc:oracle:thin:@USPLSCOSD145:1521:witstst" 
description="MySQL Sfdata DB"/> 
 
webapps/birt/WEB-INF/web.xml 
 
<resource-ref> 
<description>Resource reference to a factory for java.sql.Connection</description> 
<res-ref-name>jdbc/CRSDS</res-ref-name> 
<res-type>javax.sql.DataSource</res-type> 
<res-auth>Container</res-auth> 
</resource-ref> 
 
testjndi.rptdesign 
 
<data-sources> 
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="6"> 
<text-property name="displayName"></text-property> 
<property name="odaDriverClass">oracle.jdbc.driver.OracleDriver</property> 
<property name="odaURL">jdbc:oracle:thin:@TEST:1521:witstst</property> 
<property name="odaUser">crs</property> 
<encrypted-property name="odaPassword">xxxxx</encrypted-property> 
<property name="odaJndiName">java:comp/env/jdbc/CRSDS</property> 
</oda-data-source> 
</data-sources>

JasonW

Did you setup tomcat connection pooling according to this: 
<a class='bbc_url' href='http://wiki.eclipse.org/BIRT/FAQ/Deployment#Q:_How_do_I_setup_BIRT_to_use_Tomcat_Connection_Pooling'>BIRT/FAQ/Deployment - Eclipsepedia</a> 
 
Jason

beachbumm

Yes. My post was based on that very same link.

When I change the JDBC URL in the report to a non existent database, I get a connection refused error. It is not trying the JNDI connection.

JasonW

Do you mean in the designer or the deployed enviornment?
Also what is your log level set to?

beachbumm

I tested this within the designer and deployed environment running under Glassfish.

I am not sure what the log level is set to. Did you want me to bump it up and how do I configure that?

purushdk

Hi

Please provide more detail so that i will modify.

Thanks,
k.purushothaman

mhammer

I am facing exactly the same issue as beachbumm. I followed the instructions on BIRT/FAQ/Deployment and BIRT/FAQ/Data Access but the report always uses the JDBC connection string instead of JNDI (i.e. when I change JDBC to a non-existend database the report throws errors).

Environment details: BIRT runtime 2.3.2.2, Tomcat 5.5.27, Oracle 10g