[DERBY-2073] Inserting BigDecimal value in PreparedStatement into double column loses fractional digits

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.1.2.1
• Fix Version/s: 10.3.2.1, 10.4.1.3
• Component/s: JDBC
• Environment: windows xp
• Assignee: Katherine Marsden
• Reporter: Lukasz P
• Created: 13/Nov/06 09:35
• Updated: 21/Jan/11 17:49
• Resolved: 15/Oct/07 19:31

Description

Create table with column of type double.
Create a prepared statement which inserts value to this column.
use preparedStatement#setBigDecimal method of the statement to set value of the column.

Execution of such statement succeeds, but actual value in db has no fractional digits.

You can use attached test class to reproduce this problem

Sub-Tasks

• Inserting BigDecimal value in PreparedStatement with setBigDecimal into double column loses fractional digits: Closed
• Inserting BigDecimal value in PreparedStatement with setObject into double column loses fractional digits: Closed