Kbase P141781: Unable to stabilish a multi database connection from Sqlexplorer tool returns "null"
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/9/2011 |
|
Status: Unverified
SYMPTOM(s):
Unable to stabilish a multi database connection from Sqlexplorer tool returns "null"
SQLEXP fails to connect to multi database query
null
sqlexp -url "jdbc:datadirect:openedge://localhost:8787;databaseName=sp1[-mdbq:test1]" - returns null
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
OpenEdge 10.1C
OpenEdge 10.2A
CAUSE:
Bug# OE00181460
CAUSE:
The part in the square brackets "[-mdbq:test1]" was not being parsed correctly and causing the url to be ignored.
The issue was specific to sqlexplorer and limited to using the dynamic connection feature in an MDBQ (multi database query) environment which uses property files.
FIX:
Upgrade to OpenEdge 10.2B or later.
If upgrade is not viable, a possible workaround is to connect only the primary database at the command line and connect to additional databases from the SQL Explorer use the following command syntax:
connect '<path to database and database name here>' as catalog <catalog name here>;
i.e: If a second database were located in c:\temp\ and was named database2 and for the duration of the session the catalog designation of DB2 was to be used, the following example command would be given:
connect 'c:\temp\database2' as catalog DB2;
The following example command is based on the assumption that the database referenced in the command is a copy of the sports2000 database:
select name from DB2.PUB.customer;