java.sql.SQLException: ORA-00942: table or view does not exist with JPA entityManager.createQuery()

Question

I am using JPA createquery API to fetch the data.

Here is my query data

    @PersistenceContext
    EntityManager entityManager;
    @Override
    public List<String> fetchAllReleaseNumbers() {

        Query query = entityManager.createQuery("SELECT release FROM ReleaseModel", String.class);

        return query.getResultList();
    }

and here is my pojo class.

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "dbname.tablenamefromDB")
public class ReleaseModel {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "dbcolumnname", unique = true, nullable = false)
    private String release;

    @Column(name = "dbcolumnname")
    private String releaseDesc;

    @Column(name = "dbcolumnname")
    private Integer releaseStatus;

    @Column(name = "dbcolumnname")
    private Integer releaseMode;


    public String getRelease() {
        return release;
    }

    public void setRelease(String release) {
        this.release = release;
    }

    public String getReleaseDesc() {
        return releaseDesc;
    }

    public void setReleaseDesc(String releaseDesc) {
        this.releaseDesc = releaseDesc;
    }

    public Integer getReleaseStatus() {
        return releaseStatus;
    }

    public void setReleaseStatus(Integer releaseStatus) {
        this.releaseStatus = releaseStatus;
    }

    public Integer getReleaseMode() {
        return releaseMode;
    }

    public void setReleaseMode(Integer releaseMode) {
        this.releaseMode = releaseMode;
    }

}

Though the table exists in db its throwing not exist.Any ideas where I made mistake. I tried whether any aliases can be given to the table name. I am using pojo class name only for createQuery.

TIA.

try entityManager.createQuery("SELECT a.release FROM ReleaseModel a", String.class); — Balaji Krishnan
try to configure entity name as ReleaseModel and try to execute it again. — user1001
@PrasadReddy I didn't get you.Can you please post here as a snippet so that it would be helpful — Pradeep

v.ladynev v.ladynev · Accepted Answer · 2017-05-26T13:11:48

You should specify a schema name by this way

@Table(schema = "dbname", name = "tablenamefromDB")

You have an incorrect mapping:

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "dbcolumnname", unique = true, nullable = false)
private String release;

I think String can't be auto generated. Also all your columns have dbcolumnname name.

java.sql.SQLException: ORA-00942: table or view does not exist with JPA entityManager.createQuery()

1 Answers