Migrating from an Oracle database to a MySQL database

To_date---->> Date_format

SELECT * FROM dual---->> Select ' * ' from dual

rownum---->> Limit

The table name is changed to uppercase.

Modify dialect, MySQL default dialect is not Bigdecimal,long,text

Reference needs custom dialect

Package com.yourcompany;
Import Java.sql.Types;
Import Org.hibernate.Hibernate;
Import Org.hibernate.dialect.MySQLDialect;
public class Mydialect extends Mysqldialect {
Public Mydialect () {
Super ();
Registerhibernatetype (Types.decimal, Hibernate.BIG_DECIMAL.getName ());
Registerhibernatetype (Types.longvarchar, Hibernate.STRING.getName ());
Registerhibernatetype (Types.binary, Hibernate.STRING.getName ());
Registerhibernatetype ( -1, Hibernate.STRING.getName ());
}
}

Migrating from an Oracle database to a MySQL database