Re: Oracle 11g and v$session information
Date: Tue, 11 Nov 2008 18:45:14 +0100
On Tue, 11 Nov 2008 17:23:25 +0100, Thomas Kellerer <YQDHXVLMUBXG_at_spammotel.com> wrote:
>I have a (Java) application that supplies the application information by setting connection properties to populate the v$session stuff using connection properties
>This has been working fine with version 8,9 and 10. When using that application with an Oracle 11g database the connection fails with the error message:
>"Connection property format error: Property is 'v$session.program'"
>The value supplied for that property works fine with all other Oracle versions.
>It is not a problem of the JDBC driver, because when I use the same driver against an Oracle 10g installtion it works fine.
>It seems that Oracle 11g does not accept brackets for that property. Because when I remove them, it works.
>But then there are entries coming from Oracle itself that contain brackets (e.g. "emagent_at_x-oratest (TNS V1-V3)") so I wonder what the real problem is.
And of course the jdbc driver has no version...
Yet as it has been working with Oracle 8 (which might be even 8.0 who
can tell), it is probably Jurassic.
I would first, even before asking around here, check whether the driver is certified against 11g.
Apart from that: a Java 'app' which directly accesses v$session instead of sys_context belongs on 1 place only: in the trash can!
-- Sybrand Bakker Senior Oracle DBA Too many people can't be bothered to do the work they get paid for themselvesReceived on Tue Nov 11 2008 - 11:45:14 CST