Eclipse Community Forums: BIRT » Using JNDI to obtain db connection

Home » Archived » BIRT » Using JNDI to obtain db connection

Using JNDI to obtain db connection [message #213007]

Mon, 22 January 2007 06:54

Eclipse User

My application works under JBoss application server and I use BIRT
engine runtime to generate reports (version 2.1.1).

The problem - BIRT not use defined JNDI string to obtain database
connection. It always create new connection by using other
oda-data-source parameters.

The data-source part of my rptdesign file:

....
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="CRM2DS" id="4">
<text-property name="displayName">CRM2DS</text-property>
<property
name="odaDriverClass">com.mysql.jdbc.Driver</property>
<property name="odaURL">jdbc:mysql://localhost/CRM2</property>
<property name="odaUser">root</property-->
<property name="odaJndiName">java:comp/env/CRM2DS</property>
</oda-data-source>
</data-sources>
....

How can I force BIRT engine to use JNDI to obtain connection to database?

Thanks in advance

Cloding db connections after report generation [message #213040 is a reply to message #213007]

Mon, 22 January 2007 10:16

Eclipse User

During report generation BIRT report engine open database connection,
uses the connection but it does not close it after report generation is
done. As a result MySQL reports "Too many connections" after a lot of
reports are generated.

Why does not BIRT release database connection after report generation?
Whats wrong?

Re: Cloding db connections after report generation [message #213089 is a reply to message #213040]

Mon, 22 January 2007 12:47

Eclipse User

Did you get the connection using JNDI?
Can you try
java:/CRM2DS.
If your connection is not being closed please log a bugzilla entry.
Also we just wrote an artilce on JBOSS deployment at eclipsemag.net.
I believe you can download it for free.

Jason

"Sergey A. Lisovoy" <s.lisovoy@spb.solidworks.ru> wrote in message
news:ep2kc0$5ui$1@utils.eclipse.org...
> During report generation BIRT report engine open database connection, uses
> the connection but it does not close it after report generation is done.
> As a result MySQL reports "Too many connections" after a lot of reports
> are generated.
>
> Why does not BIRT release database connection after report generation?
> Whats wrong?

Re: Cloding db connections after report generation [message #213990 is a reply to message #213089]

Thu, 25 January 2007 05:38

Eclipse User

I have read article at eclipsemag, but I'm using report engine (not web
viewer) into my application. So I cant find an answers on my question...

About JNDI: I have solved problem with JNDI by placing jndi.properties
in
<ReportEngine> \plugins\org.eclipse.birt.report.data.oda.jdbc_2.2.0.I200612 22\drivers\

folder.

but connection still open after report generation. It seems to be a
bug... I will try to add report to bugzilla and waiting for fix. :(

Thanks for your answers.

Jason Weathersby wrote:
> Did you get the connection using JNDI?
> Can you try
> java:/CRM2DS.
> If your connection is not being closed please log a bugzilla entry.
> Also we just wrote an artilce on JBOSS deployment at eclipsemag.net.
> I believe you can download it for free.
>
> Jason
>
> "Sergey A. Lisovoy" <s.lisovoy@spb.solidworks.ru> wrote in message
> news:ep2kc0$5ui$1@utils.eclipse.org...
>> During report generation BIRT report engine open database connection, uses
>> the connection but it does not close it after report generation is done.
>> As a result MySQL reports "Too many connections" after a lot of reports
>> are generated.
>>
>> Why does not BIRT release database connection after report generation?
>> Whats wrong?
>
>

Re: Cloding db connections after report generation [message #213998 is a reply to message #213089]

Thu, 25 January 2007 06:04

Eclipse User

Add a bug to bugzilla
https://bugs.eclipse.org/bugs/show_bug.cgi?id=171640

Jason Weathersby wrote:
> Did you get the connection using JNDI?
> Can you try
> java:/CRM2DS.
> If your connection is not being closed please log a bugzilla entry.
> Also we just wrote an artilce on JBOSS deployment at eclipsemag.net.
> I believe you can download it for free.
>
> Jason
>
> "Sergey A. Lisovoy" <s.lisovoy@spb.solidworks.ru> wrote in message
> news:ep2kc0$5ui$1@utils.eclipse.org...
>> During report generation BIRT report engine open database connection, uses
>> the connection but it does not close it after report generation is done.
>> As a result MySQL reports "Too many connections" after a lot of reports
>> are generated.
>>
>> Why does not BIRT release database connection after report generation?
>> Whats wrong?
>
>

Re: Cloding db connections after report generation [message #214094 is a reply to message #213998]

Thu, 25 January 2007 11:11

Eclipse User

Thanks.

Jason

"Sergey A. Lisovoy" <s.lisovoy@spb.solidworks.ru> wrote in message
news:epa2og$bj5$1@utils.eclipse.org...
> Add a bug to bugzilla
> https://bugs.eclipse.org/bugs/show_bug.cgi?id=171640
>
> Jason Weathersby wrote:
>> Did you get the connection using JNDI?
>> Can you try
>> java:/CRM2DS.
>> If your connection is not being closed please log a bugzilla entry.
>> Also we just wrote an artilce on JBOSS deployment at eclipsemag.net.
>> I believe you can download it for free.
>>
>> Jason
>>
>> "Sergey A. Lisovoy" <s.lisovoy@spb.solidworks.ru> wrote in message
>> news:ep2kc0$5ui$1@utils.eclipse.org...
>>> During report generation BIRT report engine open database connection,
>>> uses the connection but it does not close it after report generation is
>>> done. As a result MySQL reports "Too many connections" after a lot of
>>> reports are generated.
>>>
>>> Why does not BIRT release database connection after report generation?
>>> Whats wrong?
>>

Previous Topic:	Birt Web Based Designer
Next Topic:	Creating a sql select with an IN clause

Goto Forum:

-=] Back to Top [=-

Current Time: Thu May 29 05:16:54 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter