Hibernate Community • View topic - SchemaExportTask : InnoDB : delimiter : Bad DROP SQL

View unanswered posts | View active topics

Board index » Projects » Tools

All times are UTC - 5 hours [ DST ]

SchemaExportTask : InnoDB : delimiter : Bad DROP SQL

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

muirwa

Post subject: SchemaExportTask : InnoDB : delimiter : Bad DROP SQL

Posted: Thu Jul 15, 2004 9:22 pm

Beginner

Joined: Thu May 06, 2004 4:06 pm
Posts: 25

What I can do:

1. Yes, I can create tables of type InnoDB by using:

Code:

delimiter=" type=InnoDB;"

2. Yes, you can create only DROP table SQL using:

Code:

drop="yes"

3. However, can you generate only CREATE table SQL? I ask this because if you add have:

Code:

delimiter=" type=InnoDB;"

the darn DROP SQL has " type=InnoDB;" appended to the end (obviously), so you can't drop the tables. If you remove the InnoDB type, then your DROPS will work, but your tables won't be InnoDB.

Any work around?

Top

Nick Redshaw

Post subject:

Posted: Mon Jul 19, 2004 6:48 am

Beginner

Joined: Wed Jun 23, 2004 12:37 pm
Posts: 20

Hi

I don't think you can use the delimiter option in this way as once your mappings start to generate indexes and such like then a delimiter with ' type=innodb' will cause those bits of DDL to fail too.

We have a small stand alone script that alters each table to a type of innodb. We run this manually at present whenever we do a schemaexport.

Top

Page 1 of 1

[ 2 posts ]

Board index » Projects » Tools

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum