Tag Archives: hibernate

SQL Error: 17006, SQLState: null Invalid column name in Hibernate

Recently I've got the following error during SQL named query execution: SQL Error: 17006, SQLState: null Invalid column name In order to track the problem down I enabled SQL logging and collected SQL query issued, then run it under SQL … Continue reading

Posted in en | Tagged , , | 3 Comments

Custom CacheProvider for Hibernate based on Websphere DistributedMap

Hibernate is a library that maps database tables to Java objects. Is performance problems arise it's very easy to add database caching for application using Hibernate (just few options in config file). Hibernate is shipped with EHCache, default cache implementation. … Continue reading

Posted in en | Tagged , , | 6 Comments

Websphere Extreme Scale + Hibernate = ?

Recently I was asked to integrate WXS (Websphere Extreme Scale, commercial cache implementation from IBM) into existing WPS (Websphere Process Server)-based project to implement read-only non-distributed cache (one independent cache instance per JVM). The idea is to plug cache implementation … Continue reading

Posted in en | Tagged , , | 3 Comments

Second Level Cache For SQL Queries Under Hibernate

Second level cache in Hibernate allows to greatly speed-up your application by minimizing number of SQL queries issued and serving some results from in-memory cache (with optional disk storage or distributed cache). You have option to plug in different cache … Continue reading

Posted in en | Tagged , , , , , | Leave a comment

How To Debug Hibernate SQL Queries With Parameters

I bet everyone knows how to enable SQL logging for Hibernate. If you add this parametr to Hibernate configuration: <property name="hibernate.show_sql">true</property> you will see queries like this in log file: select roles0_.EntityKey as Entity9_1_, roles0_.ENTITYKEY as ENTITY9_168_0_ from USERROLE roles0_ … Continue reading

Posted in en | Tagged , , , | 5 Comments