hibernate 生成的sql不能执行

[hxpjava1]

Hibernate: delete from t_album cross join t_albumCategory albumcateg1_ where ac_name=?
org.hibernate.exception.SQLGrammarException: could not execute update query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:110)
at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:421)
at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:283)
at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1288)
at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:117)
at cn.mykoo.album.AlbumCategoryDao.deletePhotosByAlubmName(AlbumCategoryDao.java:35)
at cn.mykoo.album.AlbumCategoryService.deleteAlbumCategoryAndPhotos(AlbumCategoryService.java:92)
at cn.mykoo.album.AlbumCategoryService$$FastClassByCGLIB$$90f4e5b9.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
at cn.mykoo.album.AlbumCategoryService$$EnhancerByCGLIB$$bc35dfb1.deleteAlbumCategoryAndPhotos(<generated>)
at cn.mykoo.album.AlbumCategoryAction.deleteAlbumCategoryAndPhotos(AlbumCategoryAction.java:154)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:452)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:254)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:263)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:133)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)

。。。。。。。
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'cross join t_albumCategory albumcateg1_ where ac_name='?–?è’?è???–??¤??¤?'' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)

[hxpjava1]

select *from t_album cross join t_albumCategory albumcateg1_ where ac_name=?

不会出错，为什么delete就会出错
delete from t_album cross join t_albumCategory albumcateg1_ where ac_name=?

[职业宅男]

CROSS JOIN 还可以在delete语句中使用吗？我还真没用过！高手。

[guaziaim9x]

这个，对多个表delete也不带这样的啊，宁可外连接查询一下，再弄个循环，一项一项的删

[wnf2009]

delete不带这样的 如果要级联删除 设置cascade="delete"

[hepeng_8]

这个，对多个表delete也不带这样的啊，宁可外连接查询一下，再弄个循环，一项一项的删
hibernate 必须知道主键 的

[fafi09]

可能需要做级联删除

[hxpjava1]

我的是单项多对一关系，不能做级联啊

[hxpjava1]

hql 这样写有错么？
this.getSession().createQuery("delete from Album a where a.albumCategory.name=?").setString(0,name).executeUpdate();

[sbaiitx]

hibernate 做删除需要ID的,如果不用id的话，就得用jdbc了

[黄小楼]

看了楼上几位的回答，，真的是，，要是你们都工作了的话，赶紧加强一下hibernate，
按照11楼的兄弟来说吧。

[hxpjava1]

我是这样解决的，先用一个hql查询出主键，再用一个sql删除

[javalhf]

看看是不是乱码引起的

[剑神一笑]

[Quote=引用 8 楼 hxpjava1 的回复:]
hql 这样写有错么？
this.getSession().createQuery("delete from Album a where a.albumCategory.name=?").setString(0,name).executeUpdate();
[/Quote]
谁说hibernate一定要ID删除的
删除不是这样写的,试试下面的

this.getSession().createQuery("delete from Album a where a.albumCategory.name=:name").setString("name",name).executeUpdate();

[职业宅男]

8楼和11楼的有区别吗？