Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

Linux Intel
OpenEdge 10.0B

SYMPTOM(s):

Errors compiling Java code to connect to a Progress database.

Java exception generated:
DriverManager.getConnection("jdbc:jdbcprogress:T:localhost:2500:libt")
trying driver[className=com.progress.sql.jdbc.JdbcProgressDriver,com.progress.sql.jdbc.JdbcProgressDriver@cf2c80]
SQLException:SQLState(102) vendor code(0)
java.sql.SQLException: [JDBC OpenEdge Driver]: 251
at com.progress.sql.jdbc.JdbcProgress.createSQLException(JdbcProgress.java:6636)
at com.progress.sql.jdbc.JdbcProgress.standardError(JdbcProgress.java:6821)
at com.progress.sql.jdbc.JdbcProgress.SQLGetInfoString(JdbcProgress.java:4137)
at com.progress.sql.jdbc.JdbcProgress.SQLGetInfoString(JdbcProgress.java:4105)
at com.progress.sql.jdbc.JdbcProgressConnection.getODBCVer(JdbcProgressConnection.java:1252)
at com.progress.sql.jdbc.JdbcProgressProgressDatabaseMetaData.getTypeInfo(JdbcProgressDatabaseMetaData.java.3715)
at com.progress.sql.jdbc.JdbcProgressConnection.buildTypeInfo(JdbcProgressConnection.java:1579)
at com.progress.sql.jdbc.JdbcProgressConnection.initialize(JdbcProgressConnection.java:402)
at com.progress.sql.jdbc.JdbcProgressDriver.connect(JdbcProgressDriver.java:171)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at JDBCtest.main(JDBCtest.java:25)
getConnection:returning driver[className=com.progress.sql.jdbc.JdbcProgressDriver,com.progress.sql.jdbc.JdbcProgressDriver@cf2c80]

The Java code:
import java.io.*;
import java.sql.*;
import java.util.*;

public Class JDBCtest{
public static void main(String[] args){
String url = null;
String userid = null:
String passwd = null;
String qu ery = null;

url="jdbc:jdbcprogress:T:localhost:2500:libt";
userid = "sysadmin";
passwd = "system";

try{
Class.forName(com.progress.sql.jdbc.JdbcProgressDriver");
PrintStream pStream = new PrintStream(System.out,true));

Connection con = DriverManager.getConnection(url,userid,passwd);
}
catch(Exception e){
System.out.println(e.toString());
}
}
}

SQL-92

CAUSE:

Java syntax errors in the bold statements above: (a) a colon is used instead of a semicolon, (b) a double quote is missing and (c) an extra closing paranthesis is used.

FIX:

Correct the code Java syntax:
import java.io.*;
import java.sql.*;
import java.util.*;

public class JDBCtestFixed {
public static void main(String[] args){
String url = null;
String userid = null;
String passwd = null;
String query = null;

url="jdbc:jdbcprogress:T:localhost:2500:libt";
userid = "sysadmin";
passwd = "system";

try{
Class.forName("com.progress.sql.jdbc.JdbcProgressDriver");
PrintStream pStream = new PrintStream(System.out,true);
Connection con = DriverManager.getConnection(url,userid,passwd);
}

catch(Exception e){
System.out.println(e.toString());
}
}
}