Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with Oracle and IBM WBI Adapter for JDBC

Re: Problem with Oracle and IBM WBI Adapter for JDBC

From: 4 Integration <4integration_at_gmail.com>
Date: Mon, 29 Jan 2007 22:02:13 +0100
Message-ID: <eplnbv$3ns$1@independence.tornevall.net>


MTNorman wrote:
>
> On Jan 29, 4:47 am, 4 Integration <4integrat..._at_gmail.com> wrote:

>> It would have been very helpful it would be possible to set the default
>> session time zone on the connection parameters or as system parameters
>> but what I have seen (decompiling the JDBC driver) it's not possible.

>
> The database administrator can write a login trigger for the database
> that executes an "alter session" statement to set any session paramter
> you need - timezone, optimizer goal, etc. - based on the username,
> the connection method, the server the connection is being made from,
> etc.
>

Will the JDBC connection object be populated with the sessionTimestamp when getting the connection if such login trigger is setup?

-- 
// 4 Integration
Received on Mon Jan 29 2007 - 15:02:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US