Tag: openjpa

Wrong SQL update query generated on merge

When using EntityManager’s merge method on WebSphere Application Server 7 with MS SQL Server 2008 to update entity in database, wrong SQL query being generated (no update parameters after SET keyword (see stacktrace below)). Most likely this issue occurs when I’m trying to merge entity with no changes regarding DB, but this aint gettin me […]

OpenJPA 1 – sequence table not being created

I have an entity class with the following annotation on its primary key: @GeneratedValue(strategy = GenerationType.AUTO). However, when I try to persist an instance of this class, I get com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name ‘OPENJPA_SEQUENCE_TABLE’. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) The table it’s looking for definitely does not exist in the database. The user it’s connecting to the database […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.