File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes java persistence error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "java persistence error" Watch "java persistence error" New topic

java persistence error

Pedro Zuppelli

Joined: Mar 19, 2012
Posts: 1
Hi! I was trying to measure the impact for changing a fully jdbc application, to one that handles persistence and transaction with spring and hibernate. I've started with some minor impact tests but I'm having an error while running the following command, and I cannot see heads nor tails.
The exception thrown is the following
Caused by: java.sql.SQLException: Unexpected token: SELECT in statement [insert into UserTable (lastLogin, password, username) values (?, ?, ?) select scope_identity()]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)

An the following is the configuration.


servlet definition file

Tomcat's server.xml

do you have any ideas why is this failing?
Consider Paul's rocket mass heater.
subject: java persistence error
It's not a secret anymore!