1. Can Hibernate work with MySQL's "ON DUPLICATE KEY UPDATE" syntax? stackoverflow.comMySQL supports an " |
2. HQL NOT IN Syntax Problem w/MySQL forum.hibernate.orgRegular Joined: Wed Dec 17, 2003 1:58 pm Posts: 101 Query: Code: Query query = session.createQuery("from cmcflex.salesweb.model.admin.UserType u " + ... |
3. Hibernate generates erroneous SQL syntax for MySQL 4.0.22 forum.hibernate.orgNewbie Joined: Tue Apr 05, 2005 3:16 pm Posts: 2 Location: Philadelphia, PA USA I am relatively new to Hibernate and am using in conjuction with the Spring framework. I have loved the ease of use the pairing provides and was happy to complete my first project recently. I developed the project locally using Eclipse running Tomcat 4.1 and MySQL 4.1.7 ... |
4. mysql syntax changes starting on 5.0.12 forum.hibernate.orgselect count(activity0_.activity_id) as col_0_0_ from activity activity0_, appointment_scheduler appointmen1_ inner join activity_velox_info activityve2_ on activity0_.act_velox_info_id=activityve2_.act_velox_info_id inner join activity_schedule activitysc3_ on activity0_.act_sch_id=activitysc3_.act_sch_id inner join micro_area microarea4_ on activityve2_.micro_area_id=microarea4_.micro_area_id inner join micro_area_scheduler microareas5_ on appointmen1_.appsch_id=microareas5_.appsch_id inner join micro_area microarea6_ on microareas5_.micro_area_id=microarea6_.micro_area_id, periods_of_day periodsofd7_ where (appointmen1_.appsch_id=1 )AND(activity0_.state<>'TRIAGE' )AND((activity0_.type='INSTALL' )OR(activity0_.TYPE='SERVICE' ))AND(activity0_.promise_date>='2006-2-10' )AND(activity0_.promise_date<'2006-2-11' )AND(periodsofd7_.code='FIRST_HOUR' and activityve2_.period_of_day_id=periodsofd7_.period_of_day_id)AND(microarea4_.micro_area_id IN(microarea6_.micro_area_id))AND(activitysc3_.scheduler_id=appointmen1_.appsch_id ) |