12.24 (MySQL engine modification, foreign key issues, java. SQL. timestamp, netbeans LANGUAGE)

MySQL modifies the Database Engine

Replace the database engine in MySQL using: alter table mytable engine = InnoDB

 

MySQL foreign key Type Error Code 1005, SQL status hy000: can't create table '. /grasspubsys/# sql-5bc_3.frm '(errno: 150) This error is generally caused by a problem with the foreign key, MySQL official documentation is explained as follows:

 

Cannot find an index in the referenced table where the referenced columns appear as the first columns, or column types in the table and the referenced table do not match for constraint.

Source :(Http://www.it3f.com/article/sort05/sort032/info-1479.html)

Java. SQL. timesstamp

For timestamp in the data table, you can use the java. SQL. timestamp field to correspond to it.

 

Netbeans language Modification

In Linux, the Chinese interface of the new version of netbeans 6.7 is terrible. I am too lazy to bother with the UI font of Java, so I found a method to change the UI to English.

Find the installation directory of netbeans/Etc/netbeans. conf, ModifyNetbeans_default_options =Line, enclosed in quotation marks-- Locale en: US.

If the interface still contains Chinese characters (such as the sidebar) after startup, delete~ /. Netbeans.

Windows can also be used as an example. However, the Home Directory isC:/document and settings/<Your name>;

Now, the whole world is clean!

 

Source: (http://idevel.cn/blog/articles/modify-netbeans-ui-language.html)

 

TMD sqlmapconfig. xml Sqlmapconfig. XML is always inexplicably incorrect, fuck. It must be the question of adding a new <sqlmap> label. In the evening, I checked it carefully. I wrote the namespace in <sqlmap>. However, there are still errors. Later, we copied the correct <sqlmap> label and modified it. In this way, no error was reported. It is estimated that there are things like Chinese characters and spaces in the middle, which is the biggest headache. Why does an error occur when sysrole. XML is not used? This is because sysrole. XML is used in sqlmapconfig. xml. Therefore, when sqlmapconfig. XML is used, the system checks whether sysrole. xml exists. Because sysrole. XML does not pass the DTD check, an error is returned, and sqlmapconfig. xml also reports an error. However, this error is not recorded in the log, so be sure to test whether the configuration is successful at any time.