Hello Everybody, Has anybody encountered a problem where a datastore

Jin Pheh

Certified Associate Developer

over 10 years ago

Hello Everybody,

Has anybody encountered a problem where a datastore is valid yet you are unable to query an object from it? I am running into exactly this problem where both queryEntity expressions and query rules fail to read the object and throw the following error:
ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist
...

Discussion posts and replies are publicly visible

Parents

0 Mark Talbot
Appian Employee
over 10 years ago

Have you turned on logging to output your SQL statements?

Add the following to your appian_log4j.properties:
log4j.logger.org.hibernate.SQL=DEBUG

Once you turn on SQL trace statements, try to determine if the tables in the SQL statements exist in your database.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Mark Talbot
Appian Employee
over 10 years ago

Have you turned on logging to output your SQL statements?

Add the following to your appian_log4j.properties:
log4j.logger.org.hibernate.SQL=DEBUG

Once you turn on SQL trace statements, try to determine if the tables in the SQL statements exist in your database.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data