Status: Unverified
GOAL:
Example for Setting Environment on AIX for Progress JDBC
FACT(s) (Environment):
IBM AIX 4.3
FACT(s) (Environment):
Progress 9.1A
SYMPTOM(s):
Java Version 1.1.8
Native JDBC driver com.progress.sql.jdbc.JdbcProgressDriver
FIX:
Example scripts:
1) Example script for setting the environment:
THREADS_FLAG=native ;export THREADS_FLAG
JVMARGS="-ms1m"; export JVMARGS
JREHOME=/usr1/v91A/dlc/jre ;export JREHOME
JDKHOME=/usr1/v91A/dlc/jre ;export JDKHOME
PROGRESSCP=/usr1/v91A/dlc/java/progress.zip ;export PROGRESSCP
JDKCP=/usr1/v91A/dlc/jre/lib/classes.zip ;export JDKCP
JRECP=/usr1/v91A/dlc/jre/lib/classes.zip ;export JRECP
LIBPATH=/usr1/v91A/dlc/jre/lib/aix
ative_threads ;export LIBPATH
LIBPATH=/usr1/v91A/dlc/lib:$LIBPATH ;export LIBPATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$LIBPATH ;export LD_LIBRARY_PATH
SQL_LIBPATH=$LIBPATH ;export SQL_LIBPATH
2) Example script for running a JDBC test class.
Database name is test as copy of the Sports database
user pub with password pub created through the Data
Administration tool and started with: ProServe test -S 3009:
CLASSPATH=/usr1/v91A/dlc/java/jdbc.zip ;export CLASSPATH
CLASSPATH=.:/users/rwe/sylvaner:$CLASSPATH ;export CLASSPATH
CLASSPATH=/usr1/v91A/dlc/java/progress.zip:$CLASSPATH ;export /
CLASSPATH
CLASSPATH=/usr1/v91A/dlc/java/progress2.zip:$CLASSPATH ;export /
CLASSPATH
CLASSPATH=/usr1/v91A/dlc/jre/classess.zip:$CLASSPATH ;export CLASSPATH
java JdbcTest com.progress.sql.jdbc.JdbcProgressDriver / jdbc:
jdbcprogress:T:sylvaner:3009:test /
pub pub select name from customer
3) Example Java code for connecting and getting results:
import java.sql.*;
public class JdbcTest
{
public static void main (String args [])
throws SQLException, ClassNotFoundException
{
if (args.length < 5) {
System.out.println("Usage: java JdbcTest <JDBCDriver> <URL>
<NAME> <PASSWORD> <SQL-Statement>");
System.exit(0); }
StringBuffer sb = new StringBuffer();
System.out.println("\nLoading class : " + args[0] + "\n");
Class.forName (args[0]);
System.out.println("URL used : " + args[1] + "\n");
Connection conn = DriverManager.getConnection(args[1],
args[2],args[3]);
Statement stmt = conn.createStatement();
for (int i = 4;i < args.length;i++) {
sb.append(args[i] + " ");
}
String sSTMT = new String(sb);
System.out.println("SQL-Statement : " + sSTMT + "\n");
ResultSet rset = stmt.executeQuery(sSTMT);
System.out.println("ResultSet : \n");
while (rset.next()){
System.out.println(rset.getString(1));
}
}
}