gephi-toolkit icon indicating copy to clipboard operation
gephi-toolkit copied to clipboard

Oracle Driver plugin: import with SID

Open OlexaRiznyk opened this issue 6 years ago • 1 comments

I'm trying to use Oracle Driver plugin on Windows x64. To connect to my DB, I need to specify Hostname, Port and SID (as I do in Oracle SQL Developer), but Gephi's Database settings window allows to enter Host, Port and Database. If I try to enter my SID into Database field, and press Test Connection, nothing happens. (I have downloaded Instant Client, unzipped it, set $JDBC_PATH and $ORACLE_HOME to its folder, and restarted Gephi).

How to import from Oracle database using SID?

OlexaRiznyk avatar Jul 11 '18 08:07 OlexaRiznyk

I am using Oracle DB 19c version 19.9 and Gephi 0.9.2, running on Windows 10. JDBC_PATH doesn't work for me, I removed it. I set ORACLE_HOME to Oracle Instant Client (version 19.9) directory... and it works! (https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html)

Please see "message.log" file in C:\Users(OS-user)\AppData\Roaming.gephi\0.9.2\dev\var\log directory.

HRTanjuang avatar Mar 02 '21 10:03 HRTanjuang

Closing old issues. Apologies for the lack of reply. In general, we're not able to offer support on the Oracle JDBC connection.

mbastian avatar Mar 17 '23 19:03 mbastian