Re: [stellation-res] Comments table, why insert empty comment?

["Jonathan Gossage" <jonathan@xxxxxxxxxxxxxx>]

----- Original Message -----
From: "Ringo De Smet" <ringods@xxxxxxxxxxx>
To: "Stellation" <stellation-res@xxxxxxxxxxxxxxx>
Sent: Tuesday, October 01, 2002 12:30 PM
Subject: [stellation-res] Comments table, why insert empty comment?


> Hello,
>
> I still have problems creating the repository with the Oracle backend.
> The creation of the Comments table works, but why is an empty comment
> inserted in the Comments table? Here is the snippet of
> AbstractDBAccessPoint.createRepository I'm talking about:
>
> Table commentsTable = new Table("s_Comments");
> commentsTable.addColumn("s_id", _db.getIntegerType()).makePrimaryKey();
> commentsTable.addColumn("s_comment", _db.getLongStringType());
> _db.createTable(commentsTable);
>
> _db.executeUpdateStatement("INSERT INTO s_Comments(s_id, s_comment)
> VALUES (0,'')");
>
> Cheers,
>
> Ringo
>
There are known problems with Oracle in this area. We also encountered them
at work. Mark's suggestion is not as facetious as he indicated.

Regards

Jonathan

Personal Email
jgossage@xxxxxxxx

Business Email
jonathan@xxxxxxxxxxxxxx