[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
would be the empty string "" (not null), this would also for other non-Oracle database. We just act as Oracle and treat
empty strings like null.

In this way, we could use the empty string always and remove the externally settable parameter. This would keep the
interface simple.

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.

Generated at Thu Oct 31 23:53:52 UTC 2024 using JIRA 7.5.2#75007-sha1:9f5725bb824792b3230a5d8716f0c13e296a3cae.