public class ServiceImpl
{
public static String get(final String param1, final String param2, final String param3)
	{
		try
		{
			String value = HibernateExecutor.getInstance().execute(new HibernateAction<String>()
			{
				public String run(Session session) throws Exception
				{
					//session.setCacheMode(CacheMode.IGNORE);
					session.flush();

					Query query = session.getNamedQuery("queryGet");
					query.setParameter("par1", param1);
					query.setParameter("par2", param2);
					query.setParameter("par3", param3);
					String result = (String) query.uniqueResult();
					
					return result;
				}
			});

			return value;
		
	}
}

<hibernate-mapping>

    <class name="ServiceImpl" table="TABLE1" batch-size="500">

        <id name="synchKey" type="string" column="id"/>

	     <property name="par1" type="string" column="col1"/>
             <property name="par2" type="string" column="col2" />
	     <property name="par4" type="string" column="col3"/>
	     <property name="value" type="string" column="col4"/>

    </class>

	<query name="queryGet">
        select value from ServiceImpl as table1
            where table1.par1=:par1 and table1.par2=:par2 and table1.par3=:par3
    </query>

</hibernate-mapping>

<property name="hibernate.cache.use_query_cache">true</property>

query.setCacheable(true);

session.clear()

Query query = session.createQuery("from SharedDoc doc where doc.name = :name");

SharedDoc persistedDoc = (SharedDoc) query.setParameter("name", "first").uniqueResult();
System.out.println(persistedDoc.getName());
user1.setDoc(persistedDoc);

persistedDoc = (SharedDoc) query.setParameter("name", "first").uniqueResult();
System.out.println(persistedDoc.getName());
user2.setDoc(persistedDoc);