Hello Richard,

Richard Emberson <[EMAIL PROTECTED]> writes:

> The Slide webpage http://jakarta.apache.org/slide/howto-jdbcstore.html
> lists database creation scripts for oracle.
> In various Domain.xml samples it is recommended to use the
> slidestore.reference.JDBCDescriptorsStore for oracle.
> In JDBCDescriptorsStore.java, the getDatabaseCreateStatements()
> method defined a different set of create scripts, varchar
> size differences.
> 
> Which is correct and which should be corrected?

don't know, if you can call one more correct than the other.
JDBC must set some hard limits on data size and there is
always the theoretical change, that you hit that limit.
Unfortunately slide does not expose that limits to the 
application, so that the problem can't be handled at
the application level.
 
Main difference seems to be the length of the uri. 
4000 characters as used in the How-to should be enough.
65336 is too large. If you are using WebDAV, the length
would be limited by limited by the client anyway.

I don't understand, why the uri table objects has only
3200 characters. The only column, that might be to small
is the value column in property. Sometimes you may have
properties, which are larger than 4000 characters.

BTW every apache project has a wiki:
http://nagoya.apache.org/wiki/apachewiki.cgi?SlideProjectPages
I wrote a little bit about indexing. Feel free to add anything
you learn about the JDBCDescriptorsStore. 

--
Martin Holz     <[EMAIL PROTECTED]>

Softwareentwicklung / Vernetztes Studium - Chemie
FIZ CHEMIE Berlin
Franklinstrasse 11
D-10587 Berlin     


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to