oracle网络问题,orcale典型错误。网络上找不到解决方法

最新推荐文章于 2022-04-06 14:37:47 发布
最新推荐文章于 2022-04-06 14:37:47 发布
阅读量227 收藏
点赞数
文章标签： oracle网络问题

错误：

javax.servlet.ServletException: 异常:[201] [org.hibernate.exception.LockAcquisitionException: could not execute query]

at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:236)

at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.extremecomponents.table.filter.AbstractExportFilter.doFilter(AbstractExportFilter.java:49)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)

at com.mip.core.security.service.filter.MIPLastFilter.doFilter(MIPLastFilter.java:103)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)

at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:216)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at com.mip.core.security.service.filter.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:116)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at com.mip.core.security.service.filter.SSOProcessingFilter.doFilter(SSOProcessingFilter.java:176)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:195)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)

at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:78)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

at org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:891)

at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:750)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2283)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)

at java.lang.Thread.run(Thread.java:662)

Caused by: 异常:[201] [org.hibernate.exception.LockAcquisitionException: could not execute query]

at com.mip.biz.common.view.MyWorkController.unfinishList(MyWorkController.java:592)

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.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:358)

at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:218)

at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:192)

at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:175)

at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

at com.opensymphony.xwork.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:115)

at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

at com.opensymphony.webwork.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:174)

at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

at com.opensymphony.xwork.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:151)

at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

at com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:186)

at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116)

at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:225)

... 56 more

Caused by: org.hibernate.exception.LockAcquisitionException: could not execute query

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:87)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

at org.hibernate.loader.Loader.doList(Loader.java:2147)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)

at org.hibernate.loader.Loader.list(Loader.java:2023)

at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:95)

at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)

at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)

at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)

at com.mip.core.dao.support.page.CriteriaPage.getPageInstanceByCount(CriteriaPage.java:66)

at com.mip.core.dao.support.page.CriteriaPage.getPageInstance(CriteriaPage.java:39)

at com.mip.core.dao.PageHibernateDao.pagedQuery(PageHibernateDao.java:93)

at com.mip.core.dao.PageHibernateDao.pagedQuery(PageHibernateDao.java:86)

at com.mip.core.dao.PageHibernateDao.findECPage(PageHibernateDao.java:615)

at com.mip.core.base.dao.TasksOfMyWorkJbpmViewDao.findFinishedTasksOfActorId(TasksOfMyWorkJbpmViewDao.java:346)

at com.mip.core.base.dao.TasksOfMyWorkJbpmViewDao$$FastClassByCGLIB$$f71d2ae7.invoke()

at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)

at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:714)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)

at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:652)

at com.mip.core.base.dao.TasksOfMyWorkJbpmViewDao$$EnhancerByCGLIB$$425233fc.findFinishedTasksOfActorId()

at com.mip.common.services.imp.MyWorkServiceImpl.FindTasksOfActorId(MyWorkServiceImpl.java:350)

at com.mip.common.services.imp.MyWorkServiceImpl$$FastClassByCGLIB$$d330ac22.invoke()

at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)

at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:714)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)

at org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor.invoke(ThrowsAdviceInterceptor.java:125)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)

at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:51)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)

at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:53)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)

at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:53)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)

at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)

at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:652)

at com.mip.common.services.imp.MyWorkServiceImpl$$EnhancerByCGLIB$$bdaae7bd.FindTasksOfActorId()

at com.mip.biz.common.view.MyWorkController.unfinishList(MyWorkController.java:589)

... 93 more

Caused by: java.sql.SQLException: ORA-04030: 在尝试分配 11941456 字节 (kxs-heap-c,temporary memory) 时进程内存不足

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)

at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)

at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)

at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)

at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)

at $java.sql.Wrapper$$EnhancerByProxool$$6b909fb0.executeQuery()

at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)

at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)

at org.hibernate.loader.Loader.doQuery(Loader.java:662)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)

at org.hibernate.loader.Loader.doList(Loader.java:2144)

... 133 more

yan jay
关注
hibernate的Could not execute JDBC batch update错误原因及处理
derpvailzhangfan的专栏
04-26 21万+
         今天用hibernate做系统的时候，出现了Could not execute JDBC batch update错误，现在已经解决。先说说我的代码：         这是角色表对应的配置文件，当我在角色管理列表的jsp页面里删除选中的角色信息，就报了上面的错误。xml version="1.0"?>DOCTYPE hibernate-mapping PUBLIC
oracle drop 提交,oracle drop 存储过程
weixin_39899021的博客
04-03 955
Oracle中删除用户遇到的问题我新建了一个用户xy，并导入了一些表，序列，存储过程在其中。现在我用删除该用户出现问题执行drop user xy，报错ORA-01922: 必须指定 CASCADE 以删除 'XY'问题原因CASCADE众所周知是级联的意思，说明删除该用户要先删除与之相关或者级联的信息解决办法...文章徐胖子2012-09-08732浏览量oracle 数据结构oracle 数据...
oracle链接出错,Oracle连接出错最常见的原因
weixin_29782509的博客
04-08 199
1,ERROR: ORA-12560: TNS:protocol adapter error listener没有启动,在数据库所在的服务器上启动listener: lsnrctl start 2,ERRO1,ERROR:ORA-12560: TNS:protocol adapter errorlistener没有启动,在数据库所在的服务器上启动listener: lsnrctl start2,E...
Could not execute JDBC batch update
李双喆
08-15 7564
org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
org.hibernate.exception.LockAcquisitionException
shengfq的技术博客专栏
01-02 5546
LockAcquisitionException
java连接orcale数据库示例分享
09-04
一旦驱动加载成功，`DriverManager.getConnection(url, username, password)`将创建一个到Oracle数据库的连接。 在实际应用中，为了提高代码的健壮性和可维护性，通常会使用连接池来管理数据库连接，如Apache的DBCP...
oracle数据库部署
m0_68980728的博客
04-06 4018
Oracle数据库部署
怎么重启oracle定时任务计划,oracle如何设置定时任务（job）详情
weixin_33601504的博客
04-03 1269
http://blog.csdn.net/wyzxg/archive/2007/09/12/1782952.aspx------------------------------------------------------author:skatetime:2007-09-12http://publish.it168.com/2006/0311/20060311017002.shtml今天总结下o...
oracle数据库笔记（自用）
Neaze的博客
01-12 1906
oracle的详解
hibernate查询语句却报Could not execute JDBC batch update错误的原因追踪
坐忘峰
03-15 8055
业务系统在使用hibernate的list方法做查询时报了以下的一个错误： org.hibernate.exception.DataException: Could not execute JDBC batch update，非常奇怪，我们当前的方法中并没有做更新操做和保存操作啊，怎么报了这样一个错误？于是顺着问题追了下去，主要是org.hibernate.impl.SessionImpl中的关...
Could not execute JDBC batch update 错误 原因 oracle数据 你存入数据过大
u012182025的专栏
03-20 6577
message org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [insert into ADDRESS_KIND (KINDNAME, KINDInfo, kindId) values (?, ?,
SQLGrammarException: could not execute query的原因
linshao512的专栏
03-03 1650
SQLGrammarException: could not execute query的原因——查看自己的POJO的类名是否跟数据库的表一致。
使用Hibernate时出现“could not execute query”异常
热门推荐
zunguitiancheng的专栏
02-05 2万+
http://blog.sina.com.cn/s/blog_4a1dde860100dux3.html   项目中使用Hibernate作为持久层框架时，如果数据库由于某种原因需要改名，在修改数据库连接后出现“could not execute query”异常，那么有可能是因为你的项目里*.hbm.xml配置文件中的catalog属性值还是原数据库名，改成新数据库名即可。或者干脆将cata
oracle inactive 批量,oracle出现大量的active
weixin_39806603的博客
04-03 487
oracle出现大量的active2019-10-14Errors in file /opt/oracle/diag/rdbms/ai/ai/trace/ai_pmon_1878.trc:ORA-04030: out of process memory when trying to allocate 832 bytes (callheap,temporary memory)oracle出现大量的空...
Windows 7上Oracle 10g安装问题及解决方案
如果以上步骤未能解决问题，可能还需要查阅Oracle官方文档或社区论坛的解决方案，因为特定的安装错误可能需要更详细的排查和调试。例如，检查`refhost.xml`文件中的相关主机配置，或者确认网络连接和依赖库是否完整...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值