You can translate the question and the replies:

Error querying Oracle DB

I m trying to connect Oracle 11g local instance and running query on base view, however receiving below error while executing query. Trace doesn't give me clue where the error is: Error trace given below: QUERY: SELECT * FROM employees CONTEXT ('i18n'='us_pst', 'cache_wait_for_load'='true') TRACE EXECUTION PLAN ( name = Execution startTime = Thu Jul 7 12:18:22 038 IST 2016 endTime = Thu Jul 7 12:18:22 243 IST 2016 responseTime = - numRows = 0 state = ERROR completed = false waitingTime = 0 STATIC OPTIMIZATION ( staticOptimized = false staticOptimizationTime = 0 staticOptimizationStart = Thu Jul 7 12:18:22 038 IST 2016 staticOptimizationEnd = Thu Jul 7 12:18:22 038 IST 2016 ) BASE PLAN ( name = employees database = tutorial startTime = Thu Jul 7 12:18:22 038 IST 2016 endTime = Thu Jul 7 12:18:22 243 IST 2016 responseTime = - numRows = 0 state = ERROR completed = false fields = [employee_id, commission_pct, salary] search conditions = [] filter conditions = [] ordered = false numOfFilteredTuples = 0 numOfDuplicatedTuples = 0 numOfSwappedTuples = 0 swapping = false memoryLimitReached = false JDBC WRAPPER ( name = employees database = tutorial startTime = Thu Jul 7 12:18:22 038 IST 2016 endTime = Thu Jul 7 12:18:22 243 IST 2016 responseTime = - numRows = 0 state = ERROR completed = false searchConditions = [] orderByFields = [] projectedFields = [employee_id, commission_pct, salary] additionalSubPlans = 0 additionalErroneousSubPlans = 0 JDBC ROUTE ( name = employees#0 datasource = oracle_source datasource database = tutorial startTime = Thu Jul 7 12:18:22 038 IST 2016 endTime = Thu Jul 7 12:18:22 243 IST 2016 responseTime = - numRows = 0 state = CONNECTION_ERROR completed = false exception = Unexpected error creating a connection: Could not create a validated object, cause: ValidateObject failed SQLSentence = parameters = [] SQLSentence info = DBUri = jdbc:oracle:thin:@localhost:1521:ORCL userName = nbk8hkp connectionTime = 0 cachedConnection = false ) ) ) ) Please provide some pointers.
user
07-07-2016 03:05:33 -0400

2 Answers

Nevermind, able to fire query on base views. I changed connection pool query from SELECT COUNT(*) FROM SYS.DUAL to SELECT 1 FROM DUAL. because of this unable to query base views. Reverted back to default query and it worked.
user
07-07-2016 08:00:52 -0400
Hi, Glad to hear everything is working. The ping query is always executed to validate if a connection is valid, so you need to put a valid (and typically a fast) query. Hope this helps!
Denodo Team
07-07-2016 11:44:25 -0400
You must sign in to add an answer. If you do not have an account, you can register here