Hibernate cannot use alias problems with native SQL queries

Recently encountered a problem is hibernate in the use of native SQL multi-table federated query alias problem, has been error, said to be unable to find a column, after consulting others finally came to a solution

You need to add attributes to the database connection string, as follows

Common.db.driverclassname=com.mysql.jdbc.driver

Common.db.url=jdbc:mysql://10.10.11.8:3306/cm_mini_1?useoldaliasmetadatabehavior=true

Common.db.username=user

common.db.password=123456

This article is from the "technical Achievements of Life" blog, please be sure to keep this source http://2933246.blog.51cto.com/2923246/1612870

Hibernate cannot use alias problems with native SQL queries