Bug report #12590

Oracle connection fails for OGR import into PostGIS

Added by Paolo Cavallini almost 5 years ago. Updated almost 5 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Processing/OGR
Affected QGIS version:2.8.1 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:20714

Description

The alg is blindly passing the data source uri of a oracle layer to ogr2ogr although the OCI driver has a completely different datasource syntax, resulting in an error:

GDAL execution console output
FAILURE:
Unable to open datasource `dbname='***' host=***
port=1523 user='***' password='***' estimatedmetadata=true
srid=8307 type=POINT table="***"."***" (GEOMETRY_WGS84) sql='
with the following drivers.
  -> OCI
  -> SOSI

NB: a Processing/OGR category is missing from the tracker

Associated revisions

Revision f0daab9c
Added by Jürgen Fischer almost 5 years ago

processing: fix interpretation of oracle layers (fixes #12590)

Funded by norbit.de

Revision ff1b1838
Added by Jürgen Fischer almost 5 years ago

processing: fix interpretation of oracle layers (fixes #12590)

Funded by norbit.de

(cherry picked from commit f0daab9c7c188bd0361d7d11652830558231e1b6)

History

#1 Updated by Jürgen Fischer almost 5 years ago

  • Assignee deleted (Victor Olaya)
  • Category changed from 94 to Processing/OGR

#2 Updated by Giovanni Manghi almost 5 years ago

  • Status changed from Open to Feedback

the question is:

does any (qgis/ogr/etc) processing tool work using a oracle layer as input?

#3 Updated by Jürgen Fischer almost 5 years ago

  • Status changed from Feedback to Closed

Also available in: Atom PDF