无法建立与使用JDBC

Question

我收到以下异常Progress数据库连接： -

java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Access denied(Authorisation failed) 
    at com.ddtek.jdbc.openedge.client.ddd.aw(Unknown Source) 
    at com.ddtek.jdbc.openedge.client.ddd.j(Unknown Source) 
    at com.ddtek.jdbc.openedge.OpenEdgeImplConnection.j(Unknown Source) 
    at com.ddtek.jdbc.openedgebase.BaseConnection.b(Unknown Source) 
    at com.ddtek.jdbc.openedgebase.BaseConnection.k(Unknown Source) 
    at com.ddtek.jdbc.openedgebase.BaseConnection.b(Unknown Source) 
    at com.ddtek.jdbc.openedgebase.BaseConnection.a(Unknown Source) 
    at com.ddtek.jdbc.openedgebase.BaseDriver.connect(Unknown Source) 
    at java.sql.DriverManager.getConnection(DriverManager.java:664) 
    at java.sql.DriverManager.getConnection(DriverManager.java:247) 
    at com.ncr.sj250216.JdbcTest.main(JdbcTest.java:18) 

有我的代码没有编译时错误，我使用权瓶当引用的库。

 package com.ncr.sj250216; 
     import java.sql.*; 
     public class JdbcTest 
     { 
      public static String  
URL="jdbc:datadirect:openedge://sun3899.daytonoh.ncr.com:28409;DatabaseName=dispatch"; 
    public static String username="CSMSRUP"; 
    public static String password=null; 
    public static void main(String [] args) 
    { 

    try 
     { 

     Class.forName ("com.ddtek.jdbc.openedge.OpenEdgeDriver"); 
     System.out.println("Driver loaded"); 
     Connection conn = DriverManager.getConnection(URL,username,password); 
     System.out.println("Connected"); 
     Statement stmt = conn.createStatement(); 
     System.out.println("Statement created"); 
     ResultSet rs = stmt.executeQuery("select remark from pub.dupdate_remarks"); 
     System.out.println("ResultSet : \n"); 
     while (rs.next()) 
     { 
     System.out.println(rs.getString(1)); 
     } 
     System.out.println("AFTER CRUISING THROUGH THE RESULT SET"); 
     rs.close(); 
     stmt.close(); 
     conn.close(); 
     } 
     catch (Exception x) 
     { 
      x.printStackTrace(); 
     } 
    } 
} 

Answer 1

Access denied和Authorization failed意味着你要么有错误的用户ID &密码，或者您正试图连接到错误分贝。

如果您有权访问该数据库上运行，你可以使用进度sqlexp命令行工具来测试您的凭据服务器：

sqlexp -user userName -password passWord -db dnName -S servicePort 

或者你可以使用任何流行的基于Windows的SQL查询工具来尝试连接...