Oracle 11g and v$session information

From: Thomas Kellerer <>
Date: Tue, 11 Nov 2008 17:23:25 +0100
Message-ID: <>


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.

Thomas Received on Tue Nov 11 2008 - 10:23:25 CST

Original text of this message