Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 170054

Summary:	SQL Tooling not working with Oracle 10
Product:	[Tools] Data Tools	Reporter:	Stefan Holzknecht <s.holzknecht>
Component:	Enablement	Assignee:	Project Inbox <dtp.enablement-inbox>
Status:	RESOLVED WONTFIX	QA Contact:
Severity:	normal
Priority:	P3	CC:	bpayton, hui.cao, jfrantzius
Version:	1.0	Keywords:	helpwanted
Target Milestone:	future
Hardware:	PC
OS:	Windows XP
Whiteboard:

Description Stefan Holzknecht

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

2007-01-31 15:11:25 EST

For consideration in Enablement

Comment 2 Jörg von Frantzius

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

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

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.