postgresql « Exception « JPA Q&A

  1. JPA Q&A
  2. Exception
  3. postgresql




1. Replacing existing rows with new ones causes duplicate key exception    stackoverflow.com

everyone. I have problem replacing existing rows in table with new ones. I use JPA and PostgreSQL DB. I'm trying to delete all existing rows and then create new ones, but receive ...

2. Cache lookup failed for function 0: postgres + hibernate    stackoverflow.com


In our application, we use hibernate + postgres for persistence. Recently, executing one query seems to set Postgres in frenzy mode... The query is a simple 2 table ...

3. ClassCast Exception in java    stackoverflow.com

Iam writing a query in hibernate and my method is: 

public String a(Object[] selectedAlarmId,
            Object[] selecteddeviceID, String loggedInUser, String clientIp,
  ...

4. SQL exception with PostgreSQL Lob    forum.hibernate.org

Beginner Joined: Mon Jun 28, 2010 1:02 pm Posts: 21 I'm enhancing a Java application to store some BLOB like data. The RDBMS is a PostgreSQL 8.4. During the database schema creation for the BLOB things I do this (I've found it on the web): "CREATE DOMAIN lo AS pg_catalog.oid; -- -- For backwards compatibility, define a function named lo_oid. -- ...

5. PostgreSQL SQL Exception during buildSessionFactory()?    forum.hibernate.org

Hi, I'm using Hibernate2 on PostgreSQL7.2 for the first time (used to use MySQL), and I'm getting a very weird error: 01:33:10,001 INFO Dialect:37 - Using dialect: net.sf.hibernate.dialect.PostgreSQLDialect 01:33:10,005 INFO DriverManagerConnectionProvider:41 - Hibernate connection pool size: 20 01:33:10,008 INFO DriverManagerConnectionProvider:70 - using driver: org.postgresql.Driver at URL: jdbc:postgresql://localhost/mafo2?charSet=UNICODE 01:33:10,010 INFO DriverManagerConnectionProvider:71 - connection properties: {user=calle, password=###} 01:33:10,013 INFO SessionFactoryImpl:162 - Use outer ...