Eclipse Community Forums: BIRT » how to define as data source a passed jdbc connection

Help

Home

Home » Archived » BIRT » how to define as data source a passed jdbc connection

Show: Today's Messages :: Show Polls :: Message Navigator

how to define as data source a passed jdbc connection [message #484392]

Mon, 07 September 2009 11:19

Diana Mising name

Messages: 34
Registered: July 2009

Member

Hi

I am very new to BIRT and I want to create a sort of "hello world" report.
I'm trying to see how difficult it would be to switch our company's
reporting app from jasper to BIRT.

I have seen the tutorials and all seems great, until I realized I have to
pass the jdbc connection from my app to the report. So in my code I set:

task.getAppContext().put("OdaJDBCDriverPassInConnection", conn);

but then how do I define the data source in the report designer? I imagine
it would have to be a scripted data source, but the given examples suggest
that a scripted data source is a completely different thing.

So - how can I use the connection that I set in the IRunAndRenderTask task?

Report message to a moderator

Re: how to define as data source a passed jdbc connection [message #484555 is a reply to message #484392]

Tue, 08 September 2009 08:36

John Missing name

Messages: 513
Registered: July 2009

Senior Member

In report designer use the standard "jdbc datasource" und "jdbc dataset".

In your app first call
task.getAppContext().put("OdaJDBCDriverPassInConnection", conn);
and then
"runAndRender()"
your connection "conn" is used instead of the connection and/or datasource you defined directly in your rptdesign-file.

There's a bug in birt 2.5 that you cannot use OdaJDBCDriverPassInConnection with crosstab reports.

Scripted data source is completley different - we use it to pass in java objects from our apps to birt.

John

Diana Pop schrieb:
> Hi
>
> I am very new to BIRT and I want to create a sort of "hello world"
> report. I'm trying to see how difficult it would be to switch our
> company's reporting app from jasper to BIRT.
>
> I have seen the tutorials and all seems great, until I realized I have
> to pass the jdbc connection from my app to the report. So in my code I set:
>
> task.getAppContext().put("OdaJDBCDriverPassInConnection", conn);
>
> but then how do I define the data source in the report designer? I
> imagine it would have to be a scripted data source, but the given
> examples suggest that a scripted data source is a completely different
> thing.
>
> So - how can I use the connection that I set in the IRunAndRenderTask task?
>

Report message to a moderator