java.sql.SQLException: [JDBC OpenEdge Driver]: 251

[Alek]

Hello All,

I'm trying to connect to progress database (10.0B). The database is on a Linux box (RHE 4 AS), and the code I'm testing is on the same box.

Env. variables:
PATH="/usr/java/j2sdk1.4.1_03/bin";$PATH:$HOME/bin
export PATH

export JDKHOME="/usr/java/j2sdk1.4.1_03"

export JREHOME="/usr/java/j2re1.4.1_03"

export JAVAHOME="/usr/java/j2re1.4.1_03"

CLASSPATH="/usr/dlc/java/progress.jar:/usr/dlc/java/jdbc.jar":$CLASSPATH
export CLASSPATH

export LD_LIBRARY_PATH="usr/dlc/lib:/usr/java/j2re1.4.1_03/lib/i386/native_threads:/usr/java/j2re1.4.1_03/lib/i386/cient:/usr/java/j2re1.4.1_03/lib/i386/server"

export PROLIB_PATH="usr/dlc/lib:/usr/java/j2re1.4.1_03/lib/i386/native_threads:/usr/java/j2re1.4.1_03/lib/i386/cient:/usr/java/j2re1.4.1_03/lib/i386/server"



The test 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());
}
}
}

And here is the exception I get:

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]


I will greatly appreciate any help.
Thanks.
Alek