Re: [Hibernate-devel] SAP DB dialect

[Gavin_King/Cirrus%<CI...@ci...>]

> i have just commited the sap db dialect to cvs.

Excellent! Thanks Brad. :)

> gavin, r u still happy for me to change the default column name for the
> hilogenerator from next to next_hi (sap db gets upset when DBSchemaExport
> tries to create the hibernate_unique_key table with a column name of
next,
> as it is a reserved word)?

When we discussed this earlier other people seemed to prefer that we try
using quoted "next". If we can get that working with all platforms its
probably preferable. Can you try it out with SAP, please?

> the test suite fails on testCreateUpdate due to the size of the double in
> Foo.java.  sap db seems to support to +1e-64, but Foo's double is set to
> 1.33e-69, so the exponent seems to large to me.  however the jdbc driver
> appears to reduce it even more.  i could only get to 1.33e-36 for the
test
> to be successful.  i will send a message to the sapdb mailing list about
> this.

Interbase also has a problem like this, i think. I got round it by
disabling
part of the test. Thats a bit of a crude approach, I guess. Anyways, either
change or disable the test if you like, whatever works....

Have you got the schema export working? Someone else reported that the
"alter table add constraint" syntax is not supported by SAP DB so do
we need to support alternative forms in Dialect?

Does SAP support sequences or identity columns?