1. Use SQL Information to Populate Schema Documentation and Code Comments Using Hibernate Tools? stackoverflow.comI have set up Hibernate Tools from within Eclipse to autogenerate classes based on an existing DB. For each of the tables I have documented them and each of their ... |
2. org.hibernate.hql.ast.QuerySyntaxException: INFORMATION_SCHEMA.SYSTEM_ALIASES is not mapped. coderanch.comwhen I executed the a hibernate application to test, i got the above exception. the code is: Session session = HibernateUtil.getSessionFactory().getCurrentSession(); session.beginTransaction(); System.out.println("Obtaining Record"); // String SQL_QUERY ="select a.object_type from INFORMATION_SCHEMA.SYSTEM_ALIASES as a"; List result = session.createQuery("from INFORMATION_SCHEMA.SYSTEM_ALIASES").list(); for (int i = 0; i < result.size(); i++) { SystemAliases theEvent = (SystemAliases) result.get(i); System.out.println("SystemAliases: "+theEvent.getAlias() ); } session.getTransaction().commit(); cfg filr |