Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambrium.nl!feed.tweaknews.nl!postnews.google.com!news2.google.com!news.glorb.com!news-in-01.newsfeed.easynews.com!news-in-02.newsfeed.easynews.com!core-easynews!easynews.com!easynews!en-nntp-09.am2.easynews.com.POSTED!not-for-mail From: sybrandb@hccnet.nl Newsgroups: comp.databases.oracle.server Subject: Re: Oracle 11g and v$session information Message-ID: References: <6ntprtFrekaU1@mid.individual.net> X-Newsreader: Forte Agent 4.2/32.1118 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 41 X-Complaints-To: abuse@easynews.com Organization: Forte Inc. http://www.forteinc.com/apn/ X-Complaints-Info: Please be sure to forward a copy of ALL headers otherwise we will be unable to process your complaint properly. Date: Tue, 11 Nov 2008 18:45:14 +0100 Xref: news.cambrium.nl On Tue, 11 Nov 2008 17:23:25 +0100, Thomas Kellerer wrote: >Hi, > >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@x-oratest (TNS V1-V3)") so I wonder what the real problem is. > >Regards >Thomas 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 themselves