JPA无法找到表

问题描述：

我使用的是JPA 2.0，Eclipselink 2.0，maven和weblogic 10.3.6。这里是我的persistence.xmlJPA无法找到表

<?xml version="1.0" encoding="UTF-8"?> 
<persistence version="2.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 http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"> 
    <persistence-unit name="certifications" transaction-type="JTA"> 
     <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider> 
     <jta-data-source>jdbc/com/ni/ds_edata_soa_nontx</jta-data-source> 
     <class>com.ni.apps.engineering.certification.entities.NicdsCliCertificationStg</class> 
     <class>com.ni.apps.engineering.certification.entities.NicdsCliCertificationStgPK</class> 
     <class>com.ni.apps.engineering.certification.entities.NicdsCliUpMapping</class> 
     <properties>       
      <property name="javax.persistence.jdbc.password" value="ni"/> 
      <property name="javax.persistence.jdbc.user" value="NI"/> 
      <property name="javax.persistence.jdbc.driver" value="oracle.jdbc.OracleDriver"/> 
      <property name="eclipselink.logging.level.sql" value="FINE"/>  
     </properties>  
    </persistence-unit> 
</persistence>

这是我的门面

package com.ni.apps.engineering.certification.controller; 

import java.util.List; 

import javax.persistence.EntityManager; 
import javax.persistence.EntityManagerFactory; 
import javax.persistence.Persistence; 
import javax.persistence.PersistenceUnit; 
import javax.persistence.TypedQuery; 
import com.ni.apps.engineering.certification.entities.NicdsCliCertificationStg; 
import com.ni.apps.engineering.certification.exception.CertificationException; 
import com.ni.apps.engineering.certification.utils.CertificationConstants; 

public class CertificationFacade { 

    @PersistenceUnit(unitName = "certifications") 
    private EntityManagerFactory emf; 

    public List<NicdsCliCertificationStg> getCertificationsByUpId(String upId) 
      throws CertificationException { 
     String stringQuery = new StringBuilder(
       "select c from NicdsCliCertificationStg c where c.id.contactsId = 1234").toString(); 
       //.append(upId).toString(); 
     try { 
      emf = Persistence.createEntityManagerFactory("certifications");  
      EntityManager em = emf.createEntityManager(); 
      TypedQuery<NicdsCliCertificationStg> query = em 
        .createQuery(stringQuery, NicdsCliCertificationStg.class); 
      return query.getResultList(); 
     } catch (Exception e) { 
      throw new CertificationException(
        CertificationConstants.INTERNAL_ERROR_MESSAGE, e); 
     } 
    } 
}

当我尝试运行应用程序，这是我得到

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException 
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist 

Error Code: 942 
Call: SELECT CONTACTS_ID, PROFILE_ID FROM NI.NICDS_CLI_UP_MAPPING WHERE (PROFILE_ID = ?) 
    bind => [1 parameter bound] 
Query: ReadAllQuery(referenceClass=NicdsCliUpMapping sql="SELECT CONTACTS_ID, PROFILE_ID FROM NI.NICDS_CLI_UP_MAPPING WHERE (PROFILE_ID = ?)")

任何想法，为什么它的错误找不到表格？

CNC中添加实体

package com.ni.apps.engineering.certification.entities; 

import java.io.Serializable; 
import javax.persistence.*; 
import java.util.Date; 


/** 
* The persistent class for the NICDS_CLI_CERTIFICATION_STG database table. 
* 
*/ 
@Entity 
@Table(name="NICDS_CLI_CERTIFICATION_STG", schema="NI") 
public class NicdsCliCertificationStg implements Serializable { 
    private static final long serialVersionUID = 1L; 

    @EmbeddedId 
    private NicdsCliCertificationStgPK id; 

    @Column(name="ALTERNATE_EMAIL") 
    private String alternateEmail; 

    @Temporal(TemporalType.DATE) 
    @Column(name="CERT_EXPIRATION_DATE") 
    private Date certExpirationDate; 

    @Temporal(TemporalType.DATE) 
    @Column(name="CERT_ISSUE_DATE") 
    private Date certIssueDate; 

    @Column(name="CERT_STATUS") 
    private String certStatus; 

    @Column(name="FIRST_NAME") 
    private String firstName; 

    @Column(name="LAST_NAME") 
    private String lastName; 

    @Column(name="PRIMARY_EMAIL") 
    private String primaryEmail; 

    //bi-directional one-to-one association to NicdsCliUpMapping 
    @OneToOne 
    @JoinColumn(name="CONTACTS_ID") 
    private NicdsCliUpMapping nicdsCliUpMapping; 

    public NicdsCliCertificationStg() { 
    } 

    public NicdsCliCertificationStgPK getId() { 
     return this.id; 
    } 

    public void setId(NicdsCliCertificationStgPK id) { 
     this.id = id; 
    } 

    public String getAlternateEmail() { 
     return this.alternateEmail; 
    } 

    public void setAlternateEmail(String alternateEmail) { 
     this.alternateEmail = alternateEmail; 
    } 

    public Date getCertExpirationDate() { 
     return this.certExpirationDate; 
    } 

    public void setCertExpirationDate(Date certExpirationDate) { 
     this.certExpirationDate = certExpirationDate; 
    } 

    public Date getCertIssueDate() { 
     return this.certIssueDate; 
    } 

    public void setCertIssueDate(Date certIssueDate) { 
     this.certIssueDate = certIssueDate; 
    } 

    public String getCertStatus() { 
     return this.certStatus; 
    } 

    public void setCertStatus(String certStatus) { 
     this.certStatus = certStatus; 
    } 

    public String getFirstName() { 
     return this.firstName; 
    } 

    public void setFirstName(String firstName) { 
     this.firstName = firstName; 
    } 

    public String getLastName() { 
     return this.lastName; 
    } 

    public void setLastName(String lastName) { 
     this.lastName = lastName; 
    } 

    public String getPrimaryEmail() { 
     return this.primaryEmail; 
    } 

    public void setPrimaryEmail(String primaryEmail) { 
     this.primaryEmail = primaryEmail; 
    } 

    public NicdsCliUpMapping getNicdsCliUpMapping() { 
     return this.nicdsCliUpMapping; 
    } 

    public void setNicdsCliUpMapping(NicdsCliUpMapping nicdsCliUpMapping) { 
     this.nicdsCliUpMapping = nicdsCliUpMapping; 
    } 


} 

package com.ni.apps.engineering.certification.entities; 

import java.io.Serializable; 
import javax.persistence.*; 

/** 
* The primary key class for the NICDS_CLI_CERTIFICATION_STG database table. 
* 
*/ 
@Embeddable 
public class NicdsCliCertificationStgPK implements Serializable { 
    //default serial version id, required for serializable classes. 
    private static final long serialVersionUID = 1L; 

    @Column(name="CONTACTS_ID") 
    private long contactsId; 

    @Column(name="CERT_NAME") 
    private String certName; 

    public NicdsCliCertificationStgPK() { 
    } 
    public long getContactsId() { 
     return this.contactsId; 
    } 
    public void setContactsId(long contactsId) { 
     this.contactsId = contactsId; 
    } 
    public String getCertName() { 
     return this.certName; 
    } 
    public void setCertName(String certName) { 
     this.certName = certName; 
    } 

    public boolean equals(Object other) { 
     if (this == other) { 
      return true; 
     } 
     if (!(other instanceof NicdsCliCertificationStgPK)) { 
      return false; 
     } 
     NicdsCliCertificationStgPK castOther = (NicdsCliCertificationStgPK)other; 
     return 
      (this.contactsId == castOther.contactsId) 
      && this.certName.equals(castOther.certName); 
    } 

    public int hashCode() { 
     final int prime = 31; 
     int hash = 17; 
     hash = hash * prime + ((int) (this.contactsId^(this.contactsId >>> 32))); 
     hash = hash * prime + this.certName.hashCode(); 

     return hash; 
    } 
} 

package com.ni.apps.engineering.certification.entities; 

import java.io.Serializable; 
import javax.persistence.*; 
import java.math.BigDecimal; 


/** 
* The persistent class for the NICDS_CLI_UP_MAPPING database table. 
* 
*/ 
@Entity 
@Table(name="NICDS_CLI_UP_MAPPING", schema="NI") 
public class NicdsCliUpMapping implements Serializable { 
    private static final long serialVersionUID = 1L; 

    @Id 
    @SequenceGenerator(name="NICDS_CLI_UP_MAPPING_CONTACTSID_GENERATOR") 
    @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="NICDS_CLI_UP_MAPPING_CONTACTSID_GENERATOR") 
    @Column(name="CONTACTS_ID") 
    private long contactsId; 

    @Column(name="PROFILE_ID") 
    private BigDecimal profileId; 

    //bi-directional one-to-one association to NicdsCliCertificationStg 
    @OneToOne(mappedBy="nicdsCliUpMapping") 
    private NicdsCliCertificationStg nicdsCliCertificationStg; 

    public NicdsCliUpMapping() { 
    } 

    public long getContactsId() { 
     return this.contactsId; 
    } 

    public void setContactsId(long contactsId) { 
     this.contactsId = contactsId; 
    } 

    public BigDecimal getProfileId() { 
     return this.profileId; 
    } 

    public void setProfileId(BigDecimal profileId) { 
     this.profileId = profileId; 
    } 

    public NicdsCliCertificationStg getNicdsCliCertificationStg() { 
     return this.nicdsCliCertificationStg; 
    } 

    public void setNicdsCliCertificationStg(NicdsCliCertificationStg nicdsCliCertificationStg) { 
     this.nicdsCliCertificationStg = nicdsCliCertificationStg; 
    } 


}

您是否使用'psql'尝试查询？（或任何支持Oracle的SQL客户端）。这可能是各种错误，例如无效的数据库，模式，用户，甚至更糟糕的：表格是在某种情况下声明的，Oracle期望这种情况。 – NoDataFound 2014-08-29 17:27:47

是的，我跑的查询，除了我subbed的？它显示了5678参数的错误，并且它工作得很好。 – Nacho321 2014-08-29 17:29:57

你如何定义实体？你是否覆盖默认的表名？ – NoDataFound 2014-08-29 17:49:14

答

如果使用不同的用户进行测试，那么在数据源

在数据源连接池配置中配置的用户，请转到高级部分

键入这个“初始化SQL”一节中（请参阅SQL字的指令之前，它需要）

SQL ALTER SESSION SET CURRENT_SCHEMA = DEVLPMT

见http://docs.oracle.com/middleware/1212/wls/JDBCA/jdbc_datasources.htm#CJAFCBBD

答

的错误是，WebLogic的数据源中有一个比我需要为应用程序的架构用户名和密码的不同组合。如果我找到一种方法来强制JPA使用特定的模式/用户/密码组合而不更改数据源中的用户，我会更新此答案。

相关推荐