nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I use a parameter in my Datasource?

mkdz

I would like to use a parameter in my datasource. I found a stackoverflow post about it:<a data-ipb='nomediaparse' href='http://stackoverflow.com/questions/7345272/birt-part-of-datasource-as-parameter'>http://stackoverflow.com/questions/7345272/birt-part-of-datasource-as-parameter</a>I tried this by putting in my Database URL: Then I created a parameter called database. However, when I run my report, I get errors about not being able to establish a connection to the database. I also found this post:<a data-ipb='nomediaparse' href='http://www.birt-exchange.org/forum/index.php?/topic/21959-report-parameters-and-datasource-property-bindings/'>http://www.birt-exchange.org/forum/index.php?/topic/21959-report-parameters-and-datasource-property-bindings/</a>It says to edit the JDBC Driver URL under Property Binding in the Edit Data Source dialog, but what do I put into the Database URL under the BIRT JDBC Data Source window? Thanks!

Find more posts tagged with

Comments

mkdz

What the? I can't get my Database URL to show up in my post above. Anyway, this is what I'm using as my Database URL: <blockquote class="ipsBlockquote"> </blockquote>

rawesso

Hope you noticed the URL still doesn't show

mkdz

Goddamnit. I don't know why that's happening. Here's a screenshot: <img src='http://i.imgur.com/RNTuFpU.png' alt='Posted Image' class='bbc_img' />

kclark

You can change this in the beforeOpen() of the data source.<pre class="_prettyXprint">this.setExtensionProperty("odaURL", "...url..." + params["param"].value + "...url..");</pre>Can you try that and let me know if it works?

mkdz

I put this in my beforeOpen() for the datasource: I still get the same error: <div><div>An exception occurred during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: survey_info
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[select
*
from
reporting.fn_survey_info(?)]
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: The established connection to the data source is not active.<pre> </pre></div></div> Should I have changed anything in the Database URL part of my data source?

kclark

What version of BIRT are you using? I put this in my beforeOpen()<pre class="_prettyXprint">this.setExtensionProperty("odaURL", "jdbc : mysql : / /" + params["URL"].value + ":3306/classicmodels")</pre>Note I changed the URL for the code block because the URL is showing up blank right now.

mkdz

I'm using BIRT 4.3.0

mkdz

Any other advice on this? Putting:<pre>this.setExtensionProperty("odaURL", "jdbc : mysql : / /" + params["database"].value + ":3306/bfms")</pre>[color=rgb(102,102,0);]in my Data Source beforeOpen() still doesn't work.[/color]

kclark

Can you try this in 4.2 to see if you can rule out a bug in 4.3?

mkdz

Ok, I will try this in 4.2.

mkdz

<blockquote class="ipsBlockquote" data-author="kclark" data-cid="120027" data-time="1378744320"><div>Can you try this in 4.2 to see if you can rule out a bug in 4.3?</div></blockquote>I still get the same error in 4.2. Do you have a sample report I could try out?

mkdz

Any more options on this?

kclark

I've attached an example that works for me in postgres 9.1 using the JDBC 4 driver and I'm using BIRT 4.3

mkdz

Well I got it working. I think I probably had a typo somewhere and just couldn't see it. Thanks a bunch!

kclark

No problem, glad it's working now!