Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

org. postgresql. util. PSQLException: ERROR: relation does not exist

 
Ovidiu Stanciu
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello.

I'm trying to set up a simple EJB3 example using JBoss 4.2.1 JPA and a PostgreSQL 8.2 server.

I have a DB named cruise_test and a table CABIN for which i'm trying to create an entity.

I created a session bean which runs a native query to get all cabins.

The error is
org.postgresql.util.PSQLException: ERROR: relation "cabin" does not exist

Consider the following listings:

The Cabin Entity:



The Session Bean:



persistence.xml :


The Datasource


SQL Table creation script


Any help would be great. Thanks
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Could it be case sensitive. Meaning "cabin" does not equal "CABIN"?

Mark
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34672
367
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Bumping this thread because I found it in a search as I was looking for the same error message.

In postgres, tables are considered lowercase unless you use quotes. So yes, Mark is correct. (My problem was that I hadn't loaded the DDL I thought I did.)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic