Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
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: 17309
11
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
Sheriff
Posts: 36396
453
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
Boost this thread!