My problem is --
1. I have a button "View List" on a JSP by clicking it I am displaying records in a select box.Data is coming from let say Table1.
2. I am inserting records into same Table1.
3. Now again If I click on "View List" this time newly inserted record is not coming in the. My code details are as follows:

A) To Insert records in the Table1 : I am using following code:

public static void logTestExecutionStatus(JUnitExecutionStatusDTO jexecDto) {
// TODO Auto-generated method stub
Session session = null;
Transaction transaction = null;
try
{

session = HibernateUtil.getSessionFactory().openSession();
transaction = session.beginTransaction();
TestExecution testExecution = new TestExecution();
testExecution.setTestSuitId(jexecDto.getTestSuitId());
testExecution.setExecutionStartTime(jexecDto.getExecutionStartTime());
testExecution.setExecutionEndTime(jexecDto.getExecutionEndTime());
testExecution.setExecutionFlag(jexecDto.getExecutionFlag());
session.saveOrUpdate(testExecution);
transaction.commit();

}
catch(Exception e)
{
transaction.rollback();
e.printStackTrace();
}
finally
{
session.close();
}

}

B) To fetching records from Table1 : I am using following code :


public static List fetchAllTestSuitesForTestReports(){

List testSuiteList = new ArrayList();
Session session = null;
SessionFactory sessionFactory = null;
try{
session = HibernateUtil.getSessionFactory().openSession();
JUnitTestSuiteDTO jTestSuiteDto = new JUnitTestSuiteDTO();

Query query = session.createSQLQuery(JUnitSQLQuery.VIEW_ALL_TESTSUITE);

List evnt = query.list();
for (Iterator iterator = evnt.iterator(); iterator.hasNext();) {
Object[] object = (Object[]) iterator.next();
jTestSuiteDto = new JUnitTestSuiteDTO();
//jTestSuiteDto.setTestSuiteID(Long.valueOf( ((Integer)object[0]).toString() ));
jTestSuiteDto.setTestExecutionId(Long.valueOf( ((Integer)object[1]).toString() ));
jTestSuiteDto.setTestSuiteName((String)object[2]);
jTestSuiteDto.setTestSuitAndExeID((String)object[3]);
jTestSuiteDto.setCreatedOn((Date)object[4]);
testSuiteList.add(jTestSuiteDto);
}
}catch(Exception e){
e.printStackTrace();
}finally{
session.close();
}
return testSuiteList;
}



public static String VIEW_ALL_TESTSUITE = " select tsd.test_suit_id, t.test_exe_id," +
" CONCAT(tsd.test_suit_name, ' --> ', t.exe_start_time ) as suite_name," +
" CONCAT(tsd.test_suit_id, ':', t.test_exe_id ) as suite_id, tsd.DATE_CREATED" +
" from" +
" test_suit_details tsd, test_suit_execution_status t" +
" where" +
" tsd.deleted_flag IS NULL and tsd.test_suit_id = t.test_suite_id";

C) My hibernate-cfg.xml is as follows.

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.password">root</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/junit_generator_v1</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.show_sql">true</property>
<mapping resource="com/jUnitFramework/classes/egs/data/MethodTestcaseDetails.hbm.xml" />
<mapping resource="com/jUnitFramework/classes/egs/data/TestSuitExeReport.hbm.xml" />
<mapping resource="com/jUnitFramework/classes/egs/data/MethodArgument.hbm.xml" />
<mapping resource="com/jUnitFramework/classes/egs/data/ArgumentData.hbm.xml" />
<mapping resource="com/jUnitFramework/classes/egs/data/TestSuitDetails.hbm.xml" />
<mapping resource="com/jUnitFramework/classes/egs/data/PackageDetails.hbm.xml" />
<mapping resource="com/jUnitFramework/classes/egs/data/TestReport.hbm.xml" />
<mapping resource="com/jUnitFramework/classes/egs/data/ClassDetails.hbm.xml" />
<mapping resource="com/jUnitFramework/classes/egs/data/MethodDetails.hbm.xml" />
<mapping resource="com/jUnitFramework/classes/egs/data/TestExecution.hbm.xml" />
</session-factory>

</hibernate-configuration>


I tried some properties like :
<property name="hibernate.cache.use_query_cache">false</property>
<property name="hibernate.cache.use_second_level_cache">false</property>

in hibernate-cfg.xml to disable querycache and second level cache as I thought hibernate is doing querycache thats why latest record is not coming but not able to resolve the problem.
I am using hibernate3.

Please help me out to resolve this problem.

-Ram Shukla

I am having almost the exact same problem!

IDE: Rational Software Architect for websphere portal v7.5
Server: WebSphere portal v6.1

I set up a JDBC datasource in the admin console that uses a type 4 connection to a remote DB2 database.

I am using JPA annotations. I am injecting the entity manager into my bean that is running in a JSR 286 JSF portlet with request scope. I have a onetomany relationship from Parent to Child, such that a Parent can have many children.



My persistence.xml




My application.xml



I have a JSP page that contains a table that has a value attribute set to a collection from a backing bean that is set from the result returned by getItems. I can page through all of the data just fine. I Have an ajax refresh button which reloads the collection that the table pages through by calling getitems again. If i change a field value of one of the records (directly via winsql) and subsequently refresh the table, I can see that getitems gets called and that hibernate generates the sql from my query and fetches the results, but the results do not reflect the recent change to the table. Logging out and logging back in also does not cause the query to fetch the recent results. The only thing that allows the portlet to get the latest results is restarting websphere portal server. I have been reading up on session cacing, query cacing and second-level caching. I do not have any of these caching options configured.

At first I thought that this was a WebSphere portal issue, but then I started reading about query cache in hibernate and thought that this may be the cause. Now I have no idea.

Offtopic: does anyone have a clue as to why q1 must be called before q2? See getItems code above.

Sincerely,
bugincode

I found a solution that works for me.
I found that I had to call this.m_entityManager.clear(); before making the query. I have not yet read up on exactly what clear does. I am assuming that it is calling clear on an internal collection. I am assuming that this collection is probably a cache of query results. I find it odd that such a cache would exist, since I have not turned on query cache. Can anyone explain the correct way for us to get the behaviour that we are looking for? If not calling clear means that the results will be returned from a cache, but the query cache functionality is turned off, then I do not understand the thinking behind such an implemintation.

Oohh.. I hope the above is readable. I have been getting very little sleep for over a month now.

Sincerely,

bugincode.

Okay, so I have done a lot more research on this issue and i have discovered the proper solution. calling clear on the entity manager worked, but it is certainly not the proper solution. I found that with the above configuraiton none of my entities were being persisted, even if I explicitly called persist from the entitymanager, which I should not have to do while using jpa in this way. What i found is that since my bean is request scoped, and I require attached entities accross multiple requests, I must create a persistence context that is of type extended if this is to work with a container managed entity manager. So, to make it so that i no longer had to call


I changed

to
and got rid of the EntityManagerFactory all together. Note that if you use the EntityManagerFactory to create a entity manager then you are creating an application type entity manager, which is not what i wanted in this case.

I hope that helps.

Hi,
I am getting probelm while I am using hibernate APIs for native query.I am getting stale data.
Probelm statement is:
1. Let say I have two table : Table1 and Table2
2. In jsp I have two buttons: "Insert" and "Show List"
3. For example let say both table have 2 rows and if I click on "Show List" it is fetching data using hibernate native query API's so at this point it is showing two records thats fine for me.
4. Now if I click on "Insert" button it is inserting 1 record in both the table (Table1 and Table2).
5. Now I check into the database both the tables are updated with new inserted record, and at this point if I click on "Show List" button then it is fetching only 2 records not the third one which is inserted recently.
6. To fetching data from Table1 and Table2 I am using session.createSQLQuery("QueryString").
here I am using simple join in SQL Query.
7. This problem I am getting if I use joins in sql query for single table it is working fine.I am not able to resolve this problem.

Code details:







Please help me out to resolve this problem.