org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [WITH RECURSIVE virtual_category_with_children(parent_id, category_id, name, query, order_index) AS (SELECT parent_virtual_category_id, id, name, query, order_index FROM virtual_category WHERE type='tree' AND id = ? UNION ALL SELECT vc.parent_virtual_category_id, vc.id, vc.name, vc.query, vc.order_index FROM virtual_category_with_children t, virtual_category vc WHERE vc.parent_virtual_category_id=t.category_id) SELECT * FROM virtual_category_with_children]; General error; nested exception is java.sql.SQLException: General error

hsqldb | markus_heiden | 1 year ago
  1. 0

    General error since version 2.3.2

    hsqldb | 1 year ago | markus_heiden
    org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [WITH RECURSIVE virtual_category_with_children(parent_id, category_id, name, query, order_index) AS (SELECT parent_virtual_category_id, id, name, query, order_index FROM virtual_category WHERE type='tree' AND id = ? UNION ALL SELECT vc.parent_virtual_category_id, vc.id, vc.name, vc.query, vc.order_index FROM virtual_category_with_children t, virtual_category vc WHERE vc.parent_virtual_category_id=t.category_id) SELECT * FROM virtual_category_with_children]; General error; nested exception is java.sql.SQLException: General error
  2. 0

    Hibernate one-to-many mapping integrity constraint violation

    Stack Overflow | 2 years ago | maskapsiz
    org.hsqldb.HsqlException: integrity constraint violation: NOT NULL check constraint; SYS_CT_10115 table: ACCOMMODATION_CATEGORY column: ACC_ID
  3. 0

    Error while inserting/selecting in database , using hsqldb (hsqldb-20130206.203335-33) with hibernate3.1.3

    Stack Overflow | 3 years ago | Priyanka
    org.hsqldb.HsqlException: user lacks privilege or object not found: USERREGISTRATIONBEAN
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    DbUnit + HSQLDB + JPA Entity: integrity constraint violation: unique constraint or index violation; UK_25T4P9GXGVRCC8R3VL93JKAJE table: NEW_TAB

    Stack Overflow | 2 years ago | user613114
    org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; UK_25T4P9GXGVRCC8R3VL93JKAJE table: NEW_TAB
  6. 0

    "user lacks privilege or object not found" when executing sql script from spring

    Stack Overflow | 4 years ago | publ1c_stat1c
    org.hsqldb.HsqlException: user lacks privilege or object not found: XFC_ACTIONSTARTCONDITIONTYPE

  1. WoodenDoors 67 times, last 8 months ago
  2. kjhdofjosvs 1 times, last 1 week ago
  3. andyglick 2 times, last 4 weeks ago
  4. marcbouvierdav 1 times, last 2 months ago
87 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.hsqldb.HsqlException

    General error

    at org.hsqldb.error.Error.error()
  2. HyperSQL Database
    Error.error
    1. org.hsqldb.error.Error.error(Unknown Source)
    2. org.hsqldb.error.Error.error(Unknown Source)
    2 frames
  3. HSQLDB
    Session.execute
    1. org.hsqldb.QueryExpression.getResultRecursive(Unknown Source)
    2. org.hsqldb.QueryExpression.getResult(Unknown Source)
    3. org.hsqldb.TableDerived.materialise(Unknown Source)
    4. org.hsqldb.StatementDMQL.materializeSubQueries(Unknown Source)
    5. org.hsqldb.StatementDMQL.execute(Unknown Source)
    6. org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    7. org.hsqldb.Session.execute(Unknown Source)
    7 frames