Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

HSQLDB Insert statement error through TIBCO BW

Elenakretova
Elenakretova 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

  • jakubiak
    jakubiak Posts: 813 admin

    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.

Categories

Tagged