Wednesday, August 18, 2010

sql to get the current JDBC driver version in the system

For application version 11.5.10 onwards ensure ATG_PF.H is applied onto the instance. Also ensure that you are using the latest version of the JDBC driver. You may run the following sql to get the current JDBC driver version in the system :
select bug_number, decode(bug_number,
         '3043762','JDBC drivers 8.1.7.3',
         '2969248','JDBC drivers 9.2.0.2',
         '3080729','JDBC drivers 9.2.0.4 (OCT-2003)',
         '3423613','JDBC drivers 9.2.0.4 (MAR-2004)',
         '3585217','JDBC drivers 9.2.0.4 (MAY-2004)',
         '3882116','JDBC drivers 9.2.0.5 (OCT-2004)',
         '3966003','JDBC drivers 9.2.0.5 (OCT-2004)',
         '3981178','JDBC drivers 9.2.0.5 (NOV-2004)',
         '4090504','JDBC drivers 9.2.0.5 (JAN-2005)',
         '4201222','JDBC drivers 9.2.0.6 (MAY-2005)') Patch_description
    from ad_bugs
    where bug_number in
         (
         '3043762',
         '2969248',
         '3080729',
         '3423613',
         '3585217',
         '3882116',
         '3966003',
         '3981178',
         '4090504',
         '4201222'
         )
    order by 2;

No comments:

Post a Comment

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...