Eclipse Community Forums: BIRT

Home » Archived » BIRT » call java

Fri, 19 May 2006 13:36

Eclipse User

Originally posted by: wohlgemuth.ucdavis.edu

hi,

does somebody have an extended tutorial how to call java out of birt, the
basic description is kinda short. Basicly I have a jdbc dataset and want to
calculate a column

so like:

value = calculate(returnedValue by query)

regards,

gert

Re: call java [message #163124 is a reply to message #163053]

Fri, 19 May 2006 17:08

Eclipse User

Originally posted by: wohlgemuth.ucdavis.edu

ok I found out how it works,

<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="SPECTRA" id="95">

<text-property name="displayName">SPECTRA</text-property>

<list-property name="computedColumns">

<structure>

<property name="name">HEIGHT</property>

<expression name="expression">var ion = row["ION"];

var spectra = row["SPECTRA"];

calculate = new
Packages.edu.ucdavis.genomics.metabolomics.binbase.bdi.util. math.CalculateSpectraProperties(spectra);

calculate.calculateHeight(ion);</expression>

<property name="dataType">float</property>

</structure>

</list-property>

<structure name="cachedMetaData">

<list-property name="resultSet">

<structure>

<property name="position">1</property>

<property name="name">BIN</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">2</property>

<property name="name">DATUM</property>

<property name="dataType">date-time</property>

</structure>

<structure>

<property name="position">3</property>

<property name="name">SAMPLE</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">4</property>

<property name="name">SPECTRA</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">5</property>

<property name="name">ION</property>

<property name="dataType">decimal</property>

</structure>

<structure>

<property name="position">6</property>

<property name="name">AMMOUNT</property>

<property name="dataType">decimal</property>

</structure>

<structure>

<property name="position">7</property>

<property name="name">HEIGHT</property>

<property name="dataType">float</property>

</structure>

</list-property>

</structure>

<property name="dataSource">binbase</property>

<property name="queryText">select *

from DATA</property>

</oda-data-set>

"gert wohlgemuth" <wohlgemuth@ucdavis.edu> wrote in message
news:e4kvjf$92f$1@utils.eclipse.org...
> hi,
>
> does somebody have an extended tutorial how to call java out of birt, the
> basic description is kinda short. Basicly I have a jdbc dataset and want
> to calculate a column
>
> so like:
>
> value = calculate(returnedValue by query)
>
> regards,
>
> gert
>
>

Previous Topic:	how to manipulate DataSet results
Next Topic:	How to script HTML constrols (drop-downs, radio buttons)

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 17 22:12:39 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter