On Mon, 6 Nov 2000, David Ekholm wrote:
> I wonder why the Java String type is mapped to a char(255) for Sybase in
> $ORION/config/database-schemas ?
The real reason?
I recently did a little testing for various databases with Orion.
The results were... baffling.
NONE of the published database schemas I tested were 100% correct.
Including the Hypersonic one (half a dozen errors -- now corrected). The
errors were childish, to the extent of making one wonder whether whoever
wrote the schemas ever even glimpsed at the documentation for the
databases in question.
The catch being that the incorrect mapping errors don't manifest until you
actually use the datatype in question... so the less used ones
like "short" tend to be wrong.
Not strictly an error, but it would be nice to note in the schema, if some
particular feature doesn't work with that DB (blob support being the most
prominent case, and extreme values of 64-bit numbers).
If they can't even iron out downright BUGS, how could you expect the
schemas to be optimized?
P.S. Now that Orionsupport is down, where should one send new/corrected
schemas? Bugzilla?
//Mikko
