Hi,

I am handling two applications. one is a web application written in
Hibernate and the other was a stand alone application.

The stand alone application is being called by the web application by passing some parameters to it.

These parameters that are inserted into a table that both the applications are using.

Even after commiting the transaction from the stand alone application, data was not being fetched from the web application from the table into which the stand alone application has inserted/updated.

Both applications establish theit own sessions to the database. But after commiting the transactions the data has to be visible to the web application using just a select statement, but which is not happening at this point of time.

The database wsa MS SQL Sever.

I am not sure whether any properties are to be set in the hibernate environment to make this work.

Can any one help me in this regard

Thanks in Advance.
- Raju

Hi Raju,
Did you - or anyone - managed to solve this problem?

I have two applications, both using Hibernate. One is a desktop application, the other one is a (Tomcat) web application. When a record is inserted by the web application, the session is closed and the tansaction is commited. Though, I still cannot fetch the record into my web application. By fetching, I use the SessionFactory to open a session. When I restart my desktop application, the record is fetched properly.

I use Hibernate 3.1 and Tomcat 5.5.20

Thanks in advance,

Willem

For your information, I solved this problem by setting the hibernate.connection.pool_size property to 0. You can use c3p0 instead to make it work.