Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » BIRT RCP Designer and JNDI(How to create local JNDI datasource)
BIRT RCP Designer and JNDI [message #539172] Wed, 09 June 2010 20:37 Go to next message
John Dunlap is currently offline John DunlapFriend
Messages: 4
Registered: June 2010
Junior Member
Greetings,

I have built a merged war using the BIRT Report Viewer and some in-house code. Specifically, I integrated the viewer with spring security, Active Directory, and added some administrative UI screens.

The process that we would like to use is for people who create reports to create them using the RCP report designer and then to upload them into the report viewer where users can access the newly created report(s). However, we have a requirement that the database credentials (specifically the username and password) CANNOT be present in the rptdesign file in any way shape manner or form. We want the report to use a JNDI datasource in the report viewer and we also want the report to use a JNDI datasource in the report designer, to avoid the database credentials being saved in that file. The plan is to have the upload mechanism in the report viewer issue a validation error if the database username/password fields are found in the rptdesign file (or perhaps silently remove them, if a valid JNDI name is also present).

The problem that I am facing is that I cannot find a way to create a local JNDI datasource, within the designer, that would allow me to simply set a JNDI name in the create datasource dialog when creating a JDBC datasource.

Any thoughts or suggestions would be greatly appreciated.
-John
Re: BIRT RCP Designer and JNDI [message #539192 is a reply to message #539172] Wed, 09 June 2010 21:47 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

John,

Take a look at this bug:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=197443

Jason

On 6/9/2010 4:37 PM, John Dunlap wrote:
> Greetings,
>
> I have built a merged war using the BIRT Report Viewer and some in-house
> code. Specifically, I integrated the viewer with spring security, Active
> Directory, and added some administrative UI screens.
> The process that we would like to use is for people who create reports
> to create them using the RCP report designer and then to upload them
> into the report viewer where users can access the newly created
> report(s). However, we have a requirement that the database credentials
> (specifically the username and password) CANNOT be present in the
> rptdesign file in any way shape manner or form. We want the report to
> use a JNDI datasource in the report viewer and we also want the report
> to use a JNDI datasource in the report designer, to avoid the database
> credentials being saved in that file. The plan is to have the upload
> mechanism in the report viewer issue a validation error if the database
> username/password fields are found in the rptdesign file (or perhaps
> silently remove them, if a valid JNDI name is also present).
>
> The problem that I am facing is that I cannot find a way to create a
> local JNDI datasource, within the designer, that would allow me to
> simply set a JNDI name in the create datasource dialog when creating a
> JDBC datasource.
> Any thoughts or suggestions would be greatly appreciated.
> -John
Re: BIRT RCP Designer and JNDI [message #539195 is a reply to message #539192] Wed, 09 June 2010 21:58 Go to previous messageGo to next message
John Dunlap is currently offline John DunlapFriend
Messages: 4
Registered: June 2010
Junior Member
Yes, that feature is exactly what I'm looking for. Sadly, from reading the posts, it doesn't appear to have been implemented. This is a bit of a problem, in my situation, because although I can have my upload controller automatically remove the database credentials from the rptdesign file, I do not trust some of our potential report writers to manually remove them before committing the rptdesign file into subversion...
Re: BIRT RCP Designer and JNDI [message #539342 is a reply to message #539195] Thu, 10 June 2010 13:40 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

John,

Can you add your comments to the bug?

Jason

On 6/9/2010 5:58 PM, John Dunlap wrote:
> Yes, that feature is exactly what I'm looking for. Sadly, from reading
> the posts, it doesn't appear to have been implemented. This is a bit of
> a problem, in my situation, because although I can have my upload
> controller automatically remove the database credentials from the
> rptdesign file, I do not trust some of our potential report writers to
> manually remove them before committing the rptdesign file into
> subversion...
Re: BIRT RCP Designer and JNDI [message #539443 is a reply to message #539342] Thu, 10 June 2010 17:57 Go to previous messageGo to next message
John Dunlap is currently offline John DunlapFriend
Messages: 4
Registered: June 2010
Junior Member
Done.
Re: BIRT RCP Designer and JNDI [message #539771 is a reply to message #539195] Sat, 12 June 2010 19:35 Go to previous messageGo to next message
AlesD is currently offline AlesDFriend
Messages: 12
Registered: July 2009
Junior Member
Dne 9.6.2010 23:58, John Dunlap napsal(a):
> Yes, that feature is exactly what I'm looking for. Sadly, from reading
> the posts, it doesn't appear to have been implemented. This is a bit of
> a problem, in my situation, because although I can have my upload
> controller automatically remove the database credentials from the
> rptdesign file, I do not trust some of our potential report writers to
> manually remove them before committing the rptdesign file into
> subversion...

What about adding pre-commit hook that would prevent commit if the file
cointains DB credentials? Or post-commit that would remove them automatically.

Ales
Re: BIRT RCP Designer and JNDI [message #539836 is a reply to message #539771] Sun, 13 June 2010 21:18 Go to previous message
John Dunlap is currently offline John DunlapFriend
Messages: 4
Registered: June 2010
Junior Member
It's funny that you should say that because that's the solution that I'm currently working on... Smile
Previous Topic:how can I display a report at the center of BIRT viewer?
Next Topic:eclipse 3.5.2 and birt 2.5.2 stand alone application
Goto Forum:
  


Current Time: Thu Mar 28 12:26:32 GMT 2024

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

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

Back to the top