Patch Name: PHSS_21577

Patch Description: s700_800 10.20 HP JDBC DRIVER 1.13

Creation Date: 00/07/28

Post Date:  00/08/09

Hardware Platforms - OS Releases:
	s700: 10.20
	s800: 10.20

Products:
	HP SQL/HP-UX A.G3.14

Filesets:
	ALLBASE-SQL.AB-JDBC

Automatic Reboot?: No

Status: General Superseded

Critical: No

Path Name: /hp-ux_patches/s700_800/10.X/PHSS_21577

Symptoms:
	PHSS_21577:
	Users may see problems with end user tools e.g. StarOffice
	on Linux, or their own Java application which uses the HP
	JDBC driver for Allbase. Information about the catalog will
	not be returned correctly. E.g. the list of tables for the
	Database may be blank.

	If tracing is switched on at the server, then the servlog
	will show a select with a where clause od the form
	  ..  column like 'NULL' escape '\' ..
	whereas it should be
	  .. column is NULL ....

Defect Description:
	PHSS_21577:
	SR# 8606137358
	The underlying problem is with methods such as getTables in
	the DataBaseMetaData interface incorrectly handling 'null'.
	These methods are used to retrieve information about the
	structure of the Database. If a parameter to one of these
	calls is set to =null, rather than ="" then an incorrect
	select is passed to Allbase so the information is not
	retrieved correctly.

	The resolution is to change the methods so that they handle
	nulls in the same way as an empty string.h DataBaseMetaData
	methods and handling of 'null'

SR:
	8606137358

Patch Files:
	/opt/allbase/jdbc/READ1ST
	/opt/allbase/jdbc/RELNOTES
	/opt/allbase/jdbc/hpjdbc.tar

what(1) Output:
	/opt/allbase/jdbc/READ1ST:
		None
	/opt/allbase/jdbc/RELNOTES:
		None
	/opt/allbase/jdbc/hpjdbc.tar:
		TOOLS(ByteArray.jp):  Ver:1 $Revision:  1.8 $ $Date:
		99/01/29 12:41:14 $
		JSOLID(Factory.jp):  Ver:1 $Revision:  1.3 $ $Date:
		2000/04/27 16:49:31 $
		JDBC(Jdbc.jp):  $Revision:  1.14 $ $Date:  99/04/08
		12:10:18 $
		JDBC(JdbcCallableStatement.jp):  $Revision:  1.10 $
		$Date:  99/01/07 07:13:30 $
		JDBC(JdbcConnection.jp):  $Revision:  1.15 $ $Date:
		99/03/30 07:06:52 $
		JDBC(JdbcDatabaseMetaData.jp):  $Revision:  1.16 $
		$Date:  99/04/06 11:17:30 $
		JDBC(JdbcDriver.jp):  $Revision:  1.14 $ $Date:
		2000/02/22 08:51:30 $
		JDBC(JdbcPreparedStatement.jp):  $Revision:  1.10 $
		$Date:  99/01/07 08:16:52 $
		JDBC(JdbcResultSet.jp):  $Revision:  1.13 $ $Date:
		99/03/30 07:08:43 $
		JDBC(JdbcResultSetMetaData.jp):  $Revision:  1.10 $
		$Date:  99/03/30 07:09:11 $
		JDBC(JdbcStatement.jp):  $Revision:  1.11 $ $Date:
		99/01/07 08:19:30 $
		JDBC(JdbcVersion.jp):  $Revision:  1.10 $ $Date:
		99/03/30 13:31:44 $
		TOOLS(LogonDialog.jp):  Ver:1 $Revision:  1.6 $
		$Date:  99/04/06 09:56:18 $
		JSOLID(ParameterException.jp):  Ver:1 $Revision:
		1.6 $ $Date:  98/09/22 09:42:34 $
		JSOLID(Solid.jp):  Ver:1 $Revision:  1.37 $ $Date:
		99/03/31 12:02:00 $
		TOOLS(tracing.h):  Ver:1 $Revision:  1.4 $ $Date:
		98/09/22 06:17:30 $
		JSOLID(SolidBuffer.jp):  Ver:1 $Revision:  1.5 $
		$Date:  98/09/22 09:43:09 $
		JSOLID(SolidConnection.jp):  Ver:1 $Revision:  1.22
		$ $Date:  99/01/29 12:47:38 $
		JSOLID(SolidDaemon.jp):  Ver:1 $Revision:  1.2 $
		$Date:  99/05/07 06:17:12 $
		JSOLID(SolidException.jp):  Ver:1 $Revision:  1.9 $
		$Date:  98/11/24 12:51:40 $
		JSOLID(SolidParameterSet.jp):  Ver:1 $Revision:  1.5
		$ $Date:  98/09/22 11:34:01 $
		JSOLID(SolidReadThread.jp):  Ver:1 $Revision:  1.4 $
		$Date:  98/12/22 11:08:47 $
		JSOLID(SolidResultSet.jp):  Ver:1 $Revision:  1.13 $
		$Date:  99/05/10 07:33:47 $
		JSOLID(SolidResultSetMetaData.jp):  Ver:1 $Revision:
		1.7 $ $Date:  98/10/13 08:48:49 $
		TOOLS(ThreadInfo.jp):  Ver:1 $Revision:  1.1 $
		$Date:  98/09/17 06:21:53 $
		JSOLID(TimeoutException.jp):  Ver:1 $Revision:  1.6
		$ $Date:  98/09/22 13:05:45 $
		TOOLS(Tracing.jp):  Ver:1 $Revision:  1.10 $ $Date:
		99/03/31 12:05:09 $
		JSOLID(TypeConversionException.jp):  Ver:1
		$Revision:  1.6 $ $Date:  98/09/22 13:06:24 $
		*** SOLID V5.3 HP-UX JDBC Port Monitor built Feb 10
		2000 07:10:29
		sldmon.c $Revision:  4.35 $ $Date:  2000/02/03
		12:46:56 $
		*** SOLID V5.3 Static Library built Feb 10 2000
		07:10:15
		sldcrypt.c $Revision:  4.3 $ $Date:  99/09/10
		16:47:16 $
		sldbuf.c $Revision:  4.2 $ $Date:  99/08/19 16:13:33
		$
		convapi.c $Revision:  4.8 $ $Date:  99/08/20
		09:08:14 $
		sldlib.c $Revision:  4.9 $ $Date:  2000/01/12
		10:23:55 $
		convccb.c $Revision:  4.2 $ $Date:  98/09/30
		17:13:11 $
		convtcb.c $Revision:  4.2 $ $Date:  99/08/19
		16:03:50 $
		converr.c $Revision:  4.3 $ $Date:  99/08/19
		16:02:49 $
		convdm.c $Revision:  4.2 $ $Date:  98/09/30 17:14:41
		$
		kb.c $Revision:  4.3 $ $Date:  99/08/19 16:10:25 $
		sldsub.c $Revision:  4.18 $ $Date:  2000/02/01
		07:39:10 $
		slddm.c $Revision:  4.2 $ $Date:  99/08/19 16:15:18
		$
		slddmlib.c $Revision:  4.2 $ $Date:  99/08/19
		16:16:08 $
		sldldm.c $Revision:  4.1 $ $Date:  98/09/30 18:00:49
		$
		sldssl.c $Revision:  4.13 $ $Date:  2000/01/24
		13:51:46 $
		convutil.c $Revision:  4.1 $ $Date:  98/09/30
		17:19:01 $
		kbstub.c $Revision:  4.1 $ $Date:  98/09/30 17:38:30
		$
		inspectmon.c $Revision:  1.12 $ $Date:  99/10/28
		12:26:05 $
		inspectutil.c $Revision:  1.9 $ $Date:  99/10/21
		07:48:10 $
		iascrypt.c $Revision:  4.4 $ $Date:  99/11/29
		16:16:41 $
		strutils.c $Revision:  4.9 $ $Date:  99/09/10
		19:02:31 $
		sldcfg.c $Revision:  4.22 $ $Date:  99/11/30
		14:56:53 $
		xpprocess.c $Revision:  1.6 $ $Date:  99/11/08
		11:51:15 $
		xplink.c $Revision:  1.5 $ $Date:  99/11/08 10:26:42
		$
		*** SOLID V5.3 Utilities Static Library built Feb 2
		2000 06:33:12
		xppipe.c $Revision:  1.2 $ $Date:  99/10/18 09:22:43
		$
		HP36217-02A.G3.04 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.04.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 02/03/99
		*** Allbase JDBC Data Manager built Feb 10 2000
		07:38:35
		Allbase Version A.G3.04
		albodbc.sql $Revision:  4.6 $ $Date:  99/03/02
		09:14:13 $
		allbase.sql $Revision:  4.16 $ $Date:  99/07/23
		08:13:33 $
		albmeta.sql $Revision:  4.10 $ $Date:  99/04/29
		17:50:38 $
		*** SOLID V5.3 Data Manager Common (JDBC) built Feb
		10 2000 07:33:43
		SOLID Product Name:
		dmCommon.c $Revision:  4.19 $ $Date:  99/07/30
		08:49:12 $
		HP36217-02A.G3.04 NET AF Library ALLBASE/SQL
		02/02/99
		HP36217-02A.G3.04 NET Library ALLBASE/SQL 02/02/99
		HP36217-02A.G3.04 NET VC Library ALLBASE/SQL
		02/02/99
		sldsrv.c $Revision:  4.25 $ $Date:  99/09/14
		15:38:04 $
		sldmeta.c $Revision:  4.8 $ $Date:  99/04/29
		19:19:25 $
		*** SOLID V5.3 HP-UX Data Manager Library built Feb
		10 2000 07:37:59
		getconfig.c $Revision:  4.4 $ $Date:  99/09/14
		15:26:51 $
		*** SOLID V5.3 Static Library built Feb 10 2000
		07:10:15
		sldlib.c $Revision:  4.9 $ $Date:  2000/01/12
		10:23:55 $
		kb.c $Revision:  4.3 $ $Date:  99/08/19 16:10:25 $
		sldsub.c $Revision:  4.18 $ $Date:  2000/02/01
		07:39:10 $
		slddm.c $Revision:  4.2 $ $Date:  99/08/19 16:15:18
		$
		sldldm.c $Revision:  4.1 $ $Date:  98/09/30 18:00:49
		$
		sldssl.c $Revision:  4.13 $ $Date:  2000/01/24
		13:51:46 $
		kbstub.c $Revision:  4.1 $ $Date:  98/09/30 17:38:30
		$
		sldcrypt.c $Revision:  4.3 $ $Date:  99/09/10
		16:47:16 $
		slddmlib.c $Revision:  4.2 $ $Date:  99/08/19
		16:16:08 $
		sldbuf.c $Revision:  4.2 $ $Date:  99/08/19 16:13:33
		$
		mbchar.c $Revision:  4.1 $ $Date:  98/10/01 14:28:38
		$
		myutil.c $Revision:  4.1 $ $Date:  98/10/01 14:31:55
		$
		*** SOLID V5.3 Allbase Parser built Feb 10 2000
		07:33:39
		oprlex.l $Revision:  4.2 $ $Date:  99/03/23 06:45:31
		$
		oprutil.c $Revision:  4.1 $ $Date:  98/10/01
		14:51:15 $
		oprexec.c $Revision:  4.1 $ $Date:  98/10/01
		14:44:34 $
		oprgram.y $Revision:  4.1 $ $Date:  98/10/01
		14:46:15 $
		oprtrav.c $Revision:  4.1 $ $Date:  98/10/01
		14:50:12 $
		license.c $Revision:  4.11 $ $Date:  99/11/29
		16:53:30 $
		strutils.c $Revision:  4.9 $ $Date:  99/09/10
		19:02:31 $
		dumpbuff.c $Revision:  4.4 $ $Date:  99/09/10
		19:01:05 $
		*** SOLID V5.3 Utilities Static Library built Feb 2
		2000 06:33:12
		sldcfg.c $Revision:  4.22 $ $Date:  99/11/30
		14:56:53 $

cksum(1) Output:
	2884846313 2512 /opt/allbase/jdbc/READ1ST
	1060495668 1560 /opt/allbase/jdbc/RELNOTES
	1969832709 2549760 /opt/allbase/jdbc/hpjdbc.tar

Patch Conflicts: None

Patch Dependencies: None

Hardware Dependencies: None

Other Dependencies: None

Supersedes: None

Equivalent Patches:
	PHSS_21578:
	s700: 11.00
	s800: 11.00

Patch Package Size: 2550 KBytes

Installation Instructions:
	Please review all instructions and the Hewlett-Packard
	SupportLine User Guide or your Hewlett-Packard support terms
	and conditions for precautions, scope of license,
	restrictions, and, limitation of liability and warranties,
	before installing this patch.
	------------------------------------------------------------
	1. Back up your system before installing a patch.

	2. Login as root.

	3. Copy the patch to the /tmp directory.

	4. Move to the /tmp directory and unshar the patch:

		cd /tmp
		sh PHSS_21577

	5a. For a standalone system, run swinstall to install the
	    patch:

		swinstall -x autoreboot=true -x match_target=true \
			-s /tmp/PHSS_21577.depot

	By default swinstall will archive the original software in
	/var/adm/sw/patch/PHSS_21577.  If you do not wish to retain a
	copy of the original software, you can create an empty file
	named /var/adm/sw/patch/PATCH_NOSAVE.

	WARNING: If this file exists when a patch is installed, the
	         patch cannot be deinstalled.  Please be careful
		 when using this feature.

	It is recommended that you move the PHSS_21577.text file to
	/var/adm/sw/patch for future reference.

	To put this patch on a magnetic tape and install from the
	tape drive, use the command:

		dd if=/tmp/PHSS_21577.depot of=/dev/rmt/0m bs=2k

Special Installation Instructions: None