hibernate 10 comments

Problem Runing the following Hibernate’s annotation sequence generator with PostgreSQL database. @Id @Column(name="user_id", nullable=false) @GeneratedValue(strategy = GenerationType.SEQUENCE ,generator="account_user_id_seq") private Integer userId; Hits the following Unknown Id.generator exception. Caused by: org.hibernate.AnnotationException: Unknown Id.generator: account_user_id_seq at org.hibernate.cfg.BinderHelper.makeIdGenerator(BinderHelper.java:413) at org.hibernate.cfg.AnnotationBinder.bindId(AnnotationBinder.java:1795) at org.hibernate.cfg.AnnotationBinder.processElementAnnotations(AnnotationBinder.java:1229) at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:733) The sequence “account_user_id_seq” is created in PostgreSQL database, what caused the above exception? Solution […]

Read more org.hibernate.AnnotationException: Unknown Id.generator
hibernate 18 comments

Question There are many developers asking about Hibernate SQL parameter value question. How to display the Hibernate SQL parameter values that passed to database? Hibernate just display all parameter values as question mark (?). With show_sql property, Hibernate will shows all generated SQL statements, but not the SQL parameter values. For example Hibernate: insert into […]

Read more How to display hibernate sql parameter values – P6Spy
hibernate 9 comments

Problem HibernateTemplate code … getHibernateTemplate().find("from Domain d where d.domainName = :domainName", domainName); When i execute the above code, i hit the following error message java.lang.IndexOutOfBoundsException: Remember that ordinal parameters are 1-based! … at org.hibernate.impl.AbstractQueryImpl.determineType(AbstractQueryImpl.java:397) at org.hibernate.impl.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:369) Solution I go inside and study HibernateTemplate.java file and find below code public List find(final String queryString, final Object[] […]

Read more Remember that ordinal parameters are 1-based! – HibernateTemplate