ORADEW Doesn't Import Anything about oradew-vscode HOT 8 CLOSED

It worked! Thanks for the quick attention to this issue!

from oradew-vscode.

Could it be that you connect with the "user" that is not the owner of the objects?

Oradew uses data from the following select to create file structure (not folders though):

with :objectType = 'TABLE' (for tables, etc.), :objectName = null and :owner = connection user defined in dbconfig.json.

Please try quering in your DB to see actual owner of your objects:

select  *     
from all_objects; 

Thanks for your feedback!

from oradew-vscode.

Thanks for the quick response.

If I run the following query:

select 
    owner, 
    object_id, 
    object_name, 
    object_type, 
    cast(last_ddl_time as timestamp) as last_ddl_time, 
    status 
from 
    all_objects 
where 
    upper(owner) = upper('**********')  -- ********** is replaced with the actual schema user name
and 
    upper(object_type) = upper(nvl(null, object_type)) 
and 
    upper(object_name) = upper(nvl(null, object_name)) 
and 
    object_name not like 'SYS_PLSQL%' 
order by 
    object_id

I get back 14 records. Here's a summary of some of that data:

Obviously I've changed the owner and object names to keep from publicizing them on the interwebs.

I think the ownership is set up correctly. The user I've hidden here is the same user as I have set up in the dbconfig.json, and the password I have set up in that file is the same one that I use to log into the development DB with.

Is there any sort of verbose/debugging mode that I can turn on?

from oradew-vscode.

There is a "oradew.chatty" config but unfortunatelly it won't help in this scenario I am afraid.

Tomorrow I can make a custom release with some debuging outputs to print the actual sql executed, maybe it would help...

You are not messing with "source.input" parameter in oradewrc.json, are you? that is the only thing It could prevent creating files from objects - by design at least 🤔

Thanks for your help.

from oradew-vscode.

No, I installed in and ran it. I don't remember messing with any part of the configuration, but I'll check just to be safe.

I used it once on a previous project and it worked like a champ. This time it just won't import the schema.

The schema user doesn't need to be granted any specific rights, does it?

from oradew-vscode.

No, not really. If a select from all_objects returns data, that should be it.

from oradew-vscode.

Actually it was a bug. 😞 I released a fix (0.3.8) version, please confirm it works for you. Thanks again for reporting.

from oradew-vscode.

I've been pulled away from this project for a couple of days and I'm just getting back on this now. I'm going to install this update now and let you know how it goes.

Thanks!

from oradew-vscode.