Hibernate version: 3.1

Hibernate tools version: 3.0 alpha 4.a

I'm trying to generate schema DDL from my hibernate mapping. The documentation at http://www.hibernate.org/hib_docs/refer ... guide.html says to specificy the 'length' attribute in the 'column' element for "column length/decimal precision". But then I see examples, etc in the forums that use 'length' for text columns and 'precision' & 'scale' for numeric columns. This makes sense, but I dont' see it documented anywhere... In fact the documetation that I see, does not even mention a way to specify the decimal precision (the 'scale' attribute).

So first question is, why do I see no 'precision' and 'scale' attribute in hibernate tools documentation (is just undocumented at this time, or is it for something else)?

Either way, no matter what I use... length, precision, scale or any combination of those, they never get used in my schema generation. I get DDL without column lengths.
According to this thread, it looks like I can specify these things in the 'sql-type' attribute.
http://forum.hibernate.org/viewtopic.ph ... ema+length
So then what are all these length,precision and scale attributes for? Or is just a bug that's still there?

Could somebody please enlightmen me.... sooooo confused.

Thanks!

the last thread is about reverse engineering and how to specifcy which hibernate type should be used for a certain sql-type..

The other part of your thread is about schemaexport/hbm2ddl which should just work with precision, length and scale.

What exactly do you mean by "should work with"? Are you saying that, had I done things correctly, it should utilize my length,precision and scale attributes for the output?

The main issue I have (aside from my documenation confusion) is that I do define length, precision and scale in my hibernate mapping, but hbm2ddl just ignores it. It outputs ddl without any column width definition.

If you're telling me that it should work, then I'll spend more time trying to debug my stuff. What drove me to post this, is that I couldn't find any specific documenation on precision/scale, so I wasn't sure if I was just wasting my time trying to use a non-existent feature (although it wouldn't explain why 'length' isn't working for me either).

BTW.. in case it makes a difference, I'm using the ant task.
org.hibernate.tool.hbm2ddl.SchemaExportTask

Thanks

if your dialect has the right types defined with $s,$l and $p in the type definitions then it should just work.

Yep,

for DB2 changing the line



to



in the constructor of DB2Dialect works.
So far this modification does not seem to have any side effect.