CMP table column ordering

[snowghost]

Can anyone explain the logic behind the column ordering
with CMP tables?

Specifically, why doesn't it follow the cmp-field order
provided in the entity section of the ejb-jar.xml?

My primary key field is being created as the final column
which will degrade findByPrimaryKey performance.

Also, why no indexes created on primary key fields?

Curious,

Snow

[javabettin]

Which database are you using?

[snowghost]

Oracle.

[javabettin]

Does Oracle not support creating primary key indexes automatically upon creation of a table. For example, postgres does the the "CREATE INDEX ...." for the primary key upon creation of the table.