Hibernate Community • View topic - Can i delete an object based on his reference

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Can i delete an object based on his reference

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

avihaimar77

Post subject: Can i delete an object based on his reference

Posted: Tue Sep 11, 2007 1:53 pm

Regular

Joined: Wed May 02, 2007 2:42 pm
Posts: 101

Hey,

I am working with Jboss 4.2 (JPA ).

when i try to execute the following query:

Code:

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:

Code:

52:23,804 INFO  [STDOUT] Hibernate: delete from DeviceConfigurationElements, DeviceDescriptor devicedesc1_ where macaddress='02-00-4C-4F-4F-50'

52:23,819 WARN  [JDBCExceptionReporter] SQL Error: 1064, SQLState: 42000

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

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum