彭老师:您好!关于JF中批量删除问题,麻烦您在百忙中指点迷津。多谢!

06-04-27 javatim

彭老师:

您好!

谢谢百忙中的解惑!

我在学习使用JF中(jboss)又遇到一个问题,就是关于JF中批量删除问题,特此再向您请教一下:

问题概述:

单个删除是没有任何问题的,log显示如下:

2006-04-26 11:16:14,124 DEBUG [com.jdon.aop.reflection.ProxyMethodInvocation] target:com.jdon.dataadmin.service.TestServicePOJOImp service's method:deleteOrder running..

2006-04-26 11:16:14,124 DEBUG [com.jdon.aop.reflection.ProxyMethodInvocation] it is pojo target service

2006-04-26 11:16:14,124 DEBUG [com.jdon.model.query.JdbcTemp] --> enter getSingleObject

2006-04-26 11:16:14,124 DEBUG [com.jdon.model.query.JdbcTemp] delete from order where id in (?)

2006-04-26 11:16:14,124 DEBUG [com.jdon.model.query.JdbcUtil] parameter 1 is 3

2006-04-26 11:16:14,124 DEBUG [com.jdon.controller.cache.CacheManager] <-cache->remove the object of PageIteratorPageIteratorSolverKEYSCOUNTselect count(1) from order from cache

2006-04-26 11:16:14,124 DEBUG [com.jdon.controller.cache.CacheManager] <-cache->remove the object of PageIteratorPageIteratorSolverKEYSselect id from order from cache

2006-04-26 11:16:14,124 DEBUG [com.jdon.dataadmin.service.TestServicePOJOImp] delete ok!

2006-04-26 11:16:14,124 DEBUG [com.jdon.aop.reflection.MethodInvokerUtil] method invoke successfully

2006-04-26 11:16:14,124 DEBUG [com.jdon.aop.interceptor.PoolInterceptor] realease a object:com.jdon.dataadmin.service.TestServicePOJOImp to pool

2006-04-26 11:16:14,140 DEBUG [com.jdon.model.handler.HandlerObjectFactory] --> return Modelhandler instance successfullycom.jdon.model.handler.XmlModelHandler10

2006-04-26 11:16:14,140 DEBUG [com.jdon.strutsutil.ModelSaveAction] save successfully ...

批量(如一个以上)删除功能显示成功,但是数据库中,并没有真正删除,查询log显示如下(也和单个删除日志一样正常,把日志中的sql语句单独在数据库工具中执行也是正常能成功删除其数据的):

2006-04-26 11:12:36,312 DEBUG [com.jdon.aop.reflection.ProxyMethodInvocation] target:com.jdon.dataadmin.service.TestServicePOJOImp service's method:deleteOrder running..

2006-04-26 11:12:36,312 DEBUG [com.jdon.aop.reflection.ProxyMethodInvocation] it is pojo target service

2006-04-26 11:12:36,312 DEBUG [com.jdon.model.query.JdbcTemp] --> enter getSingleObject

2006-04-26 11:12:36,312 DEBUG [com.jdon.model.query.JdbcTemp] delete from order where id in (?)

2006-04-26 11:12:36,312 DEBUG [com.jdon.model.query.JdbcUtil] parameter 1 is 3,2

2006-04-26 11:12:36,312 DEBUG [com.jdon.controller.cache.CacheManager] <-cache->remove the object of PageIteratorPageIteratorSolverKEYSCOUNTselect count(1) from order from cache

2006-04-26 11:12:36,328 DEBUG [com.jdon.controller.cache.CacheManager] <-cache->remove the object of PageIteratorPageIteratorSolverKEYSselect id from order from cache

2006-04-26 11:12:36,328 DEBUG [com.jdon.dataadmin.service.TestServicePOJOImp] delete ok!

2006-04-26 11:12:36,328 DEBUG [com.jdon.aop.reflection.MethodInvokerUtil] method invoke successfully

2006-04-26 11:12:36,328 DEBUG [com.jdon.aop.interceptor.PoolInterceptor] realease a object:com.jdon.dataadmin.service.TestServicePOJOImp to pool

2006-04-26 11:12:36,328 DEBUG [com.jdon.model.handler.HandlerObjectFactory] --> return Modelhandler instance successfullycom.jdon.model.handler.XmlModelHandler10

2006-04-26 11:12:36,328 DEBUG [com.jdon.strutsutil.ModelSaveAction] save successfully ...

麻烦彭老师百忙中多多指教!

多谢!

banq
2006-04-27 17:41
>批量(如一个以上)删除功能显示成功,但是数据库中,并没有真正删除

这个问题我碰到过,主要是你数据类型不匹配导致:输入JdbcTemp的问号中的数据类型和你数据表这个字段的类型不一致,如输入是字符串,字段类型其实整数型。

猜你喜欢