Bug 170054 - SQL Tooling not working with Oracle 10
Summary: SQL Tooling not working with Oracle 10
Status: RESOLVED WONTFIX
Alias: None
Product: Data Tools
Classification: Tools
Component: Enablement (show other bugs)
Version: 1.0   Edit
Hardware: PC Windows XP
: P3 normal with 2 votes (vote)
Target Milestone: future   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords: helpwanted
Depends on:
Blocks:
 
Reported: 2007-01-10 03:46 EST by Stefan Holzknecht CLA
Modified: 2013-08-08 14:44 EDT (History)
3 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Stefan Holzknecht CLA 2007-01-10 03:46:06 EST 
Build ID: I20061214-1445

Steps To Reproduce:
1. Create a connection profile to be used with Oracle 10
2. Connect to the database
3. Explore the database in the Datasource Explorer
- you see the dabase objects
- you cannot select a schema as filter in the properties of the database
- you cannot open a stored procedure: Failed to get source
4. Create or edit a SQL file
5. Use the connection profile created in 1. within the 'Set Connection Profile' dialog
6. The content assist does not offer any database related objects (tables, columns, other) at any place in the source
   



More information:
I debugged some of the code of the content assist and figured out that the wrong schema gets received.
SQLDBProposalsService.loadDBProposals() line 252:
getSchema(database, request.getDatabase(), request.getSchema()) there request.getDatabase() returns null.

This invokes ModelUtil.getSchemas(). Because the catalogName is null the catalog name is set to the database name.
I figure out that my Database object returns empty schemas with the database name as catalog name, nut the actual valid schema has '' as name.
I don't know either the name of the catalog in the database is wrong or if the chosen default should be the empty string.
Comment 1 John Graham CLA 2007-01-31 15:11:25 EST 
For consideration in Enablement
Comment 2 Jörg von Frantzius CLA 2008-09-23 11:33:51 EDT 
Content assist for table names works for me in the meantime. I've never seen a column name completion, though, but I don't know if DTP supports that at all...
Comment 3 Brian Fitzpatrick CLA 2008-09-23 16:15:03 EDT 
Have you tried the actual Oracle plug-ins from Oracle's site?

http://oss.oracle.com/dbplugin-eclipse-dtp.html

The Oracle implementation in Enablement is just a base implementation. I doubt it includes the content assist bits. We are working with the Oracle folks to try and get their full featured plug-ins into Enablement for Galileo, but we're still not sure that will happen.
Comment 4 Brian Payton CLA 2013-08-08 14:44:06 EDT 
The current DTP maintainers have no expertise in Oracle, and as is pointed out in one of the previous comments, the Oracle plugin in DTP is really just a stub.  Oracle has made a more full-featured DTP plugin available.