Issue 14997 - Forms using JDBC display the time portion as 23:59:59
Summary: Forms using JDBC display the time portion as 23:59:59
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: OOo 1.1 RC
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
: 15557 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-05-28 07:15 UTC by Unknown
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
gif screenshot showing the problem (13.12 KB, image/gif)
2003-05-30 03:32 UTC, Unknown 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-05-28 07:15:21 UTC 
This is one of those problems that is intermittant but annoying.  When 
connecting with JDBC to either MySQL or Postgresql data sources using JDBC, the 
time text box for date fields displais 23:59:59.  Closing and reopening the form 
usually resets it.  Using JRE 1.4.1_2 and OpenOffice 1.1 Beta.
Comment 1 Frank Schönheit 2003-05-28 09:18:34 UTC 
Kirk, what kind of form are we talking about? Is the form on a valid
record, and does display the current record improperly, or is the form
on a new record, and the 23:59:59 is the "default" value being displayed?
Comment 2 Unknown 2003-05-30 03:32:58 UTC 
Created attachment 6530 [details]
gif screenshot showing the problem
Comment 3 Unknown 2003-05-30 03:33:22 UTC 
Ok, to explain a bit more.  I have a huge database of records with a
timestamp field.  Obtained through the JBDC postgresql connector.  The
timestamps show up ok in the data browser, but not in a datasheet
control on the form.  I'll attach a screenshot.
Comment 4 marc.neumann 2003-06-03 15:25:19 UTC 
I can reproduce this
-> FS: It's important that you have a timestamp field in you table.
Comment 5 Frank Schönheit 2003-06-05 12:11:45 UTC 
was a problem in the conversion of timestamp values in the JDBC driver
.... fixed in CWS dba08
Comment 6 ooo 2003-06-11 13:55:57 UTC 
KA: changed target milestone
Comment 7 marc.neumann 2003-06-20 09:40:15 UTC 
change target
Comment 8 ocke.janssen 2003-06-24 11:40:55 UTC 
Please verify. Thx
Comment 9 marc.neumann 2003-06-24 12:43:16 UTC 
set to fixed
Comment 10 marc.neumann 2003-06-24 12:43:41 UTC 
verified in dba08
Comment 11 marc.neumann 2003-07-01 08:49:47 UTC 
close, because fixed in OOo 1.1RC
Comment 12 Frank Schönheit 2003-07-15 09:24:50 UTC 
*** Issue 15557 has been marked as a duplicate of this issue. ***
Comment 13 hans_werner67 2004-02-02 12:12:50 UTC 
change subcomponent to 'none'