Re: Problem with Oracle and IBM WBI Adapter for JDBC

From: MTNorman <mtnorman_at_duke-energy.com>
Date: 29 Jan 2007 08:23:13 -0800
Message-ID: <1170087793.461100.312930@p10g2000cwp.googlegroups.com>

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. Received on Mon Jan 29 2007 - 10:23:13 CST