Hibernate uses transactional reads and I think it can cause lock on table if you do not end a transaction, and try to use cache to optimize readonly operations.
> I am executing select query do I require to open a transaction for that? > > One more thing need to ask is one of the table has the data which is not > going to change. I have created a helper class for accessing the data. I > haven't written any update or insert queries in the helper class which would > modify the persistent data. When I display the data through tapestry. The > first time it works fine but the second time it fires the update statement > on that the data which I don't want to do. > > I don't know how Is it the behaviour of the Hibernate if the data in > Hibernate bean has been modified it fires insert or update statement? > Thanks for the help. > I am using Hibernate 2.0 beta 5 > > ----- Original Message ----- > From: "Juozas Baliuka" <[EMAIL PROTECTED]> > To: "Prasad Iyer" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Wednesday, September 17, 2003 9:13 PM > Subject: Re: [Hibernate] Problem > > > > Have you tried to commit transaction ? > > > > ----- Original Message ----- > > From: "Prasad Iyer" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Wednesday, September 17, 2003 1:34 PM > > Subject: [Hibernate] Problem > > > > > > Hi, > > I am using Microsoft SQL Server as a database and Hibernate version 2.0.5 > > beta. We are facing a problem that whenever a query get executed we get > the > > result but while running it for the second time it hangs. Microsoft SQL > > Server service needs to be restarted. > > Can anybody help me > > regards > > prasad chandrasekaran > > > > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > hibernate-devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/hibernate-devel ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel