🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

Issue connecting to Oracle database

tmyers

Hello everyone. I'm having a problem connecting to an Oracle database. I am using RapidMiner 5.3 which allows for Oracle connections. I have added the jdbc_properties.xml file to the user/.RapidMiner5 folder. This jdbc_properties.xml contains the following:

<?xml version="1.0" encoding="UTF-8"?>
<drivers>
<driver urlprefix="jdbc:mysql://" name="MySQL" drivers="com.mysql.jdbc.Driver" driver_jar="" defaultport="3306" dbnameseparator="/"/>
<driver urlprefix="jdbc:postgresql://" name="PostgreSQL" drivers="org.postgresql.Driver" driver_jar="" defaultport="5432" dbnameseparator="/"/>
<driver urlprefix="jdbc:jtds:sybase://" name="Sybase" drivers="net.sourceforge.jtds.jdbc.Driver" driver_jar="" defaultport="7100" dbnameseparator="/"/>
<driver urlprefix="jdbc:hsqldb://" name="HSQLDB" drivers="org.hsqldb.jdbcDriver" driver_jar="" defaultport="9001" dbnameseparator="/"/>
<driver urlprefix="jdbc:odbc:" name="ODBC Bridge (e.g. Access)" drivers="" driver_jar="" defaultport="" dbnameseparator=""/>
<driver urlprefix="jdbc:jtds:sqlserver://" name="Microsoft SQL Server (JTDS)" drivers="net.sourceforge.jtds.jdbc.Driver" driver_jar="" defaultport="1433" dbnameseparator="/"/>
<driver urlprefix="jdbc:ingres://" name="Ingres" drivers="ca.ingres.jdbc.IngresDriver,com.ingres.jdbc.IngresDriver" driver_jar="" defaultport="II7" dbnameseparator="/"/>
<driver urlprefix="jdbc:oracle:thin:@ name=Oracle" drivers="oracle.jdbc.driver.OracleDriver" driver_jar="C:\Oracle\instantclient_12_2\ojdbc8.jar" defaultport="1521" dbnameseparator="/"/>
</drivers>

I have also tried the driver_jar link to C:\Program Files (x86)\Rapid-I\RapidMiner5\lib\jdbc\ojdbc8.jar where I have placed a 2nd copy of the file.

When I try to restart the software, the launch freezes when it gets to "Loading JDBC Drivers". I have to remove the .xml file to then get the program to start.

Does anyone have an idea on why this happens, or how I can revise the xml file to properly call the driver?

Thanks in advance for any guidance,

Tim

Find more posts tagged with

AI Studio

Databases

Oracle

Accepted answers

All comments

Thomas_Ott

Hi,

V5.3 is long time ago but I do seem to remember some sort of Oracle issue between v5.2 and v5.3. Have you tried using this on the current version 7.5? Does it work there?

tmyers

Hey Thomas. I am using community version 6.5 due to the record limitation in the newer versions. While this prevents me from using the built-in driver manager under Tools, I am able in 6.5 to load the jdbc_properties.xml to the user/.RapidMiner folder and successfully test the Oracle connection from the Read Database operator. (If I run the process, it then of course throws the error that Community version doesn't support Oracle).

Regards,

Tim

Thomas_Ott

Yeah 6.5 has the unlimited rows but crippled the commercial databases. Couldn't you use v7.5, make the connection to Oracle and just use 10,000 rows? I mean the other option is just buy a license of RapidMiner and help pay for my salary? :smileyhappy:

tmyers

Hey Tom, while I'm all for supporting RM staff's salaries :smileytongue:, the current price points of the paid versions are not feasible to our company at the moment. I would try the current free versions, but somtimes I deal with datasets with millions of rows, so the row limit prevents that option.

Do you recall what the differences were between 5.2 and 5.3 that caused the Oracle issue? Was there ever a fix? I've seen reference to an old Wiki for this version but the links are always bad.

Thanks,

Tim

Thomas_Ott

I'm not sure if there was a fix or not, have you checked out the original (Old) forum here: http://community.rapidminer.com/t5/Original-Rapid-I-Forum/bd-p/UCASE.

tmyers

Just looked, not much there when I search for Oracle. The one forum post I found that I tried following is here:

http://community.rapidminer.com/t5/RapidMiner-Studio-Forum/Oracle-JDBC/td-p/14871

tmyers

Also tried what was suggested in this post:

http://community.rapidminer.com/t5/RapidMiner-Studio-Forum/Database-Connection-In-RM-5-0-using-SQL/td-p/6746

It's as if simply by placing the xml file in the user/.RapidmIner5 folder it causes it to freeze up and not fully launch.

Edin_Klapic

Hi tmyers,

Perhaps the issue is related to the driver and/or the oracle version?

If I remember correctly I used ojdbc6 with oracle11.

Best,

Edin

tmyers

Thanks Edin. I'm using ojdbc8.jar to connect to Oracle 12.2. When I test the connection I get the following error:

Io exception: Invalid connection string format, a valid format is: "host:port:sid"

This is strange, beacuse I don't receive this error connecting with other software using the service_name rather than SID. The URL that normally works is this:

jdbc:oracle:thin:[host]:1521/[service_name]

Below are the driver details from the jdbc_properties.xml file in my user/.RapidMiner5 folder. Any other idea on what could be causing the error?

Thanks in advance for any suggestions/advice-

Tim