Eclipse Community Forums: BIRT » Problem creating parameter marker

Help

Home

Home » Archived » BIRT » Problem creating parameter marker

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

Problem creating parameter marker [message #1070690]

Thu, 18 July 2013 13:28

Jorge García

Messages: 2
Registered: July 2013

Junior Member

Hello everybody,

I'm new on the comunity and working with BIRT. I've a question and I haven't been able to find the solution, sorry if it's duplicated. I'm trying to create a data set parameters from a jdbc Data Source.

When I create a data source jdbc and select org.eclipse.birt.report.data.oda.sampledb.Driver (Classic Models Inc. SampleDB Driver), I have no problems. I create a data set associated to this data source, and later I add a parameter marker to the query. Finally I can see parameter marker on "Edit Data set/Parameters"

As example for query:

select CLASSICMODELS.CUSTOMERS.CUSTOMERNAME
from CLASSICMODELS.CUSTOMERS
where CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER > ? (I'm able to associate the parameter marker to a parameter created )

However if I select oracle.jdbc.driver.OracleDriver or oracle.jdbc.OracleDriver, create a dataset associated, and add a parameter marker to the query, I can´t see parameter marker on "Edit Data set/Parameters".

Birt version is 4.3.0.
Oracle version is 11.2.0.1.0 - 64bit
jdbc ojdbc5.jar and ojdbc6.jar

index.php/fa/15631/0/

I hope that someboydy can help me.
Thanks for all!!!

Attachment: query.jpg
(Size: 129.31KB, Downloaded 514 times)
Attachment: query with param.jpg
(Size: 135.31KB, Downloaded 501 times)
Attachment: does not show.jpg
(Size: 76.15KB, Downloaded 613 times)

[Updated on: Thu, 18 July 2013 14:41]

Report message to a moderator

Re: Problem creating parameter marker [message #1070980 is a reply to message #1070690]

Fri, 19 July 2013 04:44

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Sounds like a possible bug. Does it work for a workaround to simply add a dataSet parameter for each '?' in your query?

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: Problem creating parameter marker [message #1071050 is a reply to message #1070980]

Fri, 19 July 2013 08:31

Jorge García

Messages: 2
Registered: July 2013

Junior Member

Hello Michael,

Sometimes the most logical and simplest response, is the solution. Yes it seems a bug. I think that I had tried it, but after your response, I tested it again and it worked.

Thank you very much.

Report message to a moderator

Re: Problem creating parameter marker [message #1071396 is a reply to message #1071050]

Sat, 20 July 2013 01:40

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Not a problem. You might search the bugs in the bugzilla to see if this has been reported. If not, please log it. Post any bug info you find or report in here for future reference too, if you don't mind. Thanks!

Michael

Developer Evangelist, Silanis

Report message to a moderator

Previous Topic:	StackOverFlow Exception While running Birt Report
Next Topic:	force not to show labels on every bar of chart

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 02:57:22 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter