postgresql « Transaction « JPA Q&A





1. Large Objects may not be used in auto-commit mode    stackoverflow.com

I have a Spring application which uses Hibernate on a PostgreSQL database. I'm trying to store files in a table of the database. It seems it stores the row with the ...

2. JPA concurrent transactions    stackoverflow.com

I'm having a problem with concurrent transactions using JPA-1.0, Hibernate and MySQL 5.0.84 (innoDB tables) and also Postgres 8.1.11 (different database for different client). I don't know if I'm missing something ...

3. Hibernate Isolation Level With Postgres 9.0    stackoverflow.com

We are using Postgres 9.1.0 with Hibernate 3.2.5. I have downloaded latest JDBC driver JDBC4 Postgresql Driver, Version 9.1-901. I had set hibernate isolation property.

<property name="connection.isolation">2</property>
which means
2=READ_COMMITTED
But it gives me error when ...

4. autocommit error under new postgresql 7.4    forum.hibernate.org

5. Postgresql "idle in transaction" annoyance.    forum.hibernate.org

Hi folks, Hoping someone can shed some light here. I have a web application that I'm developing under Tomcat 5.x using Hibernate 3 against a Postgresql 8.2 server. What I'm seeing happen is after a few "visits" to the web site I see in the Unix process table a lot of Postgres postmater processes running that are in a "idle in ...

6. PostgreSQL Slow, Deadlock Issues, Hibernate Related?    forum.hibernate.org

Author Message sentiental Post subject: PostgreSQL Slow, Deadlock Issues, Hibernate Related? Posted: Sun Aug 05, 2007 10:18 pm Newbie Joined: Sun Aug 05, 2007 9:21 pm Posts: 5 Location: Durham, NC Hi, this is my first post to the forum. I've been good about not posting superfluous things, but I've run into a problem that I can't resolve. I've ...

7. Never ending transactions:PostgreSQL Hibernate 3.2.6 Windows    forum.hibernate.org

We encounter a problem with never ending transactions on Windows. We have to force a roolback on them. We uses two phase commit protocol with XAdatasrouces. I'd like to obtain help in investigating where the problem occur in transactions processing between hibernate and PostgreSQL. Which one does not do the job as expected ? We uses the following softwares et libraries ...