Hello,

My schemaupdate ant task displays nicely all queries, but the DB remains unchanged...

Here is the task


Any idea why this would happen?

Thanks

I have only been able to get SchemaExport to work (not SchemaUpdate). Maybe you have to do Export the first time?

(I'm a newbie, so I can't add a lot of advice, sorry).

-Dave

It looks like the problem is due to the MySQL driver or server version. Hopefully, some day in the future in one of the future versions it'll work.

For now, I'll simply redirecting the output as follows

ant schemupdate > my_queries.txt

and then copy the queries from there and run them against the DB.

Hope it helps.

I just began running into this problem as well, I did some debugging to see wtf was actually going on, apparently as of hibernate 2.1.3 or somewhereish around there they changed how the schemaupdate task works (thats when mine broke anyway).. you need to now put a text="no" attribute in the schemaupdate task to get it to execute the update commands to your db, otherwise it just prints them to the screen. example:



HTH
-David

Thanks.

It did not work for me however. It did hide the queries, but the DB was not updated.

Which version of hibernate are you running?

Hibernate 2.1.3

Here is likely the affending line of code for you in 2.1.3...



that is from the execute method of SchemaUpdate class. You might want to debug to that point and findout why its not updating. You are running the schemaexport task correct? If so try executing it again with the property text="false", I told you to try text="no" but that may not have been interpreted as a boolean properly.

Try this as your task:



You may also consider updating to hib 2.1.4.. I don't know what DB your running but they put in some good fixes for the mysql dialect in 2.1.4 that weren't present in any of the previous builds.
-David