OS Version
WinXP/SP2 - Java 1.6
Hibernate version:
Jboss 4.0.5 AS
Mapping documents:
Code:
<hibernate-mapping package="test">
<class name="ArtistBiog" lazy="true" table="artistbiogtbl">
<cache usage="read-write"/>
<id name="ID" column="artist_id">
<generator class="assigned"/>
</id>
<version name="Version" column="version" type="integer" unsaved-value="negative"/>
<property name="ArtistBiog" column="artist_biog" type="text" />
</class>
</hibernate-mapping>
Cache type/VersionI have installed Ehcache 1.3.0-beta into C:\jboss-4.0.5\server\default\deploy\ejb3.deployer.
Ehcache MapInstalled in C:\jboss-4.0.5\server\default\deploy\ejb3.deployer.
Code:
<ehcache xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="ehcache.xsd">
<diskStore path="java.io.tmpdir"/>
<defaultCache
maxElementsInMemory="10000"
eternal="false"
timeToIdleSeconds="120"
timeToLiveSeconds="120"
overflowToDisk="true"
maxElementsOnDisk="10000000"
diskPersistent="false"
diskExpiryThreadIntervalSeconds="120"
memoryStoreEvictionPolicy="LRU" />
<cache name="test.ArtistBiog"
maxElementsInMemory="10000"
maxElementsOnDisk="1000"
eternal="false"
overflowToDisk="true"
timeToIdleSeconds="300"
timeToLiveSeconds="600"
memoryStoreEvictionPolicy="LFU"
/>
</ehcache>
Code between sessionFactory.openSession() and session.close():Code:
try {
InitialContext ctx = new InitialContext();
sessionfactory = (SessionFactory)ctx.lookup("java:/hibernate/SessionFactory");
session = sessionfactory.openSession();
transaction = session.beginTransaction();
//Get Artist details
artistbiog = (ArtistBiog)session.load(ArtistBiog.class, artistbiog_id);
transaction.commit();
session.close();
} catch (Exception e) {
throw new RuntimeException("Exception in Hibernate:: " + e.getMessage(), e);
}
return artistbiog;
Full stack trace of any exception that occurs:None to report!
Name and version of the database you are using:PostgreSQL 8.2
The generated SQL (show_sql=true):Code:
22:29:11,859 INFO [STDOUT] Hibernate: select user0_.user_id as user1_9_, user0_
.first_name as first2_9_, user0_.last_name as last3_9_, user0_.address1 as addre
ss4_9_, user0_.address2 as address5_9_, user0_.address3 as address6_9_, user0_.s
tateprovince as statepro7_9_, user0_.postcode as postcode9_, user0_.country as c
ountry9_, user0_.email as email9_, user0_.home_telephone as home11_9_, user0_.mo
bile_telephone as mobile12_9_, user0_.date_joined as date13_9_, user0_.user_ip a
s user14_9_, user0_.username as username9_, user0_.userpassword as userpas16_9_
from usertbl user0_ where user0_.username=? and user0_.userpassword=?
I have simply, he says smiling, migrated from Jboss 4.0.3 to 4.0.5. The exact same spec as mentioned above is used on the 4.0.3 version of my project with no problems at all.
Any page which requests data from the database simply hangs, and there are no generated error messages. For example on my login page, a user enters their user details and submits the form. In the logs you can see that the request has been made to the database by the generated SQL, but the page does not advance to the next stage, it simply stays where it is. Data has been sent to the database but nothing is coming back.
I am of the opinion that this is an Ehcache 1.3.0-beta compatability issue?
Any ideas how to rectify this issue?
--
Regards
Andrew