Eclipse Community Forums: BIRT » Accessing JDBC Connection

Home » Archived » BIRT » Accessing JDBC Connection

Accessing JDBC Connection [message #262264]

Wed, 28 November 2007 12:36

Eclipse User

I recently posted a question regarding executing the Oracle ALTER SESSION
command but got no replies. A simpler question is whether there is any
way to access the JDBC connection object prior to the execution of an SQL
statement.

Ideally I'd like to do this in JavaScript, but java is fine too if that
will work.

The bottom line is that we have clients anywhere in the world requesting
reports, and we need to properly set the Oracle session time zone so the
proper data is returned in the report (according to the client's time
zone).

I have a hard time beleiving that NOBODY out there is generating
time-based reports from multiple time zones. It seems that this would be
an obvious BIRT requirement, but I haven't found a way to do it yet.

Any advice would be greatly appreciated.

Thanks in advance.
-Mitch Christensen

Re: Accessing JDBC Connection [message #262267 is a reply to message #262264]

Wed, 28 November 2007 13:33

Eclipse User

Originally posted by: aaron.douglas.centare.com

Hi Mitch:

Having played around with finding the JDBC/raw connections in the APIs,
I can tell you it's difficult if not impossible with how the APIs were
written to access the data source like you want.

A possible solution you could consider is to create multiple user
accounts for each time zone you support. You can set the default
timezone for a user fairly easily. You can update the credentials for
the connection through an event handler and pass in the proper username
for the timezone.

Hope this helps -
Aaron

Aaron Douglas
Centare Group Ltd.
http://www.centare.com
aaron.douglas@centare.com

Mitch Christensen wrote:
> I recently posted a question regarding executing the Oracle ALTER
> SESSION command but got no replies. A simpler question is whether there
> is any way to access the JDBC connection object prior to the execution
> of an SQL statement.
>
> Ideally I'd like to do this in JavaScript, but java is fine too if that
> will work.
>
> The bottom line is that we have clients anywhere in the world requesting
> reports, and we need to properly set the Oracle session time zone so the
> proper data is returned in the report (according to the client's time
> zone).
>
> I have a hard time beleiving that NOBODY out there is generating
> time-based reports from multiple time zones. It seems that this would
> be an obvious BIRT requirement, but I haven't found a way to do it yet.
>
> Any advice would be greatly appreciated.
>
> Thanks in advance.
> -Mitch Christensen
>

Re: Accessing JDBC Connection [message #262282 is a reply to message #262264]

Wed, 28 November 2007 16:47

Eclipse User

Did you consider to use a Stored Procedure?

Spunk

"Mitch Christensen" <mitchellch@comcast.net> schrieb im Newsbeitrag
news:03fede17a1e393bc4f7f286efaaaf10a$1@www.eclipse.org...
>I recently posted a question regarding executing the Oracle ALTER SESSION
>command but got no replies. A simpler question is whether there is any way
>to access the JDBC connection object prior to the execution of an SQL
>statement.
>
> Ideally I'd like to do this in JavaScript, but java is fine too if that
> will work.
>
> The bottom line is that we have clients anywhere in the world requesting
> reports, and we need to properly set the Oracle session time zone so the
> proper data is returned in the report (according to the client's time
> zone).
>
> I have a hard time beleiving that NOBODY out there is generating
> time-based reports from multiple time zones. It seems that this would be
> an obvious BIRT requirement, but I haven't found a way to do it yet.
>
> Any advice would be greatly appreciated.
>
> Thanks in advance.
> -Mitch Christensen
>

Previous Topic:	Change styles for PDF format for all reports
Next Topic:	Sub-report dataset problems

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Nov 09 15:04:38 EST 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter