SQLGrammarException using Hibernate + Embedded Derby

I have a Spring application which uses an embedded Derby database for unit testing.

Below is my DataSource configuration and Hibernate properties:



I get the following error when I start a DAO test:



Can anyone suggest what might be causing the above? Thanks in advance for any suggestions.

--James

I ended up getting around this error by putting the following into my Hibernate properties:

<prop key="hibernate.use_sql_comments">false</prop>

It seems that the Derby Hibernate dialect can't handle comments in the SQL.

--James