Eclipse Community Forums: BIRT » how can i write jdbc statments in BIRT

Home » Archived » BIRT » how can i write jdbc statments in BIRT

how can i write jdbc statments in BIRT [message #161531]

Tue, 16 May 2006 11:13

Eclipse User

Originally posted by: nieo1977.maktoob.com

how can i write jdbc statments in BIRT in expresion bulder or in onprepare
mothed for example

Re: how can i write jdbc statments in BIRT [message #161561 is a reply to message #161531]

Tue, 16 May 2006 14:02

Eclipse User

Hi. Create a scripted Data source and the a Data Set associated to this
DataSource and in the initialize(open)/fetch/close part of the DataSource
put your code.

Cristian

Re: how can i write jdbc statments in BIRT [message #161619 is a reply to message #161561]

Tue, 16 May 2006 17:34

Eclipse User

You can also do this by using a standard JDBC query and in the before open
modify the query like:

this.queryText = this.queryText + " AND Orders.orderID In (" + OrderList +
")"

Or in the propertyBinding tab you can modify the query.

Jason

"Cristian" <ceol.gael@gmail.com> wrote in message
news:2d602a50871ef2a462389738df1615a0$1@www.eclipse.org...
> Hi. Create a scripted Data source and the a Data Set associated to this
> DataSource and in the initialize(open)/fetch/close part of the DataSource
> put your code.
>
> Cristian
>

Re: how can i write jdbc statments in BIRT [message #162038 is a reply to message #161619]

Wed, 17 May 2006 14:57

Eclipse User

Originally posted by: nieo1977.maktoob.com

hi I mean how can i use a jdbc java code like
'preparestatment ' , 'preparequery' for example
and all coding cabability of jdbc as i write desktop database java
appliction
a swing dialog for example
becase there is a field need a custom and complicated calculation
use sql or even pl/sql to accomplish this calculation

Re: how can i write jdbc statments in BIRT [message #162116 is a reply to message #162038]

Wed, 17 May 2006 21:35

Eclipse User

You have two options here.
1 - Write a scripted Data Source and call the jdbc libs yourself or
2 - Write or extend existing JDBC ODA and put your code in the equivalent
ODA function.

Jason

"nieo1977" <nieo1977@maktoob.com> wrote in message
news:116a937e5418d2f51a89c2ea8a9a2f8a$1@www.eclipse.org...
> hi I mean how can i use a jdbc java code like 'preparestatment ' ,
> 'preparequery' for example and all coding cabability of jdbc as i write
> desktop database java appliction a swing dialog for example becase there
> is a field need a custom and complicated calculation
> use sql or even pl/sql to accomplish this calculation
>

Previous Topic:	Birt URL Run command without render
Next Topic:	probleam in pie chart

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 02 23:42:34 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter