Skip to main content



      Home
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 Go to next message
Eclipse UserFriend
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 Go to previous messageGo to next message
Eclipse UserFriend
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 Go to previous messageGo to next message
Eclipse UserFriend
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 Go to previous messageGo to next message
Eclipse UserFriend
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 Go to previous message
Eclipse UserFriend
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:
  


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

Powered by FUDForum. Page generated in 0.04080 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top