Opened 18 years ago

Closed 18 years ago

#24 closed enhancement (fixed)

ODBC: Support base table fetching of Views for Oracle

Reported by: gavincramer Owned by: gavincramer
Priority: major Milestone: 3.2.2
Component: ODBC Provider Version: 3.2.2
Severity: 2 Keywords: views DescribeSchema ODBC
Cc: External ID:

Description

Oracle's ODBC driver does not support the fetching of primary keys for Views. However, its metadata (which are coincidentally views) can be used to find the base table of a view. The Schema Manager already knows how to use base table reading as a fall-back for primary key determination. All that is required is to fill in the ODBC-specific override for base table reading.

Change History (2)

comment:1 by gavincramer, 18 years ago

Milestone: 3.3.0 → 3.2.2
Status: new → assigned
Version: 3.2.0 → 3.2.2

comment:2 by gavincramer, 18 years ago

Resolution: → fixed
Status: assigned → closed

Reviewed by: Brent Robinson

Log:

Revision: 2623 Author: gavincramer Date: 5:35:23 PM, Friday, March 02, 2007 Message: Ticket #24: ODBC: Support base table fetching of Views for Oracle

Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/OdbcSchemaMgr.vcproj Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/DbObject.cpp Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/DbObject.h Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Owner.cpp Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Owner.h Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Rd/Makefile.am Added : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Rd/OraBaseObjectReader.cpp Added : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Rd/OraBaseObjectReader.h Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcBaseSetup.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoSelectTest.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoSelectTest.h

Note: See TracTickets for help on using tickets.