Skip to main content



      Home
Home » Archived » BIRT » passing JDBC parameter at runtime
passing JDBC parameter at runtime [message #200364] Fri, 10 November 2006 20:00 Go to next message
Eclipse UserFriend
Hi,

When I design a report, I create the dataset by configuring the JDBC
parameter. However, is it possible at run time, I would be able to send the
user id, password and schema information? Because that way, the report is
not bound to the hard-coded information.

Thanks
Bidyut
Re: passing JDBC parameter at runtime [message #200407 is a reply to message #200364] Sat, 11 November 2006 16:34 Go to previous messageGo to next message
Eclipse UserFriend
specify a JNDI name for the data source. That way you can configure your
database connection information in the servlet container that runs the
report instead of using the hard-coded parameters.

http://www.eclipse.org/birt/phoenix/project/notable2.1.php#j ump_4
http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-exam ples-howto.html

HTH,
Jan

Bidyut Pattanayak wrote:
> Hi,
>
> When I design a report, I create the dataset by configuring the JDBC
> parameter. However, is it possible at run time, I would be able to send the
> user id, password and schema information? Because that way, the report is
> not bound to the hard-coded information.
>
> Thanks
> Bidyut
>
>
Re: passing JDBC parameter at runtime [message #200568 is a reply to message #200364] Mon, 13 November 2006 11:38 Go to previous messageGo to next message
Eclipse UserFriend
You can also use script or property binding to change the user, password,
driver and dburl on the fly.

Jason

"Bidyut Pattanayak" <bidyut@yahoo.com> wrote in message
news:ej37bi$h8c$1@utils.eclipse.org...
> Hi,
>
> When I design a report, I create the dataset by configuring the JDBC
> parameter. However, is it possible at run time, I would be able to send
> the user id, password and schema information? Because that way, the report
> is not bound to the hard-coded information.
>
> Thanks
> Bidyut
>
Re: passing JDBC parameter at runtime [message #200626 is a reply to message #200568] Mon, 13 November 2006 19:00 Go to previous messageGo to next message
Eclipse UserFriend
Thanks Jason. That sounds interesting. Is there any documentation you can
point me to, so that I can get a better idea about that.

Thanks
Bidyut

"Jason Weathersby" <jweathersby@actuate.com> wrote in message
news:eja70t$bjl$1@utils.eclipse.org...
> You can also use script or property binding to change the user, password,
> driver and dburl on the fly.
>
> Jason
>
> "Bidyut Pattanayak" <bidyut@yahoo.com> wrote in message
> news:ej37bi$h8c$1@utils.eclipse.org...
>> Hi,
>>
>> When I design a report, I create the dataset by configuring the JDBC
>> parameter. However, is it possible at run time, I would be able to send
>> the user id, password and schema information? Because that way, the
>> report is not bound to the hard-coded information.
>>
>> Thanks
>> Bidyut
>>
>
>
Re: passing JDBC parameter at runtime [message #200634 is a reply to message #200626] Mon, 13 November 2006 19:24 Go to previous message
Eclipse UserFriend
There is information on this page:
http://www.eclipse.org/birt/phoenix/deploy/reportScripting.p hp

Here are a few examples of how to swap url and user using property binding
or script.

Jason

"Bidyut Pattanayak" <bidyut@yahoo.com> wrote in message
news:ejb0ve$msb$1@utils.eclipse.org...
> Thanks Jason. That sounds interesting. Is there any documentation you can
> point me to, so that I can get a better idea about that.
>
> Thanks
> Bidyut
>
> "Jason Weathersby" <jweathersby@actuate.com> wrote in message
> news:eja70t$bjl$1@utils.eclipse.org...
>> You can also use script or property binding to change the user, password,
>> driver and dburl on the fly.
>>
>> Jason
>>
>> "Bidyut Pattanayak" <bidyut@yahoo.com> wrote in message
>> news:ej37bi$h8c$1@utils.eclipse.org...
>>> Hi,
>>>
>>> When I design a report, I create the dataset by configuring the JDBC
>>> parameter. However, is it possible at run time, I would be able to send
>>> the user id, password and schema information? Because that way, the
>>> report is not bound to the hard-coded information.
>>>
>>> Thanks
>>> Bidyut
>>>
>>
>>
>
>


  • Attachment: examples.zip
    (Size: 55.75KB, Downloaded 90 times)
Previous Topic:Birt Designer into Rcp application
Next Topic:Instructions to run tests after checking out and building birt.
Goto Forum:
  


Current Time: Sun Jun 08 17:29:17 EDT 2025

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

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

Back to the top