Issue 110723 - SDBC Driver Date Problem
Summary: SDBC Driver Date Problem
Status: UNCONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.2
Hardware: Other Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-04-09 13:12 UTC by geoff91880
Modified: 2013-07-30 02:40 UTC (History)
1 user (show)

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

Attachments
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 geoff91880 2010-04-09 13:12:48 UTC 
Versions:
SDBC: 0.7.6a
PostgreSQL: 8.4.2
OpenOffice.org: 3.2.0 (320m12) Build: 9483

Platform: Linux Kernel (Ubuntu 10.04 Beta 2)

SDBC driver is not permitting inserts (or updates) of PostgreSQL type DATE.

For instance, update fails with the following message:

"Error updating the current record

pg_preparedstatement::setObjectWithInfo: can't convert value of
type com.sun.star.util.Date to type DECIMAL or NUMERIC"

As far as I can tell it looks like the driver is attempting to CAST the input
value and PostgreSQL is rejecting that for the field of type DATE.
Comment 1 geoff91880 2010-04-09 19:55:22 UTC 
I forgot to add that the driver being used is the x86 flavor, and the server
(x_64 architecture) is LAN accessed (through the 192.168.xxx.xxx subnet).
Comment 2 joergbudi 2010-04-18 18:05:37 UTC 
Hi,

I've checked linux x86 postgresql 8.4.3 as server and OOo3.2 win32 client and 
can't reproduce the problem. Can you (or someone else) do a testbuild with the 
32bit postgresql server of the same version and check, whether this problem 
occurs there as well ? If it does, it is indeed a 64bit server problem, 
actually I currently don't have a 64bit linux box, so this will be difficult 
for me to track down the problem. 

Joerg
Comment 3 Rob Weir 2013-07-30 02:40:47 UTC 
Reset assignee on issues not touched by assignee in more than 1000 days.