Read database
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:
<宏/ >
<枚举关键= " parameters"/>
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:
<宏/ >
<枚举关键= " parameters"/>
Tagged:
0
Best Answer
-
Whit1323
MemberPosts:4
Contributor I
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