有没有ibatis高手????连接oracle的问题!!!

Question

查看一下你的用户的权限吧！我怀疑你没有update权限。你可以用SQL语句手工运行看看。呵呵呵！
我一般用 TOAD

Answer 1

已经运行测试了，用户权限在PL/SQL操作是没问题的在ORACLE中查询当前用户：select * from session_privs 权限
显示有UPDATE ANY TABLE权限，无奈中........

Answer 2

把你要插入的avo的每个字段打印出来，组合成SQL
你拿到SQl里面执行看看吧！也许有的字段你数据库里长度太短了，或者精度不够呢！！！

Answer 3

感谢老紫竹这么热心12:14:51,384 ERROR [STDERR] com.ibatis.dao.client.DaoException: Failed to update - id [UP_FrontAfficheVO_Old] - parameterObject [com.granddragon.co.model.FrontAfficheVO@9a4ba3].  Cause: com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in sqlmap/sql/X_Affiche.xml.  
--- The error occurred while applying a parameter map.  
--- Check the UP_FrontAfficheVO_Old-InlineParameterMap.  
--- Check the statement (update failed).  
--- Cause: java.sql.SQLException: ORA-01031: insufficient privileges
12:14:51,384 ERROR [STDERR]  at com.ibatis.dao.client.template.SqlMapDaoTemplate.update(SqlMapDaoTemplate.java:147)
12:14:51,384 ERROR [STDERR]  at com.granddragon.co.dao.impl.CoFrontAfficheDaoImpl.upOneAffiche(CoFrontAfficheDaoImpl.java:123)
12:14:51,384 ERROR [STDERR]  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
12:14:51,384 ERROR [STDERR]  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
12:14:51,384 ERROR [STDERR]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
12:14:51,384 ERROR [STDERR]  at java.lang.reflect.Method.invoke(Method.java:585)
12:14:51,384 ERROR [STDERR]  at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
12:14:51,384 ERROR [STDERR]  at $Proxy55.upOneAffiche(Unknown Source)
12:14:51,384 ERROR [STDERR]  at com.granddragon.co.business.services.FrontAfficheAction.Up_FrontAffiche(FrontAfficheAction.java:81)
12:14:51,384 ERROR [STDERR]  at com.granddragon.co.managerbeans.struts.action.UpAfficheAction.execute(UpAfficheAction.java:114)
12:14:51,384 ERROR [STDERR]  at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
12:14:51,384 ERROR [STDERR]  at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
12:14:51,384 ERROR [STDERR]  at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
12:14:51,384 ERROR [STDERR]  at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
12:14:51,384 ERROR [STDERR]  at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
12:14:51,384 ERROR [STDERR]  at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
12:14:51,384 ERROR [STDERR]  at com.granddragon.co.filter.FilePageFilter.doFilter(FilePageFilter.java:53)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
12:14:51,384 ERROR [STDERR]  at com.granddragon.co.filter.ChinaFilter.doFilter(ChinaFilter.java:33)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
12:14:51,384 ERROR [STDERR]  at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
12:14:51,384 ERROR [STDERR]  at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
12:14:51,384 ERROR [STDERR]  at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
12:14:51,384 ERROR [STDERR]  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
12:14:51,384 ERROR [STDERR]  at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
12:14:51,384 ERROR [STDERR]  at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
12:14:51,384 ERROR [STDERR]  at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
12:14:51,384 ERROR [STDERR]  at java.lang.Thread.run(Thread.java:595)

Answer 4

感谢老紫竹这么热心12:14:51,384 ERROR [STDERR] com.ibatis.dao.client.DaoException: Failed to update - id [UP_FrontAfficheVO_Old] - parameterObject [com.granddragon.co.model.FrontAfficheVO@9a4ba3].  Cause: com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in sqlmap/sql/X_Affiche.xml.  
--- The error occurred while applying a parameter map.  
--- Check the UP_FrontAfficheVO_Old-InlineParameterMap.  
--- Check the statement (update failed).  
--- Cause: java.sql.SQLException: ORA-01031: insufficient privileges
12:14:51,384 ERROR [STDERR]  at com.ibatis.dao.client.template.SqlMapDaoTemplate.update(SqlMapDaoTemplate.java:147)
12:14:51,384 ERROR [STDERR]  at com.granddragon.co.dao.impl.CoFrontAfficheDaoImpl.upOneAffiche(CoFrontAfficheDaoImpl.java:123)
12:14:51,384 ERROR [STDERR]  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
12:14:51,384 ERROR [STDERR]  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
12:14:51,384 ERROR [STDERR]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
12:14:51,384 ERROR [STDERR]  at java.lang.reflect.Method.invoke(Method.java:585)
12:14:51,384 ERROR [STDERR]  at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
12:14:51,384 ERROR [STDERR]  at $Proxy55.upOneAffiche(Unknown Source)
12:14:51,384 ERROR [STDERR]  at com.granddragon.co.business.services.FrontAfficheAction.Up_FrontAffiche(FrontAfficheAction.java:81)
12:14:51,384 ERROR [STDERR]  at com.granddragon.co.managerbeans.struts.action.UpAfficheAction.execute(UpAfficheAction.java:114)
12:14:51,384 ERROR [STDERR]  at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
12:14:51,384 ERROR [STDERR]  at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
12:14:51,384 ERROR [STDERR]  at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
12:14:51,384 ERROR [STDERR]  at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
12:14:51,384 ERROR [STDERR]  at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
12:14:51,384 ERROR [STDERR]  at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
12:14:51,384 ERROR [STDERR]  at com.granddragon.co.filter.FilePageFilter.doFilter(FilePageFilter.java:53)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
12:14:51,384 ERROR [STDERR]  at com.granddragon.co.filter.ChinaFilter.doFilter(ChinaFilter.java:33)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
12:14:51,384 ERROR [STDERR]  at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
12:14:51,384 ERROR [STDERR]  at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
12:14:51,384 ERROR [STDERR]  at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
12:14:51,384 ERROR [STDERR]  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
12:14:51,384 ERROR [STDERR]  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
12:14:51,384 ERROR [STDERR]  at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
12:14:51,384 ERROR [STDERR]  at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
12:14:51,384 ERROR [STDERR]  at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
12:14:51,384 ERROR [STDERR]  at java.lang.Thread.run(Thread.java:595)麻烦大家一起来看看，对oracle和ibatis不是很了解，只能靠大家帮帮忙咧

Answer 5

12:14:51,384 ERROR [STDERR] Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in sqlmap/sql/X_Affiche.xml.  
--- The error occurred while applying a parameter map.  
--- Check the UP_FrontAfficheVO_Old-InlineParameterMap.  
--- Check the statement (update failed).  
--- Cause: java.sql.SQLException: ORA-01031: insufficient privileges
12:14:51,384 ERROR [STDERR]  at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
12:14:51,384 ERROR [STDERR]  at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:505)
12:14:51,384 ERROR [STDERR]  at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.update(SqlMapSessionImpl.java:90)
12:14:51,384 ERROR [STDERR]  at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.update(SqlMapClientImpl.java:67)
12:14:51,384 ERROR [STDERR]  at com.ibatis.dao.client.template.SqlMapDaoTemplate.update(SqlMapDaoTemplate.java:145)
12:14:51,384 ERROR [STDERR]  ... 39 more
12:14:51,384 ERROR [STDERR] Caused by: java.sql.SQLException: ORA-01031: insufficient privileges
12:14:51,384 ERROR [STDERR]  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
12:14:51,384 ERROR [STDERR]  at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
12:14:51,384 ERROR [STDERR]  at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
12:14:51,384 ERROR [STDERR]  at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
12:14:51,384 ERROR [STDERR]  at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1141)
12:14:51,384 ERROR [STDERR]  at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2149)
12:14:51,384 ERROR [STDERR]  at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2032)
12:14:51,384 ERROR [STDERR]  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2894)
12:14:51,384 ERROR [STDERR]  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
12:14:51,384 ERROR [STDERR]  at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:684)
12:14:51,384 ERROR [STDERR]  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
12:14:51,384 ERROR [STDERR]  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
12:14:51,384 ERROR [STDERR]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
12:14:51,384 ERROR [STDERR]  at java.lang.reflect.Method.invoke(Method.java:585)
12:14:51,384 ERROR [STDERR]  at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:62)
12:14:51,384 ERROR [STDERR]  at $Proxy60.execute(Unknown Source)
12:14:51,384 ERROR [STDERR]  at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:81)
12:14:51,384 ERROR [STDERR]  at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200)
12:14:51,384 ERROR [STDERR]  at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)
12:14:51,384 ERROR [STDERR]  ... 43 more
12:14:51,384 INFO  [STDOUT] UTF-8

Answer 6

web01？ 我怀疑你是不是连错了数据库！ 呵呵呵！

Answer 7

呵，不是，web01是在oracle建的一个测试用户，所有数据都在这个用户表空间进行的呢

Answer 8

从错误看，肯定是你的字段设置有问题。
和对象的类型有冲突，建议你减少UP_Admin_Old里面的字段数量，只更新username看看！逐个排除看看到底是哪个字段引发的问题！！！！！

Answer 9

set   
  web01.admin_info.adminname=#adminname#
where 
  web01.admin_info.adminid=#adminid# 

Answer 10

跟我上午想的一样，试过了问题依旧，ORA-01031:   insufficient   privileges 

Answer 11

程序中增删查都没问题，上午sql减到您所说的一个字段也是不行

Answer 12

你把 adminid 打印出来吧，
同时把你的adminname的字段信息贴一下！ 另外，你确认一下，不是有其它的进程锁着那行数据吧！ 比如没有commit之类的！

Answer 13

14:30:04,400 INFO  [STDOUT] adminid:3
14:30:04,665 INFO  [STDOUT] adminname:wxjyf2003没有事务未提交，在PL/SQL里可以很顺畅的执行SQL语句调试里VO所有的字段都是有值非空的。
有一个问题就是adminid在oracle对应类型为long，在程序中我对应是以Integer.parseInt(adminid)转换的，不知道会不会有问题？其他类型都有检查过，只有oracle中number类型是用Integer.parseInt(adminid)来转的，在VO类是用long来声明的

Answer 14

long ？？？？？？？？？？？？？？？
哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇
此long 非 彼 long 哦！换成 Number

Answer 15

你知道Long 是干啥用的吗？
Oracle太讨厌了，这个类型可是骗了太多的人了！！http://blog.csdn.net/a5174/archive/2006/10/23/1346767.aspx

Answer 16

long是干嘛用的？？？我对oracle不是很熟悉哦还有我第一次听人说oracle很讨厌，呵呵

Answer 17

今天终于弄好了，但是还是不知道问题所在。
早上恰好JBOSS更新配置，从VSS上get了一个新的JBOSS下来，替换旧的，再次运行启动，OK成功。估计可能是log4J配置方面造成的问题，但终究还是找不出原因。