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

[Ovidiu Stanciu]

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:

@Entity
@Table(name="cabin", catalog="postgres", schema="public")
public class Cabin implements java.io.Serializable{
 
private int id;
private String cabinName;
private int deckLevel;

@Id
@GeneratedValue
@Column(name="ID")
public int getId() { return this.id; }
public void setId(int pk) { this.id = pk; }


@Column(name="CABIN_NAME")
public String getCabinName() { return this.cabinName; }
public void setCabinName(String name) { this.cabinName = name; }


@Column(name="CABIN_DECK_LEVEL")
public int getDeckLevel() { return this.deckLevel; }
public void setDeckLevel(int deckLvl) { this.deckLevel = deckLvl; }

}

The Session Bean:

@Stateless
public class CabinBean implements CabinBeanLocal, CabinBeanRemote{
 
@PersistenceContext(unitName="FantasyCruises")
private EntityManager em;

public Cabin findCabin(int pkey){
System.out.println("I AM HEREE!");
return em.find(Cabin.class, pkey);
}

public void createCabin(Cabin cabin){
em.persist(cabin);
}

public List getAllCabins(){

Query q = em.createNativeQuery("SELECT * FROM cabin");

return q.getResultList();
}

}

persistence.xml :

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence <a href="http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">" target="_blank" rel="nofollow">http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"></a>
<persistence-unit name="FantasyCruises" transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>java:/FantasyCruisesDS</jta-data-source>
<properties>
<property name="jboss.entity.manager.jndi.name" value="java:/FaintasyCruises"/>
<property name="hibernate.show_sql" value="true"/>
<property name="org.hibernate.hbm2ddl" value="update"/>
</properties>
</persistence-unit>
</persistence>

The Datasource

<datasources>
  <local-tx-datasource>
    <jndi-name>FantasyCruisesDS</jndi-name>
    <connection-url>jdbc :-P	 ostgresql :-P	 ostgres://127.0.0.1:5432/cruise_test</connection-url>
    <driver-class>org.postgresql.Driver</driver-class>
    <user-name>postgres</user-name>
    <password>postgres</password>
       
      <metadata>
         <type-mapping>PostgreSQL 8.0</type-mapping>
      </metadata>
  </local-tx-datasource>
 
</datasources>
 

SQL Table creation script

CREATE TABLE "CABIN"
(
  "ID" integer NOT NULL,
  "CABIN_NAME" character varying,
  "CABIN_DECK_LEVEL" integer NOT NULL,
  CONSTRAINT "ID" PRIMARY KEY ("ID")
) 
WITHOUT OIDS;
ALTER TABLE "CABIN" OWNER TO postgres;

Any help would be great. Thanks

[Mark Spritzler]

Could it be case sensitive. Meaning "cabin" does not equal "CABIN"?

Mark

[Jeanne Boyarsky]

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.)