Oracle JDBC-Connectionstring with Proxy

KNIME Analytics Platform
1

Hi @all,

I have to use a Oracle Proxy to get access to a new Database.

For all the other databases I'm using "jdbc:oracle:thin:@//host:port/servicename" for access.

Which is the correct connectionstring for using oracle with proxy?

I can't find any appropriate answer with google...

thx

Michael.

2

Hello Michael,

are you referring to proxy authentication (https://docs.oracle.com/cd/B28359_01/java.111/b31224/proxya.htm)? If this is the case this is not supported in KNIME but would need to be implemented since it uses a special method to create a db session.

Bye

Tobias

3

Hello Tobias,

yes, I think this ist the case we have. But we've got a solution: Normally, we would use the same User-Identification for all Databases. This doesn't work.

Now, we're using different User-Accounts - and it works.

Thanks,

Michael.