Eclipse Community Forums: BIRT » Supplied Connection

Home » Archived » BIRT » Supplied Connection

Tue, 20 June 2006 02:55

Eclipse User

Originally posted by: bvanespen.gmail.com

Hi,

I am trying to integrate BIRT into our java application. It took me a
while to hit upon a paper (Birt World) on how to pass a connection to
BIRT. This paper dates back from December 2005 and I find it rather
extraordinary that is not a standard functionality. Anyway, is this
functionality implemented in the most recent version of BIRT 2.1 RC4? If
not, is it going to be implemented in the near future?

Regards
Bram

Re: Supplied Connection [message #171867 is a reply to message #171528]

Tue, 20 June 2006 14:58

Eclipse User

BIRT's latest download support using JNDI to retrieve a connection using
JNDI.

Jason

"Bram" <bvanespen@gmail.com> wrote in message
news:2a2fe033576db4f74ad54b67b7a7a58c$1@www.eclipse.org...
> Hi,
>
> I am trying to integrate BIRT into our java application. It took me a
> while to hit upon a paper (Birt World) on how to pass a connection to
> BIRT. This paper dates back from December 2005 and I find it rather
> extraordinary that is not a standard functionality. Anyway, is this
> functionality implemented in the most recent version of BIRT 2.1 RC4? If
> not, is it going to be implemented in the near future?
>
> Regards
> Bram
>
>

Re: Supplied Connection [message #171974 is a reply to message #171528]

Tue, 20 June 2006 22:32

Eclipse User

Originally posted by: yeecn.streamyx.com

I share you view, and I made a enhancement request yesterday. Can you voice
you view there as well?

https://bugs.eclipse.org/bugs/show_bug.cgi?id=147823

Regards,
Yee

"Bram" <bvanespen@gmail.com> wrote in message
news:2a2fe033576db4f74ad54b67b7a7a58c$1@www.eclipse.org...
> Hi,
>
> I am trying to integrate BIRT into our java application. It took me a
> while to hit upon a paper (Birt World) on how to pass a connection to
> BIRT. This paper dates back from December 2005 and I find it rather
> extraordinary that is not a standard functionality. Anyway, is this
> functionality implemented in the most recent version of BIRT 2.1 RC4? If
> not, is it going to be implemented in the near future?
>
> Regards
> Bram
>
>

Re: Supplied Connection [message #174431 is a reply to message #171867]

Fri, 30 June 2006 08:41

Eclipse User

Originally posted by: bvanespen.gmail.com

Hi,

Is there any example on how to use JNDI to supply a connection to BIRT?

Thank you.

Re: Supplied Connection [message #174504 is a reply to message #171867]

Fri, 30 June 2006 10:21

Eclipse User

Originally posted by: bvanespen.gmail.com

Hi,

I can not use JNDI for our application, so we need to go with the doc
"using a supplied connection".
[ http://birtworld.blogspot.com/2005/12/using-supplied-connect ion-with-birt.html]

This how-to is realy not good documented, and as a beginner I can't get it
working. Is there a step by step instruction somewhere on how to pull this
off.
I am unable to see this 'new connection' under the data-source wizard in
the designer.

Maybe somebody can provide me the plugins, subclass and simple
instructions?

Regards
Bram

Re: Supplied Connection [message #174706 is a reply to message #174504]

Sun, 02 July 2006 20:44

Eclipse User

Bram,

Take a look at the thread
ODA/JDBC extension.
You can use a bridge to implement this.
There is an example in the thread.

Jason

"Bram" <bvanespen@gmail.com> wrote in message
news:025ae98bb06c93f495b0099960d6026e$1@www.eclipse.org...
> Hi,
>
> I can not use JNDI for our application, so we need to go with the doc
> "using a supplied connection".
> [ http://birtworld.blogspot.com/2005/12/using-supplied-connect ion-with-birt.html]
>
> This how-to is realy not good documented, and as a beginner I can't get it
> working. Is there a step by step instruction somewhere on how to pull this
> off.
> I am unable to see this 'new connection' under the data-source wizard in
> the designer.
>
> Maybe somebody can provide me the plugins, subclass and simple
> instructions?
>
> Regards
> Bram
>
>

Re: Supplied Connection [message #175108 is a reply to message #174706]

Tue, 04 July 2006 10:10

Eclipse User

Originally posted by: bvanespen.gmail.com

Thanks, I found the jdbcbridge.zip file. Since there is no installation
guide that comes with it, can someonce confirm whether my installation
procedure is correct?

I have copied the "org.eclipse.birt.report.data.testjdbc_1.0.0.jar" to my
\birt-runtime-2_1_0\ReportEngine\plugins directory
and created a new directory called "org.eclipse.birt.report.data.testjdbc"
under the "\birt-runtime-2_1_0\ReportEngine\plugins" directory. This
directory contains the following structure:
-META-INF
-org
plugin.xml

In my java application I added the following:

contextMap.put("org.eclipse.birt.report.data.oda.subjdbc.SubOdaJdbcDriver ",conn);
...
task.setAppContext(contextMap);

Is this correct?

Now I get the following error if I try to run the report:

|WARN |4-jul-2006 15:50:13
org.eclipse.datatools.connectivity.oda.util.manifest.Manifes tExplorer
getDataSetElements
INFO: The ODA driver plugin.xml has no valid <dataSet> element defined in
the data source extension (org.eclipse.birt.report.data.testjdbc).

Thx

Re: Supplied Connection [message #175565 is a reply to message #175108]

Thu, 06 July 2006 06:42

Eclipse User

Originally posted by: yeecn.streamyx.com

I got the WARN message as well - but otherwise it seems to work OK.

Regards,
Yee

"Bram" <bvanespen@gmail.com> wrote in message
news:53e0520db19c32961c88cc8308cb838f$1@www.eclipse.org...
>
> Thanks, I found the jdbcbridge.zip file. Since there is no installation
> guide that comes with it, can someonce confirm whether my installation
> procedure is correct?
>
> I have copied the "org.eclipse.birt.report.data.testjdbc_1.0.0.jar" to my
> \birt-runtime-2_1_0\ReportEngine\plugins directory
> and created a new directory called "org.eclipse.birt.report.data.testjdbc"
> under the "\birt-runtime-2_1_0\ReportEngine\plugins" directory. This
> directory contains the following structure:
> -META-INF
> -org plugin.xml
>
> In my java application I added the following:
>
> contextMap.put("org.eclipse.birt.report.data.oda.subjdbc.SubOdaJdbcDriver ",conn);
> ..
> task.setAppContext(contextMap);
>
> Is this correct?
>
> Now I get the following error if I try to run the report:
>
> |WARN |4-jul-2006 15:50:13
> org.eclipse.datatools.connectivity.oda.util.manifest.Manifes tExplorer
> getDataSetElements
> INFO: The ODA driver plugin.xml has no valid <dataSet> element defined in
> the data source extension (org.eclipse.birt.report.data.testjdbc).
>
> Thx
>

Re: Supplied Connection [message #175572 is a reply to message #174706]

Thu, 06 July 2006 08:09

Eclipse User

Originally posted by: dejan.times.hr

Jason Weathersby wrote:
> Bram,
>
> Take a look at the thread
> ODA/JDBC extension.
> You can use a bridge to implement this.
> There is an example in the thread.
>
> Jason
>
> "Bram" <bvanespen@gmail.com> wrote in message
> news:025ae98bb06c93f495b0099960d6026e$1@www.eclipse.org...
>> Hi,
>>
>> I can not use JNDI for our application, so we need to go with the doc
>> "using a supplied connection".
>> [ http://birtworld.blogspot.com/2005/12/using-supplied-connect ion-with-birt.html]
>>
>> This how-to is realy not good documented, and as a beginner I can't get it
>> working. Is there a step by step instruction somewhere on how to pull this
>> off.
>> I am unable to see this 'new connection' under the data-source wizard in
>> the designer.
>>
>> Maybe somebody can provide me the plugins, subclass and simple
>> instructions?
>>
>> Regards
>> Bram
>>
>>
>
>
I still have a problem with passing Connection.
I try this in web app. and my report use Connection from its own
definition and not from my passed connection.

This is result from console of my application:

INFO: The ODA driver plugin.xml has no valid <dataSet> element defined
in the data source extension (org.eclipse.birt.report.data.testjdbc).
2006.07.06 14:01:50 org.eclipse.birt.data.engine.impl.DataEngineImpl <init>
INFO: Data Engine starts up
2006.07.06 14:01:50
org.eclipse.datatools.connectivity.oda.util.manifest.Manifes tExplorer
getDataSetElements
INFO: The ODA driver plugin.xml has no valid <dataSet> element defined
in the data source extension (org.eclipse.birt.report.data.testjdbc).
2006.07.06 14:01:50
org.eclipse.datatools.connectivity.oda.util.manifest.Manifes tExplorer
getDataSetElements
INFO: The ODA driver plugin.xml has no valid <dataSet> element defined
in the data source extension (org.eclipse.birt.report.data.testjdbc).
2006.07.06 14:01:50
org.eclipse.datatools.connectivity.oda.util.manifest.Manifes tExplorer
getDataSetElements
INFO: The ODA driver plugin.xml has no valid <dataSet> element defined
in the data source extension (org.eclipse.birt.report.data.testjdbc).
2006.07.06 14:01:50 org.eclipse.birt.data.engine.odaconsumer.Driver
setLogConfiguration
INFO: ODA driver does not have valid trace logging defined in the
plug-in .options or plugin.xml file.
2006.07.06 14:01:51
org.eclipse.birt.data.engine.executor.cache.SmartCache populateData
INFO: memoryCacheRowCount is 20000
2006.07.06 14:01:51
org.eclipse.birt.data.engine.executor.cache.SmartCache populateData
INFO: MemoryCache is used
2006.07.06 14:01:51
org.eclipse.birt.data.engine.executor.cache.SmartCache populateData
INFO: Time consumed by cache is: 0 second

Re: Supplied Connection [message #175718 is a reply to message #175572]

Thu, 06 July 2006 18:52

Eclipse User

I dont see the error in this log.
The warnings you are getting are fine.
How do you know it used the wrong connection?

Jason

"dejan" <dejan@times.hr> wrote in message
news:e8iuh9$oun$1@utils.eclipse.org...
> Jason Weathersby wrote:
>> Bram,
>>
>> Take a look at the thread
>> ODA/JDBC extension.
>> You can use a bridge to implement this.
>> There is an example in the thread.
>>
>> Jason
>>
>> "Bram" <bvanespen@gmail.com> wrote in message
>> news:025ae98bb06c93f495b0099960d6026e$1@www.eclipse.org...
>>> Hi,
>>>
>>> I can not use JNDI for our application, so we need to go with the doc
>>> "using a supplied connection".
>>> [ http://birtworld.blogspot.com/2005/12/using-supplied-connect ion-with-birt.html]
>>>
>>> This how-to is realy not good documented, and as a beginner I can't get
>>> it working. Is there a step by step instruction somewhere on how to pull
>>> this off.
>>> I am unable to see this 'new connection' under the data-source wizard in
>>> the designer.
>>>
>>> Maybe somebody can provide me the plugins, subclass and simple
>>> instructions?
>>>
>>> Regards
>>> Bram
>>>
>>>
>>
>>
> I still have a problem with passing Connection.
> I try this in web app. and my report use Connection from its own
> definition and not from my passed connection.
>
> This is result from console of my application:
>
> INFO: The ODA driver plugin.xml has no valid <dataSet> element defined in
> the data source extension (org.eclipse.birt.report.data.testjdbc).
> 2006.07.06 14:01:50 org.eclipse.birt.data.engine.impl.DataEngineImpl
> <init>
> INFO: Data Engine starts up
> 2006.07.06 14:01:50
> org.eclipse.datatools.connectivity.oda.util.manifest.Manifes tExplorer
> getDataSetElements
> INFO: The ODA driver plugin.xml has no valid <dataSet> element defined in
> the data source extension (org.eclipse.birt.report.data.testjdbc).
> 2006.07.06 14:01:50
> org.eclipse.datatools.connectivity.oda.util.manifest.Manifes tExplorer
> getDataSetElements
> INFO: The ODA driver plugin.xml has no valid <dataSet> element defined in
> the data source extension (org.eclipse.birt.report.data.testjdbc).
> 2006.07.06 14:01:50
> org.eclipse.datatools.connectivity.oda.util.manifest.Manifes tExplorer
> getDataSetElements
> INFO: The ODA driver plugin.xml has no valid <dataSet> element defined in
> the data source extension (org.eclipse.birt.report.data.testjdbc).
> 2006.07.06 14:01:50 org.eclipse.birt.data.engine.odaconsumer.Driver
> setLogConfiguration
> INFO: ODA driver does not have valid trace logging defined in the plug-in
> .options or plugin.xml file.
> 2006.07.06 14:01:51 org.eclipse.birt.data.engine.executor.cache.SmartCache
> populateData
> INFO: memoryCacheRowCount is 20000
> 2006.07.06 14:01:51 org.eclipse.birt.data.engine.executor.cache.SmartCache
> populateData
> INFO: MemoryCache is used
> 2006.07.06 14:01:51 org.eclipse.birt.data.engine.executor.cache.SmartCache
> populateData
> INFO: Time consumed by cache is: 0 second

Re: Supplied Connection [message #175865 is a reply to message #175718]

Fri, 07 July 2006 04:57

Eclipse User

Originally posted by: dejan.times.hr

Problem is solved. I have made mistake during instalation of plugin, so
thats why it didnt operate. Thank you for your quick reply. Now
everything is working O.K.

Bye..

Previous Topic:	Getting the runContext in a dataSourceEventHandler
Next Topic:	Exception when using Charts on Weblogic 8.1

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jun 13 09:40:04 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter