connection pooling

can anybody explain me abount connection pooling with BIRT datasource.

Step by step instruction will be helpful.

Thanks

Find more posts tagged with

Comments

JasonW

Are you using connection pooling with JNDI or are you implementing your own? 
 
What app server are you using? 
 
Look here for Tomcat: 
<a class='bbc_url' href='http://wiki.eclipse.org/BIRT/FAQ/Data_Access#Q:_How_can_I_pass_a_connection_object_to_BIRT.3F'>BIRT/FAQ/Data Access - Eclipsepedia</a> 
 
Jason

mh10

Yes i am looking to use connection pooling with JNDI. 
 
Also, while creating datasource, when we specify driver information, username, password, JNDI url. How it works..... 
does it connect using JNDI connection pool first? 
 
I am using Sun Application server - glassfish v2 
 
 
 
Thanks 
 
 
<blockquote class='ipsBlockquote' data-author="JasonW">Are you using connection pooling with JNDI or are you implementing your own? 
 
What app server are you using? 
 
Look here for Tomcat: 
<a class='bbc_url' href='http://wiki.eclipse.org/BIRT/FAQ/Data_Access#Q:_How_can_I_pass_a_connection_object_to_BIRT.3F'>BIRT/FAQ/Data Access - Eclipsepedia</a> 
 
Jason</blockquote>

JasonW

It will try the JNDI entry first. If it is not located it will then use the user and pass defined in the report.

mh10

can we know that ....whether entered JNDI entry is working right or wrong ......on BIRT end 
 
 
<blockquote class='ipsBlockquote' data-author="JasonW">It will try the JNDI entry first. If it is not located it will then use the user and pass defined in the report.</blockquote>

JasonW

I believe there is a log entry, but if you want to verify just put invalid credentials in user and pass fields and deploy the report and run it. Note in the designer it always uses the user/pass credentials (although these can be in a connection profile).

Jason

mh10

Hi jason, 
 
I tried with wrong credentials in user and pass fields and deployed the report and ran it. 
It is giving me invalid credential Error. 
 
then i tried with just Driver Class and JNDI url name......it is also giving me connection error. 
 
while the JNDI url which i am using is working fine with my other java applications. 
 
Why this is happening? 
I am using BIRT 2.3.2, Sun java Application Server 9.1_02 
 
 
Any suggestions? 
 
 
 
 
<blockquote class='ipsBlockquote' data-author="JasonW">I believe there is a log entry, but if you want to verify just put invalid credentials in user and pass fields and deploy the report and run it. Note in the designer it always uses the user/pass credentials (although these can be in a connection profile). 
 
Jason</blockquote>

JasonW

Make sure it has a driver class, url, urser and pwd fields in addition to the jndi entry and set the log level to finest and run it again. Post the log file.

Jason

mh10

Jason, 
How can i set log levels in BIRT reports? 
 
 
Thanks 
 
<blockquote class='ipsBlockquote' data-author="JasonW">Make sure it has a driver class, url, urser and pwd fields in addition to the jndi entry and set the log level to finest and run it again. Post the log file. 
 
Jason</blockquote>

JasonW

If you are using the viewer there is a setting for log level in the web.xml.

Jason