Hi,

I try to simply insert a record with HSQL

INSERT INTO FieldLog (className, objectId, previousState, currentState, cuser) VALUES ('zz',5,'a','b','P')

I get an error like:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: VALUES near line 1

Thanks in advance,
Pieter

First, you try to speak about HQL, not HSQL?, didn't you?

Second: your statement

is NOT HQL, but SQL.

Third: I never did nor heard about inserting with the usage of HQL!

Advice: Read the docs (before trying some code)!

Here's a little tutorial to help you out with Hibernate and HQL queries:


Understanding Hibernate Query Language HQL: A Simple and Easy Tutorial

Good luck!

OR session.createSQLQuery("insert into table () values ()")