HSQLDB Insert statement error through TIBCO BW

ElenakretovaElenakretova Posts: 1
edited October 2017 in Jtest

I am trying to execute a tibco bw process activity which inserts record into hsqldb table. while inserting tibco bw record it is throwing an error; here I am attaching the snapshot of error. Any clue? Error says -

BW-JDBC-100014 Job-58000 Error in [Process/Receive Message.process/JDBC Update]
"JDBC error reported: (SQLState = 42501) - java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: HAWKEVENTS"
caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: HAWKEVENTS
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: HAWKEVENTS

Tagged:

Comments

  • jakubiakjakubiak Posts: 314 ✭✭✭

    Unfortunately there is not enough info to know exactly. Based on the error messages, it looks like you have something in your SQL query called "HAWKEVENTS", which is either an invalid name, or the user credentials you are using don't have access rights to access that item in the database.

Sign In or Register to comment.