Hi -- Migrating from v10 to v11 on linux rhel 7. In testing sqlexp, I appear to get a connection, but I never get the "SQLExplorer>" prompt, so something must be getting hung. The last line in the .log file is something about "Loading jdbc..." which is always the last line on the successful v10 attempts.
Any advice would be appreciated. Thx in advance -- Jim
Wrong IP address in /etc/hosts file !
I discovered that the sqlexp command worked when I replaced the normal -H parameter with "localhost". This led me to realizie that the IP in /etc/hosts for the machine was bogus.
More info:
This is sqlexp.log:
[2018/03/15@13:50:40.355-0400]=== Start logging. Local time: 2018/03/15@13:50:40
.352-0400. ===
[2018/03/15@13:50:40.358-0400]=== Progress Version 11.7.01.000 1429 ===
[2018/03/15@13:50:40.358-0400]
[2018/03/15@13:50:40.358-0400] [3] [SQLExplorer] Local /u2/appl/testeb
s/pgms/SQLExplorer.properties file will be used. (SQLMsg036)
[2018/03/15@13:50:40.360-0400] [3] [SQLExplorer] Setting Connect to jd
bc:datadirect:openedge://HCTPCS-RFMS02:5006;databaseName=ebsifc
[2018/03/15@13:50:40.360-0400] [3] [SQLExplorer] Setting SqlVerbose to
true
[2018/03/15@13:50:40.361-0400] [3] [SQLExplorer] Setting SqlVerbose to
true
[2018/03/15@13:50:40.361-0400] [3] [SQLExplorer] === SQLExplorer start
ing. ===
[2018/03/15@13:50:40.361-0400] [3] [SQLExplorer] ### ARGS: ebsifc -
H HCTPCS-RFMS02 -S 5006 -user root -password xxx -sqlverbose
[2018/03/15@13:50:40.366-0400] [3] [SQLExplorer] Connecting user "root
" to URL "jdbc:datadirect:openedge://HCTPCS-RFMS02:5006;databaseName=ebsifc"...
(8920)
[2018/03/15@13:50:40.366-0400] [3] [SQLExplorer] Loading JDBC driver com.ddtek.jdbc.openedge.OpenEdgeDriver.
And this is SQLExploere.properties:
#/u2/appl/testebs/pgms/SQLExplorer.properties
#Mar 14, 2018 6:10:23 PM
EchoSql=false
Connect=jdbc:datadirect:openedge://HCTPCS-RFMS02:5006;databaseName=ebsifc
AutoCommit=false
HasFetchLimit=true
ColumnWidthLimit=25
ColumnWidthMinimum=1
HasColumnLimit=false
Logging=false
EchoAll=false
SqlVerbose=false
FetchLimit=101
ReportFormat=Standard
DisableWarnings=true
Pager=false
Run=
Logfile=/u2/appl/testebs/pgms/SQLExplorerSession.log
ConnectTimeout=180
EchoComments=false
ResultSetLimit=24
TableFormat=true
Help=
TransactionIsolation=Read Committed
PageLimit=22
Echo=true
Show=
Reset=
Disconnect=true
UseUrlFormat=false
EchoCmd=false
Wrong IP address in /etc/hosts file !
I discovered that the sqlexp command worked when I replaced the normal -H parameter with "localhost". This led me to realizie that the IP in /etc/hosts for the machine was bogus.