Skip to Content
0
Former Member
May 14, 2008 at 07:44 AM

JPA: EntityManager#remove: OpenSQL statement contains syntax error

110 Views

Hi,

trying to remove an entity as follows:

        Query geMyEntity = entityManager.createNamedQuery("getMyEntityByReference");
        getMyEntity.setParameter("reference", "...");

        MyEntity me = (MyEntity) getMyEntity.getSingleResult();
        entityManager.remove(me);

yields the following error:

Caused by: com.sap.sql.log.OpenSQLException: The SQL statement "DELETE FROM "SAPSP5DB"."MY_TABLE" WHERE "SAPSP5DB"."MY_TABLE"."ID" = ?" contains the syntax error[s]: - Open SQL syntax error: column names must not specify a schema name (delete "SAPSP5DB". before "MY_TABLE"."ID").

What am I missing? Thank you for your help in advance.

Cheers,

Felix

Edited by: Felix Geller on May 14, 2008 9:44 AM

Edited by: Felix Geller on May 14, 2008 10:31 AM