Running middlegen and using mysql-connector-java-3.0.11-stable-bin.jar against a MySQL database, I keep getting the "generator" set to "assigned".

Anyone knows how I can instruct the Hibernate plug-in to use "native" instead?

Thanks,
Acco

My PK columns in MySQL are all auto-increment.

Using the GUI it is possible to change the type to native, or in the middlegen prefs file I placed the following property for each table.

hibernate.tables.approval_trans.keygenerator=native

where approval_trans is the name of the table. It would be nice to be able to set a global default in the hibernate middlegen plugin.

I have used middlegen's pk generator for my CMP beans in the past, which generates the pk from a sequence name in a table, this worked great and I don't think that hibernate has something like that.

Ben

I decided to use the ANT task replace.

GUIs are out of question for me as I always start work from the database. It would be a pain to go through 500 tables and try to remember all the little modifications here and there.

Once the settings have been created and saved in the prefs file Middlegen will use those settings.

I wish I could do hibernate.tables.*.keygenerator=native

:-)

The cmp plugin for middlegen allows you to pick to global pk generation, so it would be nice to do the same in the hibernate one. I am working on a couple patches for the middlegen hibernate plugin so I can probably include the capability to set the generator at a global level.

Ben

Use sed to make the change or a small chunk of java code by reading the properties editing then and saving it again.

I would like to receive the patches once your done. If reasonable I will commit that changes. Please work off the CVS version. send patch(s) to david@hibernate.org

This actually is not all that difficult. If I don't get a patch I'll add it to Middlegen so you can set it using Ant Task.

Remind me in a few days.

If you got the momentum going, is it possible to also add something like:

hibernate.tables.*.default-cascade="save-update" ?!?

Thanks!!!

See what I can do.. Might have some time next week to knock it off.

OK I have added the ability to set native as the default for the generator at the Ant level and also added the ability to globally set the cascade value, eg, 'save-update' or what ever.

Not in CVS as yet (I'm away at the moment seeing a client) I'll check it in at the end of the week (when I get back) + any other features I get done in the hotel in the evenings.