Issue 11526 - hsqldb jdbc and Integer fields
Summary: hsqldb jdbc and Integer fields
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 644
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: OOo 1.1 Beta2
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-02-16 17:54 UTC by hermann
Modified: 2006-05-31 14:29 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 hermann 2003-02-16 17:54:22 UTC 
If I use hsqldb as database with OOo, OOo sends for Integer fields always
double-values. If I fill in a value "2", I get the error back, that the Value
2.0 is a wrong type for the field. It seems that OOo sends for this 2.0E0 as
value and I don´t find the code where this happens.
Comment 1 hermann 2003-02-17 19:45:40 UTC 
Hi,
could it be that OOo always send by INTEGER, SMALLINTEGER etc. a Value
like 2.0 (always with .0)? and the Databases does only ignore this?
I tried this with sapdb, mysql and mckoi and all works, only hsqldb
looks at the format and do not cast them to integer.
Comment 2 ocke.janssen 2003-02-19 10:28:34 UTC 
I'll take care about this one.
Comment 3 ocke.janssen 2003-02-19 10:29:07 UTC 
Fixed in cws apps02
Comment 4 ocke.janssen 2003-02-19 12:49:34 UTC 
set to beta
Comment 5 wolframgarten 2003-02-28 13:14:11 UTC 
Target changed.
Comment 6 wolframgarten 2003-02-28 13:14:47 UTC 
Target changed.
Comment 7 ocke.janssen 2003-02-28 13:28:45 UTC 
reopen for QA
Comment 8 ocke.janssen 2003-02-28 13:29:33 UTC 
apps02
Comment 9 marc.neumann 2003-03-10 08:43:28 UTC 
fixed
Comment 10 marc.neumann 2003-03-10 08:43:50 UTC 
verified
Comment 11 michael.bemmer 2003-03-13 11:11:34 UTC 
As mentioned on the qa dev list on March 5th I will close all resolved
<wontfix/duplicate/worksforme/invalid> issues. Please see this posting for details.
Comment 12 hans_werner67 2004-02-02 12:59:46 UTC 
change subcomponent to 'none'