error no hibernate session bound to thread | java php laravel linux mysql sql bootstrap html css query java php laravel linux mysql sql bootstrap html css query: error no hibernate session bound to thread

Wednesday, September 26, 2012

error no hibernate session bound to thread

Ngoding hibernate dan spring dapat error begini

SEVERE: >>org.hibernate.HibernateException: No Hibernate Session bound to thread, and configuration does not allow creation of non-transactional one here
Tambahkan @Transaction pada method yang terjadi error

SEVERE: >>org.hibernate.QueryException: Not all named parameters have been set: [noMesin] [from StockRinci a where a.noMesin = :noMesin]

Awalnya coding query seperti ini :

[sourcecode language="java"]@Transactional
public StokRinci findByNomesin(String noMesin) {
String stringQuery = "from StokRinci a where a.noMesin = :noMesin";
Query query = getHibernateTemplate().getSessionFactory().getCurrentSession().createQuery(stringQuery);

StokRinci st = (StokRinci) query.uniqueResult();
return st;
}[/sourcecode]

ya iya lah error :) ,, kan di stringQuery mendifinisikan parameter tp pada object query kok ga dikasih parameter ,

OK bos,, saya tambahkan parameter ini aja

[sourcecode language="java"]query.setParameter("noMesin", noMesin);[/sourcecode]
[sourcecode language="java"]@Transactional
public StokRinci findByNomesin(String noMesin) {
String stringQuery = "from StokRinci a where a.noMesin = :noMesin";
Query query = getHibernateTemplate().getSessionFactory().getCurrentSession().createQuery(stringQuery);
query.setParameter("noMesin", noMesin);
StokRinci st = (StokRinci) query.uniqueResult();
return st;
}[/sourcecode]

Ops ,, beres ternyata :)

Alhamdulillah.

No comments:

Post a Comment

saifiahmada.com adalah blog belajar programming Indonesia, membahas lengkap materi bahasa pemrograman: code HTML, CSS, Bootstrap, Desain, PHP, MySQL, coding Java, Query, SQL, dan dunia linux