hibernate-devel

[Hibernate-devel] SAP DB dialect

[Brad C. <bra...@wo...>]

i am writing a sap db dialect, (which is proving more painful than
originally expected :-)).

the default column name for the hilo generator is next.  this is a reserved
word in sap db and cannot be used as a column name without being enclosed in
double quotes.

two obvious solutions spring to mind:
1. change the default column name - that seems to involve changing line 31
in RelationalDatastore.java and line 42 in HiLogGenerator.java.

2. enclose column names (and probably table names as well) in quotes.  much
bigger change.  i guess this would involve changing both the ddl generation
statements and the dml generation statements.  i am not sure if double
quotes are standard, so the dialect may also need to define the quote to
use.

brad

[Hibernate-devel] SAP DB dialect

[Brad C. <bra...@wo...>]

i have just commited the sap db dialect to cvs.

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)?

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.

brad

_______________________________
brad clow
chief technical officer
workingmouse

email: bra...@wo...
web:   http://www.workingmouse.com