postgresql « Transaction « Spring Q&A

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

I'm working on a application which uses spring and hibernate. We are using postgresql as the database. When I try to insert a record into a table which has a OID column ...

2. Spring / JPA / Hibernate / PostgreSQL throws EntityNotFoundException in nested transaction    stackoverflow.com

I have the following setup: Spring -> JPA -> Hibernate -> PostgreSQL I've created a service layer which offers some "@Transactional" methods to insert data. The data is in the concrete case a ...

3. @Transactional Spring Junit test not doing rollback    stackoverflow.com

I try to set up a Junit test case for my dao layer. However, I do NOT want the test data to be actually persisted to the DB. So I thought I should ...

4. sequence nextval in read-only transactions- postgresql 9    stackoverflow.com

i recently upgraded to postgresql9 from postgresql8. i have a method marked as @Transactional(readonly=true) and call nextval on the sequence. it worked fine in Postgres8 but it fails in Postgres9. I looked ...

5. second DB action freezes execution in transaction    stackoverflow.com

we have been fighting with this on and off now for weeks. first the code,

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
    ...

6. second DB action freezes execution in transaction take two    stackoverflow.com

this question started here second DB action freezes execution in transaction you can see my code there. i have completely reconfigured spring and started analyzing the database. i think my problem is ...

7. specify what database a specific table is in with hibernate    stackoverflow.com

i inherited a postgres data model that looks like this

foo.public.user
foo.public.token

bar.public.data1
bar.public.data2

8. org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode    stackoverflow.com

I am using Spring , JPA, Hibernate, Postgresql. I can upload/insert a file to the database. But I got the error when tried to access the file.

EVERE: Servlet.service() for servlet ...

9. Rolling back transactions on checked and unchecked exceptions    stackoverflow.com

I'm using Spring JDBC Template along with PostgreSQL. Below is my configuration Datasource and Transaction Settings:

<bean id="databasePropertyConfigurer"
          class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
      ...

10. Using PostgreSQL Rules/Triggers for debugging purposes    stackoverflow.com

An application I am trying to support is currently running into unique constraint violations. I haven't been able to reproduce this problem in non-production environments. Is it reasonable, for debugging purposes, ...

11. JDBC Template SELECT for UPDATE PostgreSql (lock row for read)    forum.springsource.org

JDBC Template SELECT for UPDATE PostgreSql (lock row for read) Hi everybody, i would like to select a table row and lock it in same time. I read on some post ...

12. spring transactions, hibernate, postgresql looks like record locking issue    forum.springsource.org

spring transactions, hibernate, postgresql looks like record locking issue ive been working with a few people on stackoverflow on this issue and still am coming up dead. here are the threads, ...

13. JDBC + Hibernate transactions postgresql/tomcat    forum.springsource.org

JDBC + Hibernate transactions postgresql/tomcat Hi, I'm researching Spring (never used) reading Pro Java Dev (by Rod Johnson et al - Great book btw). I'd like to have Spring manage transactions ...

14. JTA with JOTM & PostgreSQL 8.1    forum.springsource.org

Is anyone here using JTA succesfully using JOTM and PG 8.1? From what I read around the web it is pretty difficult to use JTA with open source databases. Should I ...

15. Postgresql 8.1 + Hibernate and rollback issue    forum.springsource.org

Oct 4th, 2006, 01:08 AM #1 theqmaster View Profile View Forum Posts Private Message Member Join Date Dec 2005 Location Twin Cities, Minnesota Posts 35 Postgresql 8.1 + Hibernate and rollback ...

16. Spring + Ibatis + Postgresql --> Transaction read-only    forum.springsource.org

Spring + Ibatis + Postgresql --> Transaction read-only Hi, I need your help. I'm working with Spring 2.0. + Ibatis 2.3.0 + postgresql 8.2, and the update operation returns org.postgresql.util.PSQLException: ERROR: ...