[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
RE: [stellation-res] Decision on Oracle backend needed!
|
--- Jonathan Gossage <jgossage@xxxxxxxx> wrote:
> NULL values for empty comments and text lines are easy to recognize.
> When you call the JDBC function "getString" on the item in the result
> set, a null is returned. This is easy to recognize and turn into an
> empty string. This means that we can leave the existing code that
> writes to the database alone.
What I dislike about this is that you will have to test on 'null'. I
think that putting 'NOT NULL' on the database is there to get rid of
such 'is null' tests.
> For an empty string on Oracle we will get a null returned, an empty
> string for any other database. Either way we can inrerpret this as an
> empty string.
Still, the database constraints need to be weakened to allow 'NULL'.
Since the createRepository is now outside of a particular DB backend
implementation, this weakening is done on all databases if you would
change it there.
Ringo
__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
