java - Tomcat，Oracle 数据库 11gR2 的登录被拒绝

Question

我通过将 TOMCAT 部署的 Web 应用程序连接到 Oracle 数据库 11gR2 来使用 JPA。我收到以下错误。

javax.persistence.PersistenceException:异常 [EclipseLink-4002](Eclipse 持久性服务 - 2.5.2.v20131113-a7346c6):org.eclipse.persistence.exceptions.DatabaseException内部异常:java.sql.SQLException:ORA-01017:用户名/密码无效；登录被拒绝

我的persistence.xml是

<?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="tdoc" transaction-type="RESOURCE_LOCAL">
<provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
<class>mil.osd.dmdc.diss.tdoc.model.AbstractModelObject</class>
<class>mil.osd.dmdc.diss.tdoc.model.GeneratedFile</class>
<class>mil.osd.dmdc.diss.tdoc.model.Template</class>
<class>mil.osd.dmdc.diss.tdoc.model.TemplateFile</class>
<properties>
<property name="eclipselink.jdbc.bind-parameters" value="false"/>
<property name="javax.persistence.jdbc.driver" value="oracle.jdbc.OracleDriver"/>
<property name="javax.persistence.jdbc.url" value="jdbc:oracle:thin:localhost:1521:tdoc"/>
<property name="javax.persistence.jdbc.user" value="test"/>
<property name="javax.persistence.jdbc.password" value="TEST"/><br/>
<property name="eclipselink.target-server" value="None"/>
<property name="eclipselink.logging.level.sql" value="FINE"/>
<property name="eclipselink.logging.parameters" value="true"/>
</properties><br/>
</persistence-unit>
</persistence>

我提供的凭据绝对正确，因为我可以使用它们连接到 SQL Developer 和 SQL Plus。请帮忙!我已经坚持了几个小时。

我也试过关闭区分大小写，但它似乎也不起作用。

编辑我忘了说我也在使用 maven 来构建项目，它看起来像这样以防万一我对 eclipselinks 的依赖是错误的

    `<project xmlns="http://maven.apache.org/POM/4.0.0"      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>testdata</groupId>
  <artifactId>testdata</artifactId>
  <version>1.0</version>
  <packaging>war</packaging>
  <name>testdata</name>
  <dependencies>
    <dependency>
      <groupId>org.eclipse.persistence</groupId>
      <artifactId>org.eclipse.persistence.jpa</artifactId>
      <version>2.5.2-M1</version>
    </dependency>
    <dependency>
      <groupId>com.oracle</groupId>
      <artifactId>ojdbc6</artifactId>
      <version>11.2.0</version>
    </dependency>
    <dependency>
      <groupId>org.apache.directory.studio</groupId>
      <artifactId>org.apache.commons.io</artifactId>
      <version>2.4</version>
    </dependency>
    <dependency>
        <groupId>org.glassfish</groupId>
        <artifactId>javax.faces</artifactId>
        <version>2.1.13</version>
    </dependency>
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>servlet-api</artifactId>
      <version>2.5</version>
      <scope>provided</scope>
    </dependency>
  </dependencies>
  <build>
    <finalName>${project.artifactId}</finalName>
    <plugins>
      <plugin>
        <artifactId>maven-compiler-plugin</artifactId>
        <version>3.1</version>
        <configuration>
          <source>1.7</source>
          <target>1.7</target>
        </configuration>
      </plugin>
      <plugin>
        <artifactId>maven-war-plugin</artifactId>
        <version>2.3</version>
        <configuration>
          <warSourceDirectory>src/main/webapp</warSourceDirectory>
          <failOnMissingWebXml>true</failOnMissingWebXml>
        </configuration>
      </plugin>
    </plugins>
  </build>
</project>`

Answer 1

我觉得你的“javax.persistence.jdbc.url”属性有点奇怪。

尝试“jdbc:oracle:thin:@localhost:1521:tdoc”而不是“jdbc:oracle:thin:localhost:1521:tdoc”(看到缺少的“@”？)