Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Oracle connector #15

Open
Philippe-M opened this Issue Mar 14, 2019 · 7 comments

Comments

Projects
None yet
3 participants
@Philippe-M
Copy link

Philippe-M commented Mar 14, 2019

when I select Oracle mode as the data source. I enter the information requested by the form and when I click on the connection test button I have the message :

Error executing test connection SQL : TypeError: "listener" argument must be a function

On the urungi server I installed node-oracle and installed the oracle basic client

@jajm

This comment has been minimized.

Copy link
Member

jajm commented Mar 15, 2019

Hi,

I do not have access to an Oracle database so I can't really test this, but I can reproduce the error message and tried to fix it in branch fix-oracle-connection.
Can you retry using this branch ?

@Philippe-M

This comment has been minimized.

Copy link
Author

Philippe-M commented Mar 15, 2019

I just did the test with the fix-oracle-connection branch and it's better but when I set the data source and test the connection I get the message:

Error executing test connection SQL : Error: select "owner", "table_name", "column_name", "data_type" from "user_tab_columns" - ORA-00942: table or view does not exist

I test from the urungi server to connect with sqlplus and everything is ok.

@Philippe-M

This comment has been minimized.

Copy link
Author

Philippe-M commented Mar 18, 2019

I think the problem is that my tables contain prefixes and are not supported in urungi

@jajm

This comment has been minimized.

Copy link
Member

jajm commented Mar 18, 2019

I'm not familiar with Oracle, but it looks like it's a permission problem.
user_tab_columns table should be there but maybe your user doesn't have access to it ?

@Philippe-M

This comment has been minimized.

Copy link
Author

Philippe-M commented Mar 18, 2019

If I reproduce the query with sqlplus I have

# sqlplus MYUSER/MYPWD
SQL> select table_name from sys.all_tables where owner = 'MYUSER';
no rows selected

But if I make the same query without specifying owner:

# sqlplus MYUSER/MYPWD
SQL> select table_name from sys.all_tables;

The list of tables to which this user has access appears.

I realized another connection test from Urungi with a user who is in SELECT_ANY_TABLE and I still have the same error. Same error with a user with all rights (system)

@PaulPoulain

This comment has been minimized.

Copy link
Member

PaulPoulain commented Mar 20, 2019

FYI : next week, 2 developers from AFI are coming to work with us on Urungi. Their goal is to use Urungi for 2 software that use Oracle as DB. So we will fix the problem, for sure !
@Philippe-M which Oracle version are you using ?

@Philippe-M

This comment has been minimized.

Copy link
Author

Philippe-M commented Mar 20, 2019

That's very good news.

@PaulPoulain I use Oracle 10

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.