[QFJ-295] Extend JdbcStore and JdbcLog to allow non-empty strings as defaults (for Oracle) Created: 04/Feb/08 Updated: 07/Aug/08 Resolved: 03/May/08 |
|
Status: | Closed |
Project: | QuickFIX/J |
Component/s: | None |
Affects Version/s: | None |
Fix Version/s: | 1.3.2 |
Type: | Improvement | Priority: | Default |
Reporter: | Steve Bate | Assignee: | Unassigned |
Resolution: | Fixed | Votes: | 0 |
Labels: | None |
Description |
Oracle treats empty strings as SQL NULLs. |
Comments |
Comment by Jörg Thönnes [ 05/Feb/08 ] |
Hi Steve, I am feeling a bit uncomfortable introducing another parameter. IMHO, if this new parameter for a default null value In this way, we could use the empty string always and remove the externally settable parameter. This would keep the Cheers, Jörg |
Comment by Steve Bate [ 03/May/08 ] |
Unfortunately, I didn't receive a notification about this comment so I just now saw it. I'm not sure I understand what you are suggesting. The issue is that the parameter cannot be null since the columns are part of the primary key. That's why the SessionID object uses empty strings as a default value. The problem is that Oracle has a vendor-specific behavior that treats empty strings as SQL NULLS. Since this is not allowed, some other value (other than an empty string) must be provided to Oracle. The purpose of the configurable parameter is to let the user choose what that special value will be. |