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>
