Read database
Whit1323
New Altair Community Member
I am trying to read in an Oracle DB table, and getting the error below. It is the only operator being used in the process.
Error Message: "Database error occurred: ORA-00942: table or view does not exist. The JDBC driver has thrown an SQLException. This may because of a lack of privileges, wrong table name or url and similar problems. Please note that some databases are case sensitive. Details are given in the message..... Offending operator: Read Database".
What is the most perplexing is that if you change "define query" from "table name" to "sql query", and I type in select * from database.table, it does work. So clearly the database connection is set up correctly. And under Manage Database Connections, it does work in testing. And the Oracle jdbc is check with a green check mark. Thanks for your help!
I typed "x's" over the table names in the xml below.
XML code:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.2.003">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="5.2.003" expanded="true" name="Process">
<process expanded="true" height="280" width="279">
<operator activated="true" class="read_database" compatibility="5.2.003" expanded="true" height="60" name="Read Database" width="90" x="112" y="120">
<parameter key="connection" value="xxxxxx"/>
<parameter key="define_query" value="table name"/>
<parameter key="table_name" value="xxxxxx"/>
<enumeration key="parameters"/>
</operator>
<connect from_op="Read Database" from_port="output" to_port="result 1"/>
<portSpacing port="source_input 1" spacing="0"/>
<portSpacing port="sink_result 1" spacing="0"/>
<portSpacing port="sink_result 2" spacing="0"/>
</process>
</operator>
</process>
Error Message: "Database error occurred: ORA-00942: table or view does not exist. The JDBC driver has thrown an SQLException. This may because of a lack of privileges, wrong table name or url and similar problems. Please note that some databases are case sensitive. Details are given in the message..... Offending operator: Read Database".
What is the most perplexing is that if you change "define query" from "table name" to "sql query", and I type in select * from database.table, it does work. So clearly the database connection is set up correctly. And under Manage Database Connections, it does work in testing. And the Oracle jdbc is check with a green check mark. Thanks for your help!
I typed "x's" over the table names in the xml below.
XML code:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.2.003">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="5.2.003" expanded="true" name="Process">
<process expanded="true" height="280" width="279">
<operator activated="true" class="read_database" compatibility="5.2.003" expanded="true" height="60" name="Read Database" width="90" x="112" y="120">
<parameter key="connection" value="xxxxxx"/>
<parameter key="define_query" value="table name"/>
<parameter key="table_name" value="xxxxxx"/>
<enumeration key="parameters"/>
</operator>
<connect from_op="Read Database" from_port="output" to_port="result 1"/>
<portSpacing port="source_input 1" spacing="0"/>
<portSpacing port="sink_result 1" spacing="0"/>
<portSpacing port="sink_result 2" spacing="0"/>
</process>
</operator>
</process>
0
Best Answer
-
Just to add on to this: with something so simple, I would hope it's not a problem with RapidMiner. So does anybody know exactly what DB privileges are needed to just read in an Oracle table. It seems like it's more than just "read". I have the same problems with "Stream database", and I believe that one requires more privileges ("alter", but perhaps more)0
Answers
-
Just to add on to this: with something so simple, I would hope it's not a problem with RapidMiner. So does anybody know exactly what DB privileges are needed to just read in an Oracle table. It seems like it's more than just "read". I have the same problems with "Stream database", and I believe that one requires more privileges ("alter", but perhaps more)0
-
I love this code and really appreciated your answer.2