Hibernate version:hibernate-2.1


Code between sessionFactory.openSession() and session.close():

Session session = HibernateUtil.currentSession();
Criteria criteria = session.createCriteria(VTemplate.class)
.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)
.add(Example.create(info).enableLike(MatchMode.ANYWHERE));

criteria.setFirstResult(firstResult);
criteria.setMaxResults(maxResult);
list = criteria.list();


Full stack trace of any exception that occurs:
18:46:46,187 WARN [JDBCExceptionReporter] SQL Error: 1248, SQLState: 42000
18:46:46,187 ERROR [JDBCExceptionReporter] Every derived table must have its own
alias
18:46:46,187 WARN [JDBCExceptionReporter] SQL Error: 1248, SQLState: 42000
18:46:46,187 ERROR [JDBCExceptionReporter] Every derived table must have its own
alias
18:46:46,203 ERROR [MyEjbWrapper] MyEjb.exception.DaoEx
ception: Unable to perform find

Name and version of the database you are using:MySQL 5.0/Oracle9:

I want to change the database form oracle to the open source database mysql. I suppose that it could without change the code(like that posted). I modified the jdbc, but an exception breaks out.
I don't know how to do?Please help~


btw, the following code is ok, but the posted one isn't.：

Session session = HibernateUtil.currentSession();
Criteria criteria = session.createCriteria(MyObj.class)
.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)
.add(Example.create(info).enableLike(MatchMode.ANYWHERE));

change the dialect class (hibernate.dialect) from oracle to mysql in your sessionfactory configuration.

Here's the reference link... http://www.hibernate.org/hib_docs/v3/re ... l-dialects

Thank you, that is what i want~!