Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
"Read Database Oracle Issue"
Learner III
Hi All,
I am new to RapidMiner. I am trying to user the Read Database control with Oracle database. Since Oracle driver is not available in Rapid Miner 5.2.001. I downloaded the Oracle driver from the Oracle site and updated the C:\Program Files\Rapid-I\RapidMiner5\resources\com\rapidminer\resources\jdbc_properties.xml file as below.
If anyone have idea please help me to resolve this issue.
Thanks in advance.
I am new to RapidMiner. I am trying to user the Read Database control with Oracle database. Since Oracle driver is not available in Rapid Miner 5.2.001. I downloaded the Oracle driver from the Oracle site and updated the C:\Program Files\Rapid-I\RapidMiner5\resources\com\rapidminer\resources\jdbc_properties.xml file as below.
Then also I am facing the issue “No Suitable driver found for jdbc:oracle:thin:@host:port:DB”
<driver name="Oracle"
drivers="oracle.jdbc.driver.OracleDriver"
driver_jar="C:/Balaji/DownloadJarFiles/Oracle_Drivers/ojdbc5.jar,C:/Balaji/DownloadJarFiles/Oracle_Drivers/ojdbc5_g.jar,C:/Balaji/DownloadJarFiles/Oracle_Drivers/ojdbc5dms.jar,C:/Balaji/DownloadJarFiles/Oracle_Drivers/ojdbc5dms_g.jar,C:/Balaji/DownloadJarFiles/Oracle_Drivers/ojdbc6.jar,C:/Balaji/DownloadJarFiles/Oracle_Drivers/ojdbc6_g.jar,C:/Balaji/DownloadJarFiles/Oracle_Drivers/ojdbc6dms.jar,C:/Balaji/DownloadJarFiles/Oracle_Drivers/ojdbc6dms_g.jar,C:/Balaji/DownloadJarFiles/Oracle_Drivers/orai18n.jar,C:/Balaji/DownloadJarFiles/Oracle_Drivers/xdb6.jar"
defaultport="1521"
urlprefix="jdbc:oracle:thin:@"
dbnameseparator=":"
type_varchar="VARCHAR2"
type_text="BLOB"
type_integer="INTEGER"
type_real="REAL"
type_time="TIME"
type_date="DATE"
type_dateTime="TIMESTAMP"
identifier_quote_open="""
identifier_quote_close="""
value_quote_open="'"
value_quote_close="'"
/>
If anyone have idea please help me to resolve this issue.
Thanks in advance.
0
Answers
please use the "Manage Database Drivers" dialog under "Tools"->"Manage Database Drivers" which comes with RapidMiner instead of editing .xml files (and the wrong one at that).
Also RapidMiner 5.2.003 is the latest RapidMiner version, so I suggest you update RapidMiner while you are at it
Regards,
Marco