Register / Login
this forum made possible by our volunteer staff, including ...
Roel De Nijs
Stephan van Hulst
Object Relational Mapping
Can i delete an object based on his reference
posted 9 years ago
I am working with
4.2 (JPA ).
when i try to execute the following query:
delete from DeviceConfigurationElements a where a.deviceDescriptor.macAddress = '02-00-4C-4F-4F-50'
I get an exception of sql syntax error , because it generate the following query:
20:52:23,804 INFO [STDOUT] Hibernate: delete from DeviceConfigurationElements, DeviceDescriptor devicedesc1_ where macaddress='02-00-4C-4F-4F-50'
20:52:23,819 WARN [JDBCExceptionReporter] SQL Error: 1064, SQLState: 42000
20:52:23,819 ERROR [JDBCExceptionReporter] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right sy
ntax to use near 'where macaddress='02-00-4C-4F-4F-50'' at line 1
It is sorta covered in the
JavaRanch Style Guide
Boost this thread!
About LDAP and JNDI
The server sent HTTP status code -1
in JVM what is the need of Just in time compiler and Java Interpreter?
mod_jk error with POST request
hql with select , where