WebDB: Error when using 'query and update' with columns in date format

From: Nicolas Stern <nicolas.stern_at_psi.ch>
Date: Tue, 04 Jan 2000 17:30:00 +0100
Message-ID: <38722008.FC1A74B3_at_psi.ch>



I'm running WebDB 2.0.5.6.1 on Linux Mandrake release 6.1 (Kernel 2.2.12).

I access an 8i (8.1.5.0.1) -instance on the same machine.

When I access WebDB using Netscape Communicator 4.6, I'm experiencing the following problem:

I have the a table with two columns in date format. When browsing this table, using the 'query and update' -button, I get the following error:

'A network error occurred while Netscape was receiving data. (Network error: Connection reset by peer)'

If I deselect the columns in date format before clicking on the 'query & update' -button, I get no error.

The table has the following structure:

 Name                            Null?    Type
 ------------------------------- -------- ----
 CREATENAME                      NOT NULL VARCHAR2(20)
 BOOTPC                          VARCHAR2(10)
 IPADDRESS                       VARCHAR2(20)
 CREATEDBY                       VARCHAR2(20)
 DATECREATED                     DATE
 MODIFBY                         VARCHAR2(20)
 DATEMODIF                       DATE
 IPNAME                          VARCHAR2(30)

If I create another table with columns in date format, I get no error.

Many thanks for your help


Nicolas Stern                 
Information Systems          Tel: +41 56 310 46 96
Computing Division           Fax: +41 56 310 36 49
Paul Scherrer Institute      
CH-5232 Villigen PSI         E-mail: nicolas.stern_at_psi.ch  
Switzerland Received on Tue Jan 04 2000 - 17:30:00 CET

Original text of this message