Re: [stellation-res] Oracle backend!

[Dave Shields <shields@xxxxxxxxxxxxxx>]

On Wed, Jul 24, 2002 at 09:31:38AM -0400, Mark C. Chu-Carroll wrote:
> On Wednesday 24 July 2002 05:48 am, Ringo De Smet wrote:
> > Hello,
> >
> > Based on Mark's explanation that is also copied to the Eclipse Wiki, I
> > started writing an Oracle backend. I'm now at the point where I have
> > been able to run the command
> >
> > svc --location=oracle:svc configure database
> >
> > successfully. There are some remarks however:
> >
> > 1) For the long string, I have used Oracle's VARCHAR(2000). If my
> > colleague has informed me well, this seems to be the largest size
> > possible. In the DB2 version, it was put on 16000, so I will have to
> > look into this further.
> 
> They really don't support a varchar longer that 2K?
> 
> That's potentially a serious problem.  Even if things like comments
> never exceed 2K, the VARCHAR gets used in the text artifact representation,
> and a 2K limit there could be a real problem.
> 

By the way, if you run svc with -d1 (info output) you will find near the end a line
of the form

    1382 [main] INFO org.eclipse.stellation.workspace.Svc  - max line length 14

That is the length of the longest row in the Texts table. I recall seeing a value of
several thousand when checking in the Linux kernel source. Note that this is NOT the
length of the longest source line, but, as Mark notes, the length of the longest string
in the text artifact representation.


dave
-- 
-- 
Dave Shields, IBM Research, shields@xxxxxxxxxxxxxx, http://www.eclipse.org/stellation