Kbase P14887: Does sqlexp work with 9.1C patch 12 on Linux Red Head 7.2?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/2/2002 |
|
Status: Unverified
GOAL:
Does sqlexp work with 9.1C patch 12?
FACT(s) (Environment):
Progress 9.1C
FACT(s) (Environment):
RedHat Linux 7.2
FIX:
Yes.
Testinfo:
the database test is a copy of the sports database started with -S 7777
in.sql:
select name from customer
sqlexp -db test -S 7777 -H localhost -infile in.sql -user pub -password pub
PROGRESS PATCH Version 9.1C12 as of July 29, 2002
Connecting user "pub" to URL "jdbc:jdbcprogress:T:localhost:7777:test"... (8920)
Name
----------------------------------------
Lift Line Skiing
Urpon Frisbee
Hoops Croquet Co.
Go Fishing Ltd
Match Point Tennis
...
Envrinonment settings:
"Linux")
THREADS_FLAG=native
JIT=""
JVMARGS="-ms8m"
JDKHOME=/usr1/java/sun/jdk1.3.1_01
JREHOME=$JDKHOME
JAVAHOME=$JREHOME
export JAVAHOME
JDKCP=$JDKHOME/lib/classes.zip
JRECP=$JDKCP
VMTYPE=classic
ARCH=i386
LD_LIBRARY_PATH=$JREHOME/lib/$ARCH:$JREHOME/jre/lib/$ARCH:$JREHOME/jre/lib/$ARCH/${THREADS_FLAG}_threads:$JREHOME/jre/bin:$JREHOME/jre/lib/$ARCH/$VMTYPE:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
PROLIBPATH=$LD_LIBRARY_PATH; export PROLIBPATH
snip from the database log file:
12:34:08 BROKER 0: Shared Library Path set to LD_LIBRARY_PATH=/usr1/java/sun/jdk1.3.1_01/lib/i386:/usr1/java/sun/jdk1.3.1_01/jre/lib/i386:/usr1/java/sun/jdk1.3.1_01/jre/lib/i386
ative_threads:/usr1/java/sun/jdk1.3.1_01/jre/bin:/usr1/java/sun/jdk1.3.1_01/jre/lib/i386/classic:/usr/Motif1.2.2-R5/lib:/usr/X11R5/lib:/usr/lib:/usr1/v91Cp/dlc/lib:/usr1/v91Cp/dlc/lib
12:34:08 SQLSRV2 1: SQL Server 9.1C.04 started, configuration: "test.virtualconfig"
12:34:09 SQLSRV2 1: "test" started on port 1027, pid 14629 (0x00003925).
12:34:09 SQLSRV2 1: DLC from ENVIRONMENT VARIABLE is: /usr1/v91Cp/dlc
12:34:09 SQLSRV2 1: WRKDIR from ENVIRONMENT VARIABLE is: /usr1/progwrk/v91Cp/
12:34:09 SQLSRV2 1: JDKHOME from ENVIRONMENT VARIABLE is: /usr1/java/sun/jdk1.3.1_01
12:34:09 SQLSRV2 1: JREHOME from ENVIRONMENT VARIABLE is: /usr1/java/sun/jdk1.3.1_01
12:34:09 SQLSRV2 1: CLASSPATH from ENVIRONMENT VARIABLE is: /usr1/java/sun/jdk1.3.1_01/lib/classes.zip:/usr1/v91Cp/dlc/java/progress.zip:/usr1/v91Cp/dlc/java/sonicMQ/lib/client.jar:/usr1/v91Cp/dlc/java/sonicMQ/lib/jndi.jar:
12:34:10 SRV 1: Login usernum 24, remote SQL client. (8873)
12:34:10 SRV 1: Usr 24 set name to pub. (7129)
12:34:11 SRV 1: Logout by pub on . (453)