In the reverse engineering of the mysql database, hinernatemysql cannot generate the primary/foreign key relationship.

Source: Internet
Author: User
Tags php development environment

In the reverse engineering of the mysql database, hinernatemysql cannot generate the primary/foreign key relationship.


(1) When we use the hibernate reverse engineering tool that comes with myeclipse for SSH development of large ※※project, it was found that the one-to-one primary key relationship could not be generated. Obviously, the database had a primary key relationship. why is reverse generation unavailable?

(2) First, I am using the MySQL database that comes with Appserv in the PHP development environment. It is not separately installed;

(3) This is because of database engine problems,

Run the show engines command in the SQL command line;


The default value is MyISAM;


(3) "MyISAM database engine does not support transaction processing or foreign keys" should be changed to InnoDB database engine;

(4) There are two ways to modify the Database Engine: one is to use the command alter table name type = InnoDB; to modify the engine, but I did not try it successfully;

The second method is to find the my. ini file in the configuration file. After reading the file, you can clear the comment and restart the database.


(5) but an error in this method is that the server cannot be started!




Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.