orcale sql数据库怎么进入异常 怎么返回英文
点击联系发帖人
时间：2017-11-09 23:52
win7安装orcale 10g异常终止的解决方案
win7安装orcale 10g异常终止的解决方案
在win7下安装orcale 10g出现错误，提示&程序异常终止,发生未知错误&的信息。
& www.2cto.com &
下面是解决方案：
首先修改\orcale\database\stage\prereq\db下的refhost.xml文件
在&CERTIFIED_SYSTEMS&后面添加如下内容：
& www.2cto.com &
&!--Microsoft Windows 7--&
& &&OPERATING_SYSTEM&
& &&VERSION VALUE=&6.1&/&
& &&/OPERATING_SYSTEM&
& & &OPERATING_SYSTEM&
然后在\orcale\database\install目录中找到oraparam.ini文件
#Windows=4.0,5.0,5.1,5.2
&#Windows=4.0,5.0,5.1,5.2,6.1
同时在后面添加如下内容：
[Windows-6.1-required] & &
#Minimum display colours for OUI to run & &
MIN_DISPLAY_COLORS=256 &&
#Minimum CPU speed required for OUI & &
#CPU=300 &&
[Windows-6.1-optional]&
最后，右击执行文件setup.exe，点击&属性&，以兼容性模式运行此程序,并以管理员的身份运行这个程序。
至此就解决上述的问题了。连接orcale数据库 - 开源中国社区
当前访客身份：游客 [
当前位置：
发布于 日 19时,
&无详细内容&
代码片段(3)
1.&[代码]database.properties&&&&
jdbc.driver_class=oracle.jdbc.driver.OracleDriver
jdbc.connection.url=jdbc:oracle:thin:@localhost:1521:orcl
jdbc.connection.username=scott
jdbc.connection.password=tiger
2.&[代码]ConfigManager.java&&&&
import java.io.IOE
import java.io.InputS
import java.util.P
//读取配置文件（属性文件）的工具类
public class ConfigManager {
private static ConfigManager configM
// properties.load(inputStream);读取属性文件
private static P
// 在构造工具类时，进行配置文件的读取
private ConfigManager() {
String configFile = "database.properties";
properties = new Properties();
InputStream is = ConfigManager.class.getClassLoader()
.getResourceAsStream(configFile);
// 读取配置文件
properties.load(is);
is.close();
} catch (IOException e) {
e.printStackTrace();
// 通过单例模式设置实例化个数
public static ConfigManager getInstance() {
if (configManager == null) {
configManager = new ConfigManager();
return configM
// 通过key获取对应的value
public String getString(String key) {
return properties.getProperty(key);
3.&[代码]BaseDao.java&&&&
import java.sql.C
import java.sql.DriverM
import java.sql.PreparedS
import java.sql.ResultS
import java.sql.SQLE
import java.sql.S
import com.util.ConfigM//ConfigManager.java工具类放置位置
//基类：数据库操作通用类
public class BaseDao {
protected C
protected PreparedS
protected S
protected ResultS
// 获取数据库连接
public boolean getConnection() {
// // 读取配置信息
String driver = ConfigManager.getInstance().getString(
"jdbc.driver_class");
String url = ConfigManager.getInstance().getString(
"jdbc.connection.url");
String username = ConfigManager.getInstance().getString(
"jdbc.connection.username");
String password = ConfigManager.getInstance().getString(
"jdbc.connection.password");
// 加载JDBC驱动
Class.forName(driver);
// 与数据库建立连接
conn = DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException e) {
} catch (SQLException e) {
// 增删改的通用方法
public int executeUpdate(String sql, Object[] params) {
int updateRows = 0;
getConnection();
ps = conn.prepareStatement(sql);
// 填充占位符
for (int i = 0; i & params. i++) {
ps.setObject(i + 1, params[i]);
System.out.println(i + 1 + "---" + params[i]);
System.out.println(sql);
updateRows = ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
return updateR
public ResultSet executeSQL(String sql, Object[] params) {
getConnection();
ps = conn.prepareStatement(sql);
// 填充占位符
for (int i = 0; i & params. i++) {
ps.setObject(i + 1, params[i]);
rs = ps.executeQuery();
} catch (SQLException e) {
e.printStackTrace();
// 关闭资源
public void closeAll(){
if(rs!=null){
rs.close();
if(stmt!=null){
stmt.close();
if(ps!=null){
ps.close();
if(conn!=null){
conn.close();
} catch (SQLException e) {
e.printStackTrace();
开源中国-程序员在线工具：
相关的代码(3455)
0回/1738阅
0回/1159阅
2回/1391阅
0回/1155阅
开源从代码分享开始
冰玉的其它代码 > 
 > 
 > 
在JAVA里面如何调用ORCALE数据库里的存储过程(带输入输出参数)的????
摘要：在JAVA里面如何调用ORCALE数据库里的存储过程(带输入输出参数)的????楼主Guizhi(一星一星。。。还是一星。。。从此努力升星)2:02:00在Java/J2SE/基础类提问rt问题点数:100、回复次数:7Top&iframescrolling=&no&src=&/Include/Board.htm?Tags=&frameborder=&0&&&/iframe&g
在JAVA里面如何调用ORCALE数据库里的存储过程(带输入输出参数)的????楼主Guizhi(一星一星。。。还是一星。。。从此努力升星) 12:02:00 在 Java / J2SE / 基础类 提问
rt 问题点数:100、回复次数:7Top &iframe scrolling=&no& src=&/Include/Board.htm?Tags=& frameborder=&0&&&/iframe&
1 楼Koham(永恒)回复于
12:07:08 得分 25
使用CallableStatement这个Interface来做,输入的参数和PreparedStatement相同,输出的需要使用registerOutParameter(int & parameterIndex, & int & sqlType) & 注册后取出。Top
2 楼Guizhi(一星一星。。。还是一星。。。从此努力升星)回复于
12:43:20 得分 0
能给个例子吗? & & & & Top
3 楼Raulgodle(赵蓓)回复于
17:14:40 得分 1
4 楼Raulgodle(赵蓓)回复于
21:21:50 得分 60
-- & create & the & PL/SQL & functions, & procedures & and & packages & & & & CREATE & PROCEDURE & update_product_price( & & & & & & p_product_id & IN & products.id%TYPE, & & & & p_factor & & & & & IN & NUMBER & & & & ) & AS & & & & & & product_count & INTEGER; & & & & BEGIN & & & & & & -- & count & the & number & of & products & with & the & & & & -- & supplied & id & (should & be & 1 & if & the & product & exists) & & & & SELECT & & & & & & COUNT(*) & & & & INTO & & & & & & product_count & & & & FROM & & & & & & products & & & & WHERE & & & & & & id & = & p_product_ & & & & & & -- & if & the & product & exists & (product_count & = & 1) & then & & & & -- & update & that & product's & price & & & & IF & product_count & = & 1 & THEN & & & & & & UPDATE & & & & & & & & products & & & & & & SET & & & & & & & & price & = & price & * & p_ & & & & & & COMMIT; & & & & END & IF; & & & & END & update_product_ & & / & & & & & & CREATE & FUNCTION & update_product_price_func( & & & & & & p_product_id & IN & products.id%TYPE, & & & & p_factor & & & & & IN & NUMBER & & & & ) & RETURN & INTEGER & AS & & & & & & product_count & INTEGER; & & & & BEGIN & & & & & & SELECT & & & & & & COUNT(*) & & & & INTO & & & & & & product_count & & & & FROM & & & & & & products & & & & WHERE & & & & & & id & = & p_product_ & & & & & & -- & if & the & product & doesn't & exist & then & return & 0, & & & & -- & otherwise & perform & the & update & and & return & 1 & & & & IF & product_count & = & 0 & THEN & & & & & & RETURN & 0; & & & & ELSE & & & & & & UPDATE & & & & & & & & products & & & & & & SET & & & & & & & & price & = & price & * & p_ & & & & & & COMMIT; & & & & & & RETURN & 1; & & & & END & IF; & & & & END & update_product_price_ & & / & & & & & & -- & package & ref_cursor_package & illustrates & the & use & of & the & & -- & REF & CURSOR & type & & CREATE & OR & REPLACE & PACKAGE & ref_cursor_package & AS & & & & & & TYPE & t_ref_cursor & IS & REF & CURSOR; & & & & FUNCTION & get_products_ref_cursor & RETURN & t_ref_ & & & & END & ref_cursor_ & & / & & & & CREATE & PACKAGE & BODY & ref_cursor_package & AS & & & & & & -- & function & get_products_ref_cursor() & returns & a & REF & CURSOR & & & & FUNCTION & get_products_ref_cursor & & & & RETURN & t_ref_cursor & IS & & & & & & & & products_ref_cursor & t_ref_ & & & & & & BEGIN & & & & & & & & -- & get & the & REF & CURSOR & & & & & & OPEN & products_ref_cursor & FOR & & & & & & & & SELECT & & & & & & & & & & id, & name, & price & & & & & & & & FROM & & & & & & & & & & & & & & & & & & -- & return & the & REF & CURSOR & & & & & & RETURN & products_ref_ & & & & & & END & get_products_ref_ & & & & END & ref_cursor_ & & / & & & & 调用: & & /* & & & & PLSQLExample1.java & shows & how & to & call & a & PL/SQL & procedure & & & & and & function & & */ & & & & // & import & the & JDBC & packages & & import & java.sql.*; & & & & public & class & PLSQLExample1 & { & & & & & & public & static & void & main(String & args & []) & & & & throws & SQLException & { & & & & & & & & // & register & the & Oracle & JDBC & drivers & & & & & & DriverManager.registerDriver( & & & & & & & & new & oracle.jdbc.OracleDriver() & & & & & & ); & & & & & & & & // & create & a & Connection & object, & and & connect & to & the & database & & & & & & // & as & store_user & using & the & Oracle & JDBC & Thin & driver & & & & & & Connection & myConnection & = & DriverManager.getConnection( & & & & & & & & &jdbc:oracle:thin:@localhost:1521:OCL&, & & & & & & & & &store_user&, & & & & & & & & &store_password& & & & & & & ); & & & & & & & & // & disable & auto-commit & mode & & & & & & myConnection.setAutoCommit(false); & & & & & & & & // & create & a & Statement & object & & & & & & Statement & myStatement & = & myConnection.createStatement(); & & & & & & & & // & display & product & #1's & id & and & price & & & & & & System.out.println(&Id & and & original & price&); & & & & & & displayProduct(myStatement, & 1); & & & & & & & & // & create & a & CallableStatement & object & to & call & the & & & & & & // & PL/SQL & procedure & update_product_price() & & & & & & CallableStatement & myCallableStatement & = & myConnection.prepareCall( & & & & & & & & &{call & update_product_price(?, & ?)}& & & & & & & ); & & & & & & & & // & bind & values & to & the & CallableStatement & object's & parameters & & & & & & myCallableStatement.setInt(1, & 1); & & & & & & myCallableStatement.setDouble(2, & 1.1); & & & & & & & & // & execute & the & CallableStatement & object & - & this & increases & the & price & & & & & & // & for & product & #1 & by & 10% & & & & & & myCallableStatement.execute(); & & & & & & System.out.println(&Increased & price & by & 10%&); & & & & & & displayProduct(myStatement, & 1); & & & & & & & & // & call & the & PL/SQL & function & update_product_price_func() & & & & & & myCallableStatement & = & myConnection.prepareCall( & & & & & & & & &{? & = & call & update_product_price_func(?, & ?)}& & & & & & & ); & & & & & & & & // & register & the & output & parameter, & and & bind & values & to & & & & & & // & the & CallableStatement & object's & parameters & & & & & & myCallableStatement.registerOutParameter(1, & java.sql.Types.INTEGER); & & & & & & myCallableStatement.setInt(2, & 1); & & & & & & myCallableStatement.setDouble(3, & 0.8); & & & & & & & & // & execute & the & CallableStatement & object & - & this & decreases & the & new & & & & & & // & price & for & product & #1 & by & 20% & & & & & & myCallableStatement.execute(); & & & & & & int & result & = & myCallableStatement.getInt(1); & & & & & & System.out.println(&Result & returned & from & function & = & & & + & result); & & & & & & System.out.println(&Decreased & new & price & by & 20%&); & & & & & & displayProduct(myStatement, & 1); & & & & & & & & // & reset & the & price & back & to & the & original & value & & & & & & myStatement.execute( & & & & & & & & &UPDATE & products & & & + & & & & & & & & &SET & price & = & 19.95& & + & & & & & & & & &WHERE & id & = & 1& & & & & & & ); & & & & & & myConnection.commit(); & & & & & & System.out.println(&Reset & price & back & to & 19.95&); & & & & & & & & // & close & the & JDBC & objects & & & & & & myCallableStatement.close(); & & & & & & myStatement.close(); & & & & & & myConnection.close(); & & & & & & } & // & end & of & main() & & & & & & & & public & static & void & displayProduct( & & & & & & Statement & myStatement, & & & & & & int & id & & & & ) & throws & SQLException & { & & & & & & & & // & display & the & id & and & price & columns & & & & & & ResultSet & productResultSet & = & myStatement.executeQuery( & & & & & & & & &SELECT & id, & price & & & + & & & & & & & & &FROM & products & & & + & & & & & & & & &WHERE & id & = & & & + & id & & & & & & ); & & & & & & productResultSet.next(); & & & & & & System.out.println(&id & = & & & + & productResultSet.getInt(&id&)); & & & & & & System.out.println(&price & = & & & + & productResultSet.getDouble(&price&)); & & & & & & & & productResultSet.close(); & & & & & & } & // & end & of & displayProduct() & & & & }Top
5 楼mousefog(IT老鼠)回复于
23:20:15 得分 12
这个我做过,不过我是在一个操作类中调用的,这个操作类负责对数据的 & & insert,update,select,delete & & insert的参数一般和表的字段数相同,如果有序列的话,可以少一个参数 & & 其他的三个一般都按主键来操作 & & 想要代码,留e_mail给我,我发给你Top
6 楼wuyaxlz(芒果苯苯)回复于
14:38:17 得分 1
有没有参数传出呀????Top
7 楼viano(优秀是一种习惯!)回复于
15:02:57 得分 1
& & & & jsp从入门到精通 & & & 要有实例!&
以上是的内容，更多
的内容，请您使用右上方搜索功能获取相关信息。
若你要投稿、删除文章请联系邮箱：zixun-group@service.aliyun.com,工作人员会在五个工作日内给你回复。
新用户大礼包！
现在注册，免费体验40+云产品，及域名优惠！
云服务器 ECS
可弹性伸缩、安全稳定、简单易用
&40.8元/月起
预测未发生的攻击
&24元/月起
你可能还喜欢
你可能感兴趣
阿里云教程中心为您免费提供
在JAVA里面如何调用ORCALE数据库里的存储过程(带输入输出参数)的????相关信息，包括
的信息，所有在JAVA里面如何调用ORCALE数据库里的存储过程(带输入输出参数)的????相关内容均不代表阿里云的意见！投稿删除文章请联系邮箱：zixun-group@service.aliyun.com，工作人员会在五个工作日内答复
售前咨询热线
支持与服务
资源和社区
关注阿里云
International在orcale数据库中删除了数据 jsp页面为什么还能查出来_百度知道
在orcale数据库中删除了数据 jsp页面为什么还能查出来
我添加了数据后自己在PL/SQL中执行了删除语句I，在数据库中查询已经没有数据了，但是在JSP页面上通过查询却能够查到删除过的数据，这是为什么。有昨天删除的数据跟今天删除的数据都能...
我添加了数据后自己在PL/SQL 中执行了删除语句I，
在数据库中查询已经没有数据了，但是在JSP 页面上通过查询 却能够查到删除过的数据，这是为什么。
有昨天删除的数据 跟今天删除的数据
都能查出来
答题抽奖
首次认真答题后
即可获得3次抽奖机会，100%中奖。
来自电脑网络类芝麻团
采纳数：1115
获赞数：1263
参与团队：
确定是同一个数据库，同一个表？确定有 commit ?
为你推荐：
其他类似问题
个人、企业类
违法有害信息,请在下方选择后提交
色情、暴力
我们会通过消息、邮箱等方式尽快将举报结果通知您。orcale典型错误。网络上找不到解决方法 - Oracle数据库管理 - ITPUB论坛－中国专业的IT技术社区
后使用快捷导航没有帐号？
查看: 1097|回复: 7
orcale典型错误。网络上找不到解决方法
论坛徽章:0
以下报错，重启之后oracle能正常用一段时间，之后又报错。（此错误是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 moreCaused 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 moreCaused by: java.sql.SQLException: ORA-04030: 在尝试分配
字节 (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
论坛徽章:0
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: 在尝试分配
字节 (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
论坛徽章:17
估计是ORACLE软件出问题了，系统层面ORACLE软件的损坏！
论坛徽章:0
tanjiaping 发表于
估计是ORACLE软件出问题了，系统层面ORACLE软件的损坏！
有没有可能是oracle配置问题。-
但重启oracle，之后能用一段时间
论坛徽章:307
Caused by: java.sql.SQLException: ORA-04030: 在尝试分配
字节 (kxs-heap-c,temporary memory) 时进程内存不足
论坛徽章:9
应用程序没有管理好数据库连接。
论坛徽章:0
当网页上报这个错误后，我用pl/sql链接oracel，直接输入很长的sql后，也报这个错误
论坛徽章:0
应该不是系统配置的问题，应该是oracle配置的问题，但我不懂
itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有
北京市公安局海淀分局网监中心备案编号：10 广播电视节目制作经营许可证：编号（京）字第1149号}
win7安装orcale 10g异常终止的解决方案
在win7下安装orcale 10g出现错误，提示&程序异常终止,发生未知错误&的信息。
& www.2cto.com &
下面是解决方案：
首先修改\orcale\database\stage\prereq\db下的refhost.xml文件
在&CERTIFIED_SYSTEMS&后面添加如下内容：
& www.2cto.com &
&!--Microsoft Windows 7--&
& &&OPERATING_SYSTEM&
& &&VERSION VALUE=&6.1&/&
& &&/OPERATING_SYSTEM&
& & &OPERATING_SYSTEM&
然后在\orcale\database\install目录中找到oraparam.ini文件
#Windows=4.0,5.0,5.1,5.2
&#Windows=4.0,5.0,5.1,5.2,6.1
同时在后面添加如下内容：
[Windows-6.1-required] & &
#Minimum display colours for OUI to run & &
MIN_DISPLAY_COLORS=256 &&
#Minimum CPU speed required for OUI & &
#CPU=300 &&
[Windows-6.1-optional]&
最后，右击执行文件setup.exe，点击&属性&，以兼容性模式运行此程序,并以管理员的身份运行这个程序。
至此就解决上述的问题了。连接orcale数据库 - 开源中国社区
当前访客身份：游客 [
当前位置：
发布于 日 19时,
&无详细内容&
代码片段(3)
1.&[代码]database.properties&&&&
jdbc.driver_class=oracle.jdbc.driver.OracleDriver
jdbc.connection.url=jdbc:oracle:thin:@localhost:1521:orcl
jdbc.connection.username=scott
jdbc.connection.password=tiger
2.&[代码]ConfigManager.java&&&&
import java.io.IOE
import java.io.InputS
import java.util.P
//读取配置文件（属性文件）的工具类
public class ConfigManager {
private static ConfigManager configM
// properties.load(inputStream);读取属性文件
private static P
// 在构造工具类时，进行配置文件的读取
private ConfigManager() {
String configFile = "database.properties";
properties = new Properties();
InputStream is = ConfigManager.class.getClassLoader()
.getResourceAsStream(configFile);
// 读取配置文件
properties.load(is);
is.close();
} catch (IOException e) {
e.printStackTrace();
// 通过单例模式设置实例化个数
public static ConfigManager getInstance() {
if (configManager == null) {
configManager = new ConfigManager();
return configM
// 通过key获取对应的value
public String getString(String key) {
return properties.getProperty(key);
3.&[代码]BaseDao.java&&&&
import java.sql.C
import java.sql.DriverM
import java.sql.PreparedS
import java.sql.ResultS
import java.sql.SQLE
import java.sql.S
import com.util.ConfigM//ConfigManager.java工具类放置位置
//基类：数据库操作通用类
public class BaseDao {
protected C
protected PreparedS
protected S
protected ResultS
// 获取数据库连接
public boolean getConnection() {
// // 读取配置信息
String driver = ConfigManager.getInstance().getString(
"jdbc.driver_class");
String url = ConfigManager.getInstance().getString(
"jdbc.connection.url");
String username = ConfigManager.getInstance().getString(
"jdbc.connection.username");
String password = ConfigManager.getInstance().getString(
"jdbc.connection.password");
// 加载JDBC驱动
Class.forName(driver);
// 与数据库建立连接
conn = DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException e) {
} catch (SQLException e) {
// 增删改的通用方法
public int executeUpdate(String sql, Object[] params) {
int updateRows = 0;
getConnection();
ps = conn.prepareStatement(sql);
// 填充占位符
for (int i = 0; i & params. i++) {
ps.setObject(i + 1, params[i]);
System.out.println(i + 1 + "---" + params[i]);
System.out.println(sql);
updateRows = ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
return updateR
public ResultSet executeSQL(String sql, Object[] params) {
getConnection();
ps = conn.prepareStatement(sql);
// 填充占位符
for (int i = 0; i & params. i++) {
ps.setObject(i + 1, params[i]);
rs = ps.executeQuery();
} catch (SQLException e) {
e.printStackTrace();
// 关闭资源
public void closeAll(){
if(rs!=null){
rs.close();
if(stmt!=null){
stmt.close();
if(ps!=null){
ps.close();
if(conn!=null){
conn.close();
} catch (SQLException e) {
e.printStackTrace();
开源中国-程序员在线工具：
相关的代码(3455)
0回/1738阅
0回/1159阅
2回/1391阅
0回/1155阅
开源从代码分享开始
冰玉的其它代码 > 
 > 
 > 
在JAVA里面如何调用ORCALE数据库里的存储过程(带输入输出参数)的????
摘要：在JAVA里面如何调用ORCALE数据库里的存储过程(带输入输出参数)的????楼主Guizhi(一星一星。。。还是一星。。。从此努力升星)2:02:00在Java/J2SE/基础类提问rt问题点数:100、回复次数:7Top&iframescrolling=&no&src=&/Include/Board.htm?Tags=&frameborder=&0&&&/iframe&g
在JAVA里面如何调用ORCALE数据库里的存储过程(带输入输出参数)的????楼主Guizhi(一星一星。。。还是一星。。。从此努力升星) 12:02:00 在 Java / J2SE / 基础类 提问
rt 问题点数:100、回复次数:7Top &iframe scrolling=&no& src=&/Include/Board.htm?Tags=& frameborder=&0&&&/iframe&
1 楼Koham(永恒)回复于
12:07:08 得分 25
使用CallableStatement这个Interface来做,输入的参数和PreparedStatement相同,输出的需要使用registerOutParameter(int & parameterIndex, & int & sqlType) & 注册后取出。Top
2 楼Guizhi(一星一星。。。还是一星。。。从此努力升星)回复于
12:43:20 得分 0
能给个例子吗? & & & & Top
3 楼Raulgodle(赵蓓)回复于
17:14:40 得分 1
4 楼Raulgodle(赵蓓)回复于
21:21:50 得分 60
-- & create & the & PL/SQL & functions, & procedures & and & packages & & & & CREATE & PROCEDURE & update_product_price( & & & & & & p_product_id & IN & products.id%TYPE, & & & & p_factor & & & & & IN & NUMBER & & & & ) & AS & & & & & & product_count & INTEGER; & & & & BEGIN & & & & & & -- & count & the & number & of & products & with & the & & & & -- & supplied & id & (should & be & 1 & if & the & product & exists) & & & & SELECT & & & & & & COUNT(*) & & & & INTO & & & & & & product_count & & & & FROM & & & & & & products & & & & WHERE & & & & & & id & = & p_product_ & & & & & & -- & if & the & product & exists & (product_count & = & 1) & then & & & & -- & update & that & product's & price & & & & IF & product_count & = & 1 & THEN & & & & & & UPDATE & & & & & & & & products & & & & & & SET & & & & & & & & price & = & price & * & p_ & & & & & & COMMIT; & & & & END & IF; & & & & END & update_product_ & & / & & & & & & CREATE & FUNCTION & update_product_price_func( & & & & & & p_product_id & IN & products.id%TYPE, & & & & p_factor & & & & & IN & NUMBER & & & & ) & RETURN & INTEGER & AS & & & & & & product_count & INTEGER; & & & & BEGIN & & & & & & SELECT & & & & & & COUNT(*) & & & & INTO & & & & & & product_count & & & & FROM & & & & & & products & & & & WHERE & & & & & & id & = & p_product_ & & & & & & -- & if & the & product & doesn't & exist & then & return & 0, & & & & -- & otherwise & perform & the & update & and & return & 1 & & & & IF & product_count & = & 0 & THEN & & & & & & RETURN & 0; & & & & ELSE & & & & & & UPDATE & & & & & & & & products & & & & & & SET & & & & & & & & price & = & price & * & p_ & & & & & & COMMIT; & & & & & & RETURN & 1; & & & & END & IF; & & & & END & update_product_price_ & & / & & & & & & -- & package & ref_cursor_package & illustrates & the & use & of & the & & -- & REF & CURSOR & type & & CREATE & OR & REPLACE & PACKAGE & ref_cursor_package & AS & & & & & & TYPE & t_ref_cursor & IS & REF & CURSOR; & & & & FUNCTION & get_products_ref_cursor & RETURN & t_ref_ & & & & END & ref_cursor_ & & / & & & & CREATE & PACKAGE & BODY & ref_cursor_package & AS & & & & & & -- & function & get_products_ref_cursor() & returns & a & REF & CURSOR & & & & FUNCTION & get_products_ref_cursor & & & & RETURN & t_ref_cursor & IS & & & & & & & & products_ref_cursor & t_ref_ & & & & & & BEGIN & & & & & & & & -- & get & the & REF & CURSOR & & & & & & OPEN & products_ref_cursor & FOR & & & & & & & & SELECT & & & & & & & & & & id, & name, & price & & & & & & & & FROM & & & & & & & & & & & & & & & & & & -- & return & the & REF & CURSOR & & & & & & RETURN & products_ref_ & & & & & & END & get_products_ref_ & & & & END & ref_cursor_ & & / & & & & 调用: & & /* & & & & PLSQLExample1.java & shows & how & to & call & a & PL/SQL & procedure & & & & and & function & & */ & & & & // & import & the & JDBC & packages & & import & java.sql.*; & & & & public & class & PLSQLExample1 & { & & & & & & public & static & void & main(String & args & []) & & & & throws & SQLException & { & & & & & & & & // & register & the & Oracle & JDBC & drivers & & & & & & DriverManager.registerDriver( & & & & & & & & new & oracle.jdbc.OracleDriver() & & & & & & ); & & & & & & & & // & create & a & Connection & object, & and & connect & to & the & database & & & & & & // & as & store_user & using & the & Oracle & JDBC & Thin & driver & & & & & & Connection & myConnection & = & DriverManager.getConnection( & & & & & & & & &jdbc:oracle:thin:@localhost:1521:OCL&, & & & & & & & & &store_user&, & & & & & & & & &store_password& & & & & & & ); & & & & & & & & // & disable & auto-commit & mode & & & & & & myConnection.setAutoCommit(false); & & & & & & & & // & create & a & Statement & object & & & & & & Statement & myStatement & = & myConnection.createStatement(); & & & & & & & & // & display & product & #1's & id & and & price & & & & & & System.out.println(&Id & and & original & price&); & & & & & & displayProduct(myStatement, & 1); & & & & & & & & // & create & a & CallableStatement & object & to & call & the & & & & & & // & PL/SQL & procedure & update_product_price() & & & & & & CallableStatement & myCallableStatement & = & myConnection.prepareCall( & & & & & & & & &{call & update_product_price(?, & ?)}& & & & & & & ); & & & & & & & & // & bind & values & to & the & CallableStatement & object's & parameters & & & & & & myCallableStatement.setInt(1, & 1); & & & & & & myCallableStatement.setDouble(2, & 1.1); & & & & & & & & // & execute & the & CallableStatement & object & - & this & increases & the & price & & & & & & // & for & product & #1 & by & 10% & & & & & & myCallableStatement.execute(); & & & & & & System.out.println(&Increased & price & by & 10%&); & & & & & & displayProduct(myStatement, & 1); & & & & & & & & // & call & the & PL/SQL & function & update_product_price_func() & & & & & & myCallableStatement & = & myConnection.prepareCall( & & & & & & & & &{? & = & call & update_product_price_func(?, & ?)}& & & & & & & ); & & & & & & & & // & register & the & output & parameter, & and & bind & values & to & & & & & & // & the & CallableStatement & object's & parameters & & & & & & myCallableStatement.registerOutParameter(1, & java.sql.Types.INTEGER); & & & & & & myCallableStatement.setInt(2, & 1); & & & & & & myCallableStatement.setDouble(3, & 0.8); & & & & & & & & // & execute & the & CallableStatement & object & - & this & decreases & the & new & & & & & & // & price & for & product & #1 & by & 20% & & & & & & myCallableStatement.execute(); & & & & & & int & result & = & myCallableStatement.getInt(1); & & & & & & System.out.println(&Result & returned & from & function & = & & & + & result); & & & & & & System.out.println(&Decreased & new & price & by & 20%&); & & & & & & displayProduct(myStatement, & 1); & & & & & & & & // & reset & the & price & back & to & the & original & value & & & & & & myStatement.execute( & & & & & & & & &UPDATE & products & & & + & & & & & & & & &SET & price & = & 19.95& & + & & & & & & & & &WHERE & id & = & 1& & & & & & & ); & & & & & & myConnection.commit(); & & & & & & System.out.println(&Reset & price & back & to & 19.95&); & & & & & & & & // & close & the & JDBC & objects & & & & & & myCallableStatement.close(); & & & & & & myStatement.close(); & & & & & & myConnection.close(); & & & & & & } & // & end & of & main() & & & & & & & & public & static & void & displayProduct( & & & & & & Statement & myStatement, & & & & & & int & id & & & & ) & throws & SQLException & { & & & & & & & & // & display & the & id & and & price & columns & & & & & & ResultSet & productResultSet & = & myStatement.executeQuery( & & & & & & & & &SELECT & id, & price & & & + & & & & & & & & &FROM & products & & & + & & & & & & & & &WHERE & id & = & & & + & id & & & & & & ); & & & & & & productResultSet.next(); & & & & & & System.out.println(&id & = & & & + & productResultSet.getInt(&id&)); & & & & & & System.out.println(&price & = & & & + & productResultSet.getDouble(&price&)); & & & & & & & & productResultSet.close(); & & & & & & } & // & end & of & displayProduct() & & & & }Top
5 楼mousefog(IT老鼠)回复于
23:20:15 得分 12
这个我做过,不过我是在一个操作类中调用的,这个操作类负责对数据的 & & insert,update,select,delete & & insert的参数一般和表的字段数相同,如果有序列的话,可以少一个参数 & & 其他的三个一般都按主键来操作 & & 想要代码,留e_mail给我,我发给你Top
6 楼wuyaxlz(芒果苯苯)回复于
14:38:17 得分 1
有没有参数传出呀????Top
7 楼viano(优秀是一种习惯!)回复于
15:02:57 得分 1
& & & & jsp从入门到精通 & & & 要有实例!&
以上是的内容，更多
的内容，请您使用右上方搜索功能获取相关信息。
若你要投稿、删除文章请联系邮箱：zixun-group@service.aliyun.com,工作人员会在五个工作日内给你回复。
新用户大礼包！
现在注册，免费体验40+云产品，及域名优惠！
云服务器 ECS
可弹性伸缩、安全稳定、简单易用
&40.8元/月起
预测未发生的攻击
&24元/月起
你可能还喜欢
你可能感兴趣
阿里云教程中心为您免费提供
在JAVA里面如何调用ORCALE数据库里的存储过程(带输入输出参数)的????相关信息，包括
的信息，所有在JAVA里面如何调用ORCALE数据库里的存储过程(带输入输出参数)的????相关内容均不代表阿里云的意见！投稿删除文章请联系邮箱：zixun-group@service.aliyun.com，工作人员会在五个工作日内答复
售前咨询热线
支持与服务
资源和社区
关注阿里云
International在orcale数据库中删除了数据 jsp页面为什么还能查出来_百度知道
在orcale数据库中删除了数据 jsp页面为什么还能查出来
我添加了数据后自己在PL/SQL中执行了删除语句I，在数据库中查询已经没有数据了，但是在JSP页面上通过查询却能够查到删除过的数据，这是为什么。有昨天删除的数据跟今天删除的数据都能...
我添加了数据后自己在PL/SQL 中执行了删除语句I，
在数据库中查询已经没有数据了，但是在JSP 页面上通过查询 却能够查到删除过的数据，这是为什么。
有昨天删除的数据 跟今天删除的数据
都能查出来
答题抽奖
首次认真答题后
即可获得3次抽奖机会，100%中奖。
来自电脑网络类芝麻团
采纳数：1115
获赞数：1263
参与团队：
确定是同一个数据库，同一个表？确定有 commit ?
为你推荐：
其他类似问题
个人、企业类
违法有害信息,请在下方选择后提交
色情、暴力
我们会通过消息、邮箱等方式尽快将举报结果通知您。orcale典型错误。网络上找不到解决方法 - Oracle数据库管理 - ITPUB论坛－中国专业的IT技术社区
后使用快捷导航没有帐号？
查看: 1097|回复: 7
orcale典型错误。网络上找不到解决方法
论坛徽章:0
以下报错，重启之后oracle能正常用一段时间，之后又报错。（此错误是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 moreCaused 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 moreCaused by: java.sql.SQLException: ORA-04030: 在尝试分配
字节 (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
论坛徽章:0
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: 在尝试分配
字节 (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
论坛徽章:17
估计是ORACLE软件出问题了，系统层面ORACLE软件的损坏！
论坛徽章:0
tanjiaping 发表于
估计是ORACLE软件出问题了，系统层面ORACLE软件的损坏！
有没有可能是oracle配置问题。-
但重启oracle，之后能用一段时间
论坛徽章:307
Caused by: java.sql.SQLException: ORA-04030: 在尝试分配
字节 (kxs-heap-c,temporary memory) 时进程内存不足
论坛徽章:9
应用程序没有管理好数据库连接。
论坛徽章:0
当网页上报这个错误后，我用pl/sql链接oracel，直接输入很长的sql后，也报这个错误
论坛徽章:0
应该不是系统配置的问题，应该是oracle配置的问题，但我不懂
itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有
北京市公安局海淀分局网监中心备案编号：10 广播电视节目制作经营许可证：编号（京）字第1149号}
我要回帖
更多关于 orcale数据库 的文章
更多推荐
- ·正方形的小学三年级已知面积求边长怎么求？
- ·星际争霸最厉害的十位选手选手sky是什么学历？
- ·学学做西餐一般要多久的培训？
- ·剪映怎么导出相册视频如何提取音频mp3
- ·剪映怎么提取音频如何导出音频mp3？
- ·我的大脚趾指甲边缘疼下有两三个给点儿，有一个特别明显，能不能麻烦哪位大夫帮我看看，这是咋回事儿？
- ·歆曼商学院靠谱吗好不好?有没有电商培训课程？
- ·自考本科报考研究生毕业后还可以报考网络远程本科吗？
- ·你好，我在中银快付被骗办了一张卡，被骗了，能否把损失找回来
- ·亚洲港这个牌子的铜芯电缆型号好用吗？质量怎样。
- ·用中国银行卓隽卡visa能转账吗
- ·七彩语文国际版画刊版订阅？有什么优惠多的的网站呢？
- ·加拿大签证所需材料不足六个月
- ·如何写出一篇优秀的产品文案兼职多少钱一篇
- ·马路边的树图片上，每棵树上都有一根细铁丝吊着这个，这是什么啊？里面是好大的蛹，谁能帮忙解释一下？
- ·做主管经理培训课程干着经理的工作 是好是坏
- ·Is there anything Iyou can do anythingfor you?
- ·您好想向您讨教欧姆龙PLc555定时器器(BCD)类型参数修改步骤。谢射
- ·哪些学校考研自然地理比较好考的学校不考高数
- ·orcale sql数据库怎么进入异常 怎么返回英文
- ·播音高考传媒播音培训需要注意什么
- ·进口代理报关费计入什么科目应该计入哪个会计科目
- ·实习期间想请假去面试别的公司该怎么说啊？
- ·这句要转述句怎么改改？
- ·我有个九年的。也是铜的相对原子质量。也不知道价格
- ·这几个朝鲜平壤字是什么意思
- ·大神些，百家号通知我开通原创，百家号要不要开原创通
- ·申请加拿大签证不足5万半年可入境吗？
- ·早上刷牙恶心想吐反胃反胃是什么原因啊 要吃什么药？
- ·月经推迟几天算正常老不正常，大家都让我求教李耀花老师？求问百度网友回答谢谢
- ·语法分析器的功能下语法
- ·3Dmax中如何将这个3Dmax物体与物体怎么链接保留一半
- ·此项目的翻译是：bt项目是什么意思思
- ·15年我用现金打钱到邮政储蓄银行存款利率帐号里，现在对方说没有给，又不给我帐号了，我还可以查到吗
- ·玉雕机能不能改怎么把图片反转方向向
