Kbase P114954: Wrong error message returned by sqlexp when database URL is incorrect
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/10/2009 |
|
Status: Verified
SYMPTOM(s):
Wrong error message returned by sqlexp
Wrong message: Invalid URL specified: Database name not specified. (8993)
Wrong message: Format is jdbc:jdbcprogress:T:(hostname):(service|port):(databasename) (8983)
Wrong message: Error: No suitable driver. (8933)
Using the new type 4 JDBC driver
sqlexp does not start
FACT(s) (Environment):
OpenEdge 10.1A
IBM AIX
Linux Intel
CAUSE:
Bug# 20060407-010
CAUSE:
Bug# OE00127979
FIX:
Correct syntax for using the database URL with the character SQL Explorer sqlexp :
sqlexp -url 'jdbc:datadirect:openedge://<host name>:<port number>;databaseName=<database name>' -infile in.sql -user <user name> -password <password>
Example using sqlexp to get info from the sports database with single quotes around connection string:
sqlexp -url 'jdbc:datadirect:openedge://localhost:4567;databaseName=sports' -infile in.sql -user pub -password pub
Example using sqlexp to get info from the sports database with double quotes around connection string:
sqlexp -url "jdbc:datadirect:openedge://localhost:4567;databaseName=sports" -infile in.sql -user pub -password pub