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

Question

我使用JPA连接TOMCAT部署的webapp到Oracle数据库11gR2。我得到以下错误:

javax.persistence。PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 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"/>
<property name="eclipselink.target-server" value="None"/> <property name="eclipselink.logging.level.sql" value="FINE"/> <property name="eclipselink.logging.parameters" value="true"/> </properties>
</persistence-unit> </persistence>

我提供的凭据绝对是正确的，因为我可以使用它们连接到SQL开发人员和SQL Plus。请帮助!我已经为这件事纠结了好几个小时了。

我也试着关闭大小写敏感，它似乎也不起作用。

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

    `<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. xml "。Url "属性对我来说有点奇怪。

尝试用"jdbc:oracle:thin:@localhost:1521:tdoc"代替"jdbc:oracle:thin:localhost:1521:tdoc"(见缺少的"@"?)