[stackoverflow] [progress Openedge Abl] Not Able To Establish Connection With Progress...

I am getting the following exception :-

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)

There is no compile time error in my code, i am using the right jars as referenced libraries.

package com.ncr.sj250216;
import java.sql.*;
public class JdbcTest
{
public static String


URL="jdbc:datadirectpenedge://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();
}
}


}

Continue reading...