aspose file tools*
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
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "java persistence error" Watch "java persistence error" New topic
Author

java persistence error

Pedro Zuppelli
Greenhorn

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.

persistence.xml


servlet definition file


Tomcat's server.xml


do you have any ideas why is this failing?
 
Don't get me started about those stupid light bulbs.
 
subject: java persistence error