ORA-17627: ORA-12577: Message 12577 not found;

rman target sys/oracle@orcl auxiliary sys/oracle@ORCL2

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Oct 31 10:09:17 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (DBID=1451001194)
connected to auxiliary database: ORCL (not mounted)

RMAN> duplicate target database for standby from active database;

Starting Duplicate Db at 31-OCT-16
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=131 device type=DISK

contents of Memory Script:
{
backup as copy reuse
targetfile '/oracle/product/11.2.0/db_1/dbs/orapworcl' auxiliary format
'E:\app\Administrator\product\11.2.0\dbhome_1\DATABASE\PWDorcl.ORA' ;
}
executing Memory Script

Starting backup at 31-OCT-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=131 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/31/2016 10:09:30
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/31/2016 10:09:30
ORA-17627: ORA-12577: Message 12577 not found; product=RDBMS; facility=ORA

1个回答

看看是不是没有磁盘空间了
http://blog.csdn.net/cuiyan1982/article/details/52932036

wyl43381998
wyl43381998 备库所在磁盘还有300多个G的可用空间
3 年多之前 回复
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
PL/SQL: ORA-00942: table or view does not exist

DECLARE CURSOR c_tab IS SELECT * FROM user_tables; v_row user_tables%ROWTYPE; v_count INTEGER; BEGIN OPEN c_tab; LOOP FETCH c_tab INTO v_row; EXIT WHEN c_tab%NOTFOUND; dbms_output.put_line(v_row.table_name); SELECT COUNT(*) INTO v_count FROM v_row.table_name; IF v_count<>0 THEN dbms_output.put_line(v_row.table_name||'is not null'); END IF; END LOOP; CLOSE c_tab; END; ORA-06550: line 12, column 52: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 12, column 12: PL/SQL: SQL Statement ignored 请各位大神指导,游标的值最终给了变量,但是说找不到这表

重复的事务标识,求解决方案,框架:springMVC+mybatis,数据库oracle

项目总是隔两天报一次错误:重复的事物标识,报错的sql总是涉及到 使用 db_link的sql语句,重启项目后就好了,求高手解答!!! 报错内容如下: ``` HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: type Exception report message Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: description The server encountered an internal error that prevented it from fulfilling this request. exception org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: ### Error querying database. Cause: java.sql.SQLException: ORA-24757: 重复的事务处理标识 ORA-02063: 紧接着 line (起自 XBZHPDB) ### The error may exist in file [C:\tomcat\apache-tomcat-7.0.70\webapps\webApi\WEB-INF\classes\com\petrochina\mapping\StaypxsjhMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT nvl(sum(A.XSL/A.ZB),0) FROM (SELECT nvl(sum(QY_PFWCL+ QY_LSWCL+CY_PFWCL+ CY_LSWCL),0) as XSL,MZXNJG, (select AREA_SCZB FROM BASE_PROVINCIAL_AREA@xbzhpdb WHERE AREA_SQBM = MZXNJG) as ZB FROM STA_YPXSJH_WC WHERE to_char(CALDAY,'yyyy-mm-dd') BETWEEN ? and ? GROUP BY MZXNJG) A WHERE A.ZB is not null ### Cause: java.sql.SQLException: ORA-24757: 重复的事务处理标识 ORA-02063: 紧接着 line (起自 XBZHPDB) ; uncategorized SQLException for SQL []; SQL state [99999]; error code [24757]; ORA-24757: 重复的事务处理标识 ORA-02063: 紧接着 line (起自 XBZHPDB) ; nested exception is java.sql.SQLException: ORA-24757: 重复的事务处理标识 ORA-02063: 紧接着 line (起自 XBZHPDB) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:973) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852) javax.servlet.http.HttpServlet.service(HttpServlet.java:624) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:108) root cause org.springframework.jdbc.UncategorizedSQLException: ### Error querying database. Cause: java.sql.SQLException: ORA-24757: 重复的事务处理标识 ORA-02063: 紧接着 line (起自 XBZHPDB) ### The error may exist in file [C:\tomcat\apache-tomcat-7.0.70\webapps\webApi\WEB-INF\classes\com\petrochina\mapping\StaypxsjhMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT nvl(sum(A.XSL/A.ZB),0) FROM (SELECT nvl(sum(QY_PFWCL+ QY_LSWCL+CY_PFWCL+ CY_LSWCL),0) as XSL,MZXNJG, (select AREA_SCZB FROM BASE_PROVINCIAL_AREA@xbzhpdb WHERE AREA_SQBM = MZXNJG) as ZB FROM STA_YPXSJH_WC WHERE to_char(CALDAY,'yyyy-mm-dd') BETWEEN ? and ? GROUP BY MZXNJG) A WHERE A.ZB is not null ### Cause: java.sql.SQLException: ORA-24757: 重复的事务处理标识 ORA-02063: 紧接着 line (起自 XBZHPDB) ; uncategorized SQLException for SQL []; SQL state [99999]; error code [24757]; ORA-24757: 重复的事务处理标识 ORA-02063: 紧接着 line (起自 XBZHPDB) ; nested exception is java.sql.SQLException: ORA-24757: 重复的事务处理标识 ORA-02063: 紧接着 line (起自 XBZHPDB) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371) com.sun.proxy.$Proxy13.selectOne(Unknown Source) org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:163) org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:68) org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52) com.sun.proxy.$Proxy30.queryShengTotalZhanBi(Unknown Source) com.petrochina.service.impl.staypxsjhServiceImpl.XBWL_scgk(staypxsjhServiceImpl.java:383) com.petrochina.controller.HomeController.XBWL_scgk(HomeController.java:1041) sun.reflect.GeneratedMethodAccessor146.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215) org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749) org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:690) org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:945) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:876) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852) javax.servlet.http.HttpServlet.service(HttpServlet.java:624) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:108) note The full stack trace of the root cause is available in the Apache Tomcat/7.0.70 logs. Apache Tomcat/7.0.70 ```

ORACLE:ORA-01017错误

如题 检查了dataSource.properties中数据库用户密码没有错误 Struts Problem Report Struts has detected an unhandled exception: Messages: ORA-01017: invalid username/password; logon denied Cannot create PoolableConnectionFactory (ORA-01017: invalid username/password; logon denied ) Cannot open connection Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection File: oracle/jdbc/driver/DatabaseError.java Line number: 112

在oracle11g 中运行下列代码为什么会提示ORA1-01008 并非所有变量都已绑定

declare cursor login (tuser Users.UserName%type,tpwd Users.UserPwd%type) is select * from Users where UserName=tuser and UserPwd=tpwd; loginrow login%rowtype; begin open login(:login.tuser,:login.tpwd); fetch login into loginrow; if login%found then go_block('main'); message('登录成功');commit; :login.tuser:=''; :login.tpwd:=''; :global.quanxian:=loginrow.quanxian; :global.userno:=loginrow.userno; :global.punish:=0; else message('对不起,用户名或密码错误,请重新输入');commit; :login.tuser:='';:login.tpwd:=''; end if; close login; end; ![图片说明](https://img-ask.csdn.net/upload/201801/07/1515312619_307826.png)

Oracle 11g TNS-12547: TNS: 丢失连接 在线等

服务器运行服务,执行个20多条sql语句之后,后面的4-5条程序就报错了,继续执行又正常,查询日志是报的TNS-12547: TNS: 丢失连接 错误,tnsping正常,用户最大连接数已到300,还望大虾指点

Rman为什么会尝试应用今天全库备份之前的归档呢?不是应该应用全库备份之后产生的归档吗?

我用Rman做了全库备份和归档日志备份,以下是备份: arc_936057575_53_3762.arc 归档 arc_936068367_55_3763.arc arc_936079186_60_3764.arc arc_936089969_62_3765.arc full_DAWH_20170216_1prsmkom_1_1 全库 full_DAWH_20170216_1qrsmkon_1_1 o1_mf_s_936068379_db998vw3_.bkp controlfile和spfile备份 o1_mf_s_936073797_db9gl5pw_.bkp o1_mf_s_936079201_db9mv286_.bkp o1_mf_s_936089985_db9yd1xo_.bkp 这是我今天中午为止这一天内产生的备份。 恢复的时候,先restore,然后recover的时候, 从下面会看出rman在找昨天的3761~3627的归档日志,而今天产生的3762~3765的归档却不应用。 3761~3627这段归档,是昨天的归档, 今天16号的归档只有3762~3765。 那么问题来了,restore了今天的全备,为什么recover的时候会去找做了全备之前的归档呢? 如果是因为controlfile太老了,那不是应该应用正确的归档把controlfile更新吗?怎么不应用正确的归档呢? RMAN> recover database; Starting recover at 16-FEB-17 using channel ORA_DISK_1 starting media recovery Oracle Error: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/DAWH/oradata/DAWH/system01.dbf' RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 02/16/2017 17:53:20 RMAN-06053: unable to perform media recovery because of missing log RMAN-06025: no backup of archived log for thread 1 with sequence 3761 and starting SCN of 1320314801 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 3760 and starting SCN of 1320288564 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 3759 and starting SCN of 1320259166 found to restore ......................................................... RMAN-06025: no backup of archived log for thread 1 with sequence 3672 and starting SCN of 1315631128 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 3671 and starting SCN of 1315503024 found to restore .................................................. RMAN-06025: no backup of archived log for thread 1 with sequence 3629 and starting SCN of 1312028064 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 3628 and starting SCN of 1311948459 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 3627 and starting SCN of 1311875444 found to restore RMAN-00567: Recovery Manager could not print some error messages

linux环境下sqlplus连接数据库报错

如图,用root用户登陆,切换到oracle用户,然后输入sqlplus /nolog登陆数据库,以前这样登过一次,成功登上了,可是这次却报了两个错误,请问这是为什么?应该怎么解决呢? 报错信息如下: SP2-0667: Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Hibernate insert出错!

<p> </p> <p> </p> <p>以下是错误信息!我用的是Oracle</p> <p>HTTP Status 500 -</p> <p> </p> <p>type Exception report</p> <p> </p> <p>message</p> <p> </p> <p>description The server encountered an internal error () that prevented it from fulfilling this request.</p> <p> </p> <p>exception</p> <p> </p> <p>org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update</p> <p><span style="white-space: pre;"> </span>org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:636)</p> <p><span style="white-space: pre;"> </span>org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:789)</p> <p><span style="white-space: pre;"> </span>org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:663)</p> <p><span style="white-space: pre;"> </span>org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)</p> <p><span style="white-space: pre;"> </span>org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)</p> <p><span style="white-space: pre;"> </span>org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)</p> <p><span style="white-space: pre;"> </span>org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)</p> <p><span style="white-space: pre;"> </span>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)</p> <p><span style="white-space: pre;"> </span>org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)</p> <p><span style="white-space: pre;"> </span>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)</p> <p><span style="white-space: pre;"> </span>org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)</p> <p><span style="white-space: pre;"> </span>$Proxy17.addhf(Unknown Source)</p> <p><span style="white-space: pre;"> </span>action.FileAction.add(FileAction.java:44)</p> <p><span style="white-space: pre;"> </span>sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</p> <p><span style="white-space: pre;"> </span>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</p> <p><span style="white-space: pre;"> </span>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</p> <p><span style="white-space: pre;"> </span>java.lang.reflect.Method.invoke(Method.java:597)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)</p> <p>root cause</p> <p> </p> <p>org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update</p> <p><span style="white-space: pre;"> </span>org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)</p> <p><span style="white-space: pre;"> </span>org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)</p> <p><span style="white-space: pre;"> </span>org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)</p> <p><span style="white-space: pre;"> </span>org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)</p> <p><span style="white-space: pre;"> </span>org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)</p> <p><span style="white-space: pre;"> </span>org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)</p> <p><span style="white-space: pre;"> </span>org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)</p> <p><span style="white-space: pre;"> </span>org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)</p> <p><span style="white-space: pre;"> </span>org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)</p> <p><span style="white-space: pre;"> </span>org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)</p> <p><span style="white-space: pre;"> </span>org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655)</p> <p><span style="white-space: pre;"> </span>org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)</p> <p><span style="white-space: pre;"> </span>org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)</p> <p><span style="white-space: pre;"> </span>org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)</p> <p><span style="white-space: pre;"> </span>org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)</p> <p><span style="white-space: pre;"> </span>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)</p> <p><span style="white-space: pre;"> </span>org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)</p> <p><span style="white-space: pre;"> </span>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)</p> <p><span style="white-space: pre;"> </span>org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)</p> <p><span style="white-space: pre;"> </span>$Proxy17.addhf(Unknown Source)</p> <p><span style="white-space: pre;"> </span>action.FileAction.add(FileAction.java:44)</p> <p><span style="white-space: pre;"> </span>sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</p> <p><span style="white-space: pre;"> </span>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</p> <p><span style="white-space: pre;"> </span>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</p> <p><span style="white-space: pre;"> </span>java.lang.reflect.Method.invoke(Method.java:597)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)</p> <p>root cause</p> <p> </p> <p>java.sql.BatchUpdateException: ORA-02291: integrity constraint (HR.SYS_C005351) violated - parent key not found</p> <p> </p> <p><span style="white-space: pre;"> </span>oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:342)</p> <p><span style="white-space: pre;"> </span>oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)</p> <p><span style="white-space: pre;"> </span>org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)</p> <p><span style="white-space: pre;"> </span>org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)</p> <p><span style="white-space: pre;"> </span>org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)</p> <p><span style="white-space: pre;"> </span>org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)</p> <p><span style="white-space: pre;"> </span>org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)</p> <p><span style="white-space: pre;"> </span>org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)</p> <p><span style="white-space: pre;"> </span>org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)</p> <p><span style="white-space: pre;"> </span>org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)</p> <p><span style="white-space: pre;"> </span>org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)</p> <p><span style="white-space: pre;"> </span>org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655)</p> <p><span style="white-space: pre;"> </span>org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)</p> <p><span style="white-space: pre;"> </span>org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)</p> <p><span style="white-space: pre;"> </span>org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)</p> <p><span style="white-space: pre;"> </span>org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)</p> <p><span style="white-space: pre;"> </span>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)</p> <p><span style="white-space: pre;"> </span>org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)</p> <p><span style="white-space: pre;"> </span>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)</p> <p><span style="white-space: pre;"> </span>org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)</p> <p><span style="white-space: pre;"> </span>$Proxy17.addhf(Unknown Source)</p> <p><span style="white-space: pre;"> </span>action.FileAction.add(FileAction.java:44)</p> <p><span style="white-space: pre;"> </span>sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</p> <p><span style="white-space: pre;"> </span>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</p> <p><span style="white-space: pre;"> </span>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</p> <p><span style="white-space: pre;"> </span>java.lang.reflect.Method.invoke(Method.java:597)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)</p> <p><span style="white-space: pre;"> </span>com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)</p> <p><span style="white-space: pre;"> </span>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)</p> <p>note The full stack trace of the root cause is available in the Apache Tomcat/6.0.13 logs.</p> <p> </p> <p>Apache Tomcat/6.0.13</p>

Laravel 5.3:视图中的未定义变量[重复]

<div class="post-text" itemprop="text"> <div class="question-status question-originals-of-duplicate"> <p>This question already has an answer here:</p> <ul> <li> <a href="/questions/4261133/notice-undefined-variable-notice-undefined-index-and-notice-undefined" dir="ltr">“Notice: Undefined variable”, “Notice: Undefined index”, and “Notice: Undefined offset” using PHP</a> <span class="question-originals-answer-count"> 28 answers </span> </li> </ul> </div> <p>I got message Undefined variable </p> <blockquote> <p>Undefined variable: pesan (View: C:\xampp\htdocs\webapp esources\views\welcome.blade.php)</p> </blockquote> <p>This my controller</p> <pre><code>... public function index(){ $data = DB::table('data_peminjaman')-&gt;get(); $inventaris = DB::table('inventaris')-&gt;get(); $posting = DB::table('artikel')-&gt;get(); $pesan = null; $semuanya = ['posting' =&gt; $posting, 'pesan' =&gt; $pesan, 'data' =&gt; $data, '$inventaris' =&gt; $inventaris]; return view('welcome', $semuanya); } ... </code></pre> <p>This is my blade code</p> <pre><code> @if ($pesan !=null) &lt;div class="alert alert-danger"&gt; {{ $pesan }} &lt;/div&gt; @endif </code></pre> </div>

Oracle中no_data_found问题

请看如下代码: create or replace procedure pro_test as v1 varchar2(100); begin select nvl(max(name), -1) into v1 from t1 where 1=2; --select nvl(name, -1) into v1 from t1 where 1=2; dbms_output.put_line('test:'||v1); end; 结果显示为:test:-1 但是运行如下代码: create or replace procedure pro_test as v1 varchar2(100); begin --select nvl(max(name), -1) into v1 from t1 where 1=2; select nvl(name, -1) into v1 from t1 where 1=2; dbms_output.put_line('test:'||v1); end; 会报错,错误信息如下: ![图片说明](https://img-ask.csdn.net/upload/201711/23/1511413416_548118.png) 为什么加了一个max()和不加max(),结果会不一样?select into执行为空时,max()函数 在其中做了些什么?

too long

<div class="post-text" itemprop="text"> <p>I use PHP's <code>simplexml_load_file()</code> function to call an API that returns changed results based on a Timestamp that I send.</p> <p>So the API will return only results that have changed since my Timestamp. The problem I am having is if the timestamp is too soon and there are no results for the API to return, then it does not return a proper XML file, instead it will just return a blank page.</p> <p>This is causing all sorts of problems with <code>simplexml_load_file</code></p> <p>Here is a simple test I can run...</p> <pre><code>$xml = 'http://api.rescuegroups.org/rest/?key=CZivWWGD&amp;type=orgs&amp;limit=300&amp;updatedAfter=1361941202&amp;startPage=1'; $xmlObj = new SimpleXMLElement($xml, NULL, TRUE); </code></pre> <p>This results in...</p> <pre><code>Warning: SimpleXMLElement::__construct(): http://api.rescuegroups.org/rest/?key=CZivWWGD&amp;type=orgs&amp;limit=300&amp;updatedAfter=1361941202&amp;startPage=1:1: parser error : Document is empty in E:\Server\htdocs\labs\freelance\dogAPI\testorg.php on line 9 Warning: SimpleXMLElement::__construct(): in E:\Server\htdocs\labs\freelance\dogAPI\testorg.php on line 9 Warning: SimpleXMLElement::__construct(): ^ in E:\Server\htdocs\labs\freelance\dogAPI\testorg.php on line 9 Warning: SimpleXMLElement::__construct(): http://api.rescuegroups.org/rest/?key=CZivWWGD&amp;type=orgs&amp;limit=300&amp;updatedAfter=1361941202&amp;startPage=1:1: parser error : Start tag expected, '&lt;' not found in E:\Server\htdocs\labs\freelance\dogAPI\testorg.php on line 9 Warning: SimpleXMLElement::__construct(): in E:\Server\htdocs\labs\freelance\dogAPI\testorg.php on line 9 Warning: SimpleXMLElement::__construct(): ^ in E:\Server\htdocs\labs\freelance\dogAPI\testorg.php on line 9 Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in E:\Server\htdocs\labs\freelance\dogAPI\testorg.php:9 Stack trace: #0 E:\Server\htdocs\labs\freelance\dogAPI\testorg.php(9): SimpleXMLElement-&gt;__construct('http://api.resc...', 0, true) #1 {main} thrown in E:\Server\htdocs\labs\freelance\dogAPI\testorg.php on line 9 </code></pre> <p>Now if I pass the API a Timestamp that is further back where there are results, then it will return a perfect XML document.</p> <p>I am looking for a way to possibly prevent this nasty error from happening somehow?</p> </div>

请教!急 !!tomcat一直报错。如下:

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The Network Adapter could not establish the connection) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) at com.garage.xdatasource.XDataSource.getConnection(XDataSource.java:326) at com.garage.xdatabase.DBAccessUtil.getRsToList(DBAccessUtil.java:272) at com.garage.xdatabase.Access.getRsToList(Access.java:94) at com.garage.xdatabase.Access.getRsToList(Access.java:75) at com.mixky.common.database.GarageDataAccessTemplate.find(GarageDataAccessTemplate.java:142) at com.mixky.common.database.GarageDataAccessTemplate.find(GarageDataAccessTemplate.java:117) at com.mixky.common.database.MixkyDataAccess.find(MixkyDataAccess.java:234) at com.mixky.cluster.ClusterSync.doClusterSync(ClusterSync.java:84) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:276) at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBe an.java:260) at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:531) Caused by: java.sql.SQLException: The Network Adapter could not establish the connection at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510) at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221) ... 18 more Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:328) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:421) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:634) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:208) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292) ... 26 more Caused by: java.net.ConnectException: Connection timed out: connect at java.net.DualStackPlainSocketImpl.connect0(Native Method) at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:579) at java.net.Socket.connect(Socket.java:528) at java.net.Socket.<init>(Socket.java:425) at java.net.Socket.<init>(Socket.java:208) at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:127) at oracle.net.nt.ConnOption.connect(ConnOption.java:126) at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:306) ... 31 more

oracle使用游标将一个表数据插入另一个表中报错

对于学生选课表sc(sno,cno,grade),创建相同结构的新表sc1,并将sc数据全部加入到sc1,然后通过游标对sc1进行成绩更新: 成绩为: 80~100 更新为5; 60~80, 更新为3; 低于60分,更新为0; 更新之后对比sc和sc1,查看更新效果 ``` ```declare sc1_sno sc1.sno%type; sc1_cno sc1.cno%type; sc1_grade sc1.grade%type; cursor sc_cursor is select sno,cno,grade from sc; begin open sc_cursor; loop fetch sc_cursor into sc1_sno,sc1_cno,sc1_grade; exit when sc_cursor % notfound; if sc1_grade>=80 then sc1_grade:=5; else if sc1_grade<60 then sc1_grade:=0; else sc1_grade:=3; end if; end if; insert into sc1(sno,cno,grade) values (sc1_sno,sc1_cno,sc1_grade); end loop; close sc_cursor; commit; end; ``` ``` 错误报告: ORA-00001: 违反唯一约束条件 (STUDENT.SYS_C004830) ORA-06512: 在 line 21 00001. 00000 - "unique constraint (%s.%s) violated" *Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level. *Action: Either remove the unique restriction or do not insert the key. ``` ```

Oracle数据库启动实例出现:错误1053,服务没有及时响应或控制请求)

oracle监听可以正常启动: cmd: Lsnrctl status 出现如下信息: ![图片说明](https://img-ask.csdn.net/upload/201804/18/1524041785_956454.jpg) oracle的alert日志提示如下信息: <msg time='2018-04-15T07:02:54.163+08:00' org_id='oracle' comp_id='rdbms' type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17'> <txt> Fatal NI connect error 12638, connecting to: (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) </txt> </msg> <msg time='2018-04-15T07:02:54.194+08:00' org_id='oracle' comp_id='rdbms' type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17'> <txt> VERSION INFORMATION: TNS for 32-bit Windows: Version 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production </txt> </msg> <msg time='2018-04-15T07:02:54.194+08:00' org_id='oracle' comp_id='rdbms' type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17'> <txt> Time: 15-4月 -2018 07:02:54 </txt> </msg> <msg time='2018-04-15T07:02:54.194+08:00' org_id='oracle' comp_id='rdbms' type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17'> <txt> Tracing not turned on. </txt> </msg> <msg time='2018-04-15T07:02:54.194+08:00' org_id='oracle' comp_id='rdbms' type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17'> <txt> Tns error struct: </txt> </msg> <msg time='2018-04-15T07:02:54.194+08:00' org_id='oracle' comp_id='rdbms' type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17'> <txt> ns main err code: 12638 </txt> </msg> <msg time='2018-04-15T07:02:54.194+08:00' org_id='oracle' comp_id='rdbms' type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17'> <txt> </txt> </msg> <msg time='2018-04-15T07:02:54.397+08:00' org_id='oracle' comp_id='rdbms' type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17'> <txt>TNS-12638: 身份证明检索失败 </txt> </msg> <msg time='2018-04-15T07:02:54.397+08:00' org_id='oracle' comp_id='rdbms' type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17'> <txt> ns secondary err code: 0 </txt> </msg> <msg time='2018-04-15T07:02:54.397+08:00' org_id='oracle' comp_id='rdbms' type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17'> <txt> nt main err code: 0 </txt> </msg> <msg time='2018-04-15T07:02:54.397+08:00' org_id='oracle' comp_id='rdbms' type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17'> <txt> nt secondary err code: 0 </txt> </msg> <msg time='2018-04-15T07:02:54.397+08:00' org_id='oracle' comp_id='rdbms' type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17'> <txt> nt OS err code: 0 </txt> </msg> <msg time='2018-04-15T07:02:58.219+08:00' <msg time='2018-04-15T07:02:58.219+08:00' <msg time='2018-04-15T07:03:02.212+08:00' org_id='oracle' comp_id='rdbms' client_id='' type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17' module='' pid='3084'> <txt>AUD: OS Error = 1717 encountered while writing audit record </txt> </msg> <msg time='2018-04-15T07:03:02.212+08:00' org_id='oracle' comp_id='rdbms' client_id='' type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17' module='' pid='3084'> <txt>opidcl aborting process unknown ospid (3084) as a result of ORA-28056 </txt> </msg> <msg time='2018-04-15T07:03:02.290+08:00' org_id='oracle' comp_id='rdbms' client_id='' type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17' module='' pid='2820'> <txt>AUD: OS Error = 1717 encountered while writing audit record </txt> </msg> <msg time='2018-04-15T07:03:02.306+08:00' org_id='oracle' comp_id='rdbms' client_id='' type='UNKNOWN' level='16' host_id='WINDOWS-07WTF9D' host_addr='fe80::15bb:1d0:8d13:5301%17' module='' pid='2820'> <txt>opidcl aborting process unknown ospid (2820) as a result of ORA-28056 </txt> </msg> 运行环境:windows server 2008r2 数据库在2018年04月15日前正常运行,数据库实例死掉后,重启出现如下错误 ![图片说明](https://img-ask.csdn.net/upload/201804/18/1524044441_486805.jpg)

求教oracle dataguard 主备库日志无法同步的问题

现在做data guard 测试,试了很多次,主库的日志一直 无法同步到备份库。求高手解答。 测试环境 主库::操作系统 redhat 5.8 地址 192.168.1.135 数据库版本 oracle 10.2.0 备库: 操作系统 redhat 5.8 地址 192.168.1.3 数据库版本 oracle 10.2.0 主库参数文件 orcl.__db_cache_size=390070272 orcl.__java_pool_size=4194304 orcl.__large_pool_size=4194304 orcl.__shared_pool_size=155189248 orcl.__streams_pool_size=0 *.audit_file_dest='/app/oracle/product/10.2.0/db_1/admin/orcl/adump' *.background_dump_dest='/app/oracle/product/10.2.0/db_1/admin/orcl/bdump' *.compatible='10.2.0.1.0' *.control_files='/app/oracle/product/10.2.0/db_1/oradata/orcl/control01.ctl','/app/oracle/product/10.2.0/db_1/oradata/orcl/control02.ctl','/app/oracle/product/10.2.0/db_1/oradata/orcl/control03.ctl' *.core_dump_dest='/app/oracle/product/10.2.0/db_1/admin/orcl/cdump' *.db_block_size=8192 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_file_name_convert='STDDB','PRIDB' *.db_name='orcl' *.db_unique_name='PRIDB' *.db_recovery_file_dest='/app/oracle/product/10.2.0/db_1/flash_recovery_area' *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)' *.fal_client='DB_PRIDB' *.fal_server='DB_STDDB' *.job_queue_processes=10 *.log_archive_config='DG_CONFIG=(PRIDB,STDDB)' *.log_archive_dest_1='LOCATION=/app/oracle/product/10.2.0/db_1/oradata/archivelog_orcl VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRIDB' *.log_archive_dest_2='SERVICE=DB_STDDB LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STDDB' *.log_archive_dest_state_1='ENABLE' *.log_archive_dest_state_2='ENABLE' *.log_archive_format='%t_%s_%r.dbf' *.log_archive_max_processes=5 *.log_file_name_convert='STDDB','PRIDB' *.nls_language='SIMPLIFIED CHINESE' *.nls_territory='CHINA' *.open_cursors=300 *.pga_aggregate_target=186646528 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=559939584 *.standby_archive_dest='LOCATION=/app/oracle/product/10.2.0/db_1/oradata/archivelog_orcl' *.standby_file_management='AUTO' *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/app/oracle/product/10.2.0/db_1/admin/orcl/udump' 备库参数文件 orcl.__db_cache_size=390070272 orcl.__java_pool_size=4194304 orcl.__large_pool_size=4194304 orcl.__shared_pool_size=155189248 orcl.__streams_pool_size=0 *.audit_file_dest='/app/oracle/product/10.2.0/db_1/admin/orcl/adump' *.background_dump_dest='/app/oracle/product/10.2.0/db_1/admin/orcl/bdump' *.compatible='10.2.0.1.0' *.control_files='/app/oracle/product/10.2.0/db_1/oradata/orcl/control01.ctl','/app/oracle/product/10.2.0/db_1/oradata/orcl/control02.ctl','/app/oracle/product/10.2.0/db_1/oradata/orcl/control03.ctl' *.core_dump_dest='/app/oracle/product/10.2.0/db_1/admin/orcl/cdump' *.db_block_size=8192 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_file_name_convert='PRIDB','STDDB' *.db_name='orcl' *.db_recovery_file_dest='/app/oracle/product/10.2.0/db_1/flash_recovery_area' *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)' *.db_unique_name='STDDB' *.fal_client='db_stddb' *.fal_server='db_pridb' *.job_queue_processes=10 *.log_archive_config='DG_CONFIG=(STDDB,PRIDB)' *.log_archive_dest_1='LOCATION=/app/oracle/product/10.2.0/db_1/oradata/archivelog_orcl VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=STDDB' *.log_archive_dest_2='SERVICE=db_pridb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRIDB' *.log_archive_dest_state_1='ENABLE' *.log_archive_dest_state_2='ENABLE' *.log_archive_format='%t_%s_%r.dbf' *.log_archive_max_processes=5 *.log_file_name_convert='PRIDB','STDDB' *.nls_language='SIMPLIFIED CHINESE' *.nls_territory='CHINA' *.open_cursors=300 *.pga_aggregate_target=186646528 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=559939584 *.standby_archive_dest='LOCATION=/app/oracle/product/10.2.0/db_1/oradata/archivelog_orcl' *.standby_file_management='AUTO' *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/app/oracle/product/10.2.0/db_1/admin/orcl/udump' 主库ntsname文件 DB_PRIDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.135)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) DB_STDDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 备库tnsnames文件 DB_PRIDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.135)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) DB_STDDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 主库alert.log文件 Error 12514 received logging on to the standby Fri Oct 23 15:05:03 2015 Errors in file /app/oracle/product/10.2.0/db_1/admin/orcl/bdump/orcl_arc4_5182.trc: ORA-12514: Message 12514 not found; No message file for product=RDBMS, facility=ORA PING[ARC4]: Heartbeat failed to connect to standby 'DB_STDDB'. Error is 12514. Fri Oct 23 15:10:03 2015 Error 12514 received logging on to the standby Fri Oct 23 15:10:03 2015 Errors in file /app/oracle/product/10.2.0/db_1/admin/orcl/bdump/orcl_arc4_5182.trc: ORA-12514: Message 12514 not found; No message file for product=RDBMS, facility=ORA PING[ARC4]: Heartbeat failed to connect to standby 'DB_STDDB'. Error is 12514. Fri Oct 23 15:15:03 2015 Error 12514 received logging on to the standby Fri Oct 23 15:15:03 2015 Errors in file /app/oracle/product/10.2.0/db_1/admin/orcl/bdump/orcl_arc4_5182.trc: ORA-12514: Message 12514 not found; No message file for product=RDBMS, facility=ORA PING[ARC4]: Heartbeat failed to connect to standby 'DB_STDDB'. Error is 12514. Fri Oct 23 15:20:03 2015 Error 12514 received logging on to the standby Fri Oct 23 15:20:03 2015 Errors in file /app/oracle/product/10.2.0/db_1/admin/orcl/bdump/orcl_arc4_5182.trc: ORA-12514: Message 12514 not found; No message file for product=RDBMS, facility=ORA PING[ARC4]: Heartbeat failed to connect to standby 'DB_STDDB'. Error is 12514. Fri Oct 23 15:25:03 2015 Error 12514 received logging on to the standby Fri Oct 23 15:25:03 2015 Errors in file /app/oracle/product/10.2.0/db_1/admin/orcl/bdump/orcl_arc4_5182.trc: ORA-12514: Message 12514 not found; No message file for product=RDBMS, facility=ORA PING[ARC4]: Heartbeat failed to connect to standby 'DB_STDDB'. Error is 12514. Fri Oct 23 15:25:40 2015 Thread 1 advanced to log sequence 6 Current log# 2 seq# 6 mem# 0: /app/oracle/product/10.2.0/db_1/oradata/orcl/redo02.log 备库alert.log 文件 ARCH: STARTING ARCH PROCESSES ARC0 started with pid=16, OS id=8947 ARC1 started with pid=17, OS id=8949 ARC2 started with pid=18, OS id=8951 ARC3 started with pid=19, OS id=8953 Fri Oct 23 14:41:41 2015 ARC0: Archival started ARC1: Archival started ARC2: Archival started ARC3: Archival started ARC4: Archival started ARCH: STARTING ARCH PROCESSES COMPLETE Fri Oct 23 14:41:41 2015 ARC1: Becoming the 'no FAL' ARCH ARC1: Becoming the 'no SRL' ARCH ARC1: Thread not mounted Fri Oct 23 14:41:41 2015 ARC3: Becoming the heartbeat ARCH ARC3: Thread not mounted Fri Oct 23 14:41:41 2015 ARC0: Thread not mounted ARC4 started with pid=20, OS id=8955 ARC4: Thread not mounted Fri Oct 23 14:41:41 2015 ARC2: Thread not mounted Fri Oct 23 14:41:41 2015 Successful mount of redo thread 1, with mount id 1421667489 Fri Oct 23 14:41:41 2015 Physical Standby Database mounted. Completed: alter database mount standby database Fri Oct 23 14:42:21 2015 alter database recover managed standby database disconnect from session Fri Oct 23 14:42:21 2015 Attempt to start background Managed Standby Recovery process (orcl) MRP0 started with pid=21, OS id=8958 Fri Oct 23 14:42:21 2015 MRP0: Background Managed Standby Recovery process started (orcl) Managed Standby Recovery not using Real Time Apply Media Recovery Waiting for thread 1 sequence 3 Fri Oct 23 14:42:27 2015 Completed: alter database recover managed standby database disconnect from session Fri Oct 23 14:56:30 2015 db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup.

当解析 XML 时出现的错误

在应用程序打开之前 XMLParser 就崩溃了。错误是: org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:137) XMLParser 代码: public class XMLParser { public XMLParser(){ } public String getXmlFromUrl(String url){ String xml = null; try{ DefaultHttpClient httpClient = new DefaultHttpClient(); HttpPost httpPost = new HttpPost(url); HttpResponse httpResponse = httpClient.execute(httpPost); HttpEntity httpEntity = httpResponse.getEntity(); xml = EntityUtils.toString(httpEntity); } catch (UnsupportedEncodingException e){ e.printStackTrace(); } catch (ClientProtocolException e){ e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } return xml; } public Document getDomElement(String xml){ Document doc = null; DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance(); try{ DocumentBuilder db = dbf.newDocumentBuilder(); InputSource is = new InputSource(); is.setCharacterStream(new StringReader(xml)); doc = db.parse(is); } catch(ParserConfigurationException e) { Log.e("Error: ", e.getMessage()); return null; } catch (SAXException e) { Log.e("Error: ", e.getMessage()); return null; } catch (IOException e) { Log.e("Error: ", e.getMessage()); return null; } return doc; } public final String getElementValue(Node elem) { Node child; if(elem != null){ if(elem.hasChildNodes()){ for(child = elem.getFirstChild(); child != null; child = child.getNextSibling()){ if(child.getNodeType() == Node.TEXT_NODE){ return child.getNodeValue(); } } } } return ""; } public String getValue(Element item, String str){ NodeList n = item.getElementsByTagName(str); return this.getElementValue(n.item(0)); } } 在 main activity 中是这样调用的: XMLParser parser = new XMLParser(); String xml = parser.getXmlFromUrl(URL); Document doc = parser.getDomElement(xml); 所以问题出在哪里呢?

HTTP Status 500 - could not execute query 哪位大哥知道这是怎么回事?

HTTP Status 500 - could not execute query type Exception report message could not execute query description The server encountered an internal error that prevented it from fulfilling this request. exception org.hibernate.exception.SQLGrammarException: could not execute query org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) org.hibernate.loader.Loader.doList(Loader.java:2235) org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129) org.hibernate.loader.Loader.list(Loader.java:2124) org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149) org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) hisense.crm.commons.PageManage.getlist(PageManage.java:19) hisense.crm.manager.action.NewyingxiaoAction.rotatelist(NewyingxiaoAction.java:492) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:601) com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450) com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252) org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265) org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:252) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:161) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.utils.DebugInterceptor.intercept(DebugInterceptor.java:57) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54) org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:563) org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77) org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99) hisense.crm.filter.UeditorFilter.doFilter(UeditorFilter.java:17) root cause java.sql.SQLException: ORA-00904: "TWXNEWYXPR0_"."JFTOTAL": 标识符无效 oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213) oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796) oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031) oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836) oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124) oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285) oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329) org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) org.hibernate.loader.Loader.getResultSet(Loader.java:1812) org.hibernate.loader.Loader.doQuery(Loader.java:697) org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) org.hibernate.loader.Loader.doList(Loader.java:2232) org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129) org.hibernate.loader.Loader.list(Loader.java:2124) org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149) org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) hisense.crm.commons.PageManage.getlist(PageManage.java:19) hisense.crm.manager.action.NewyingxiaoAction.rotatelist(NewyingxiaoAction.java:492) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:601) com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450) com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252) org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265) org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:252) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:161) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) com.utils.DebugInterceptor.intercept(DebugInterceptor.java:57) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54) org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:563) org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77) org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99) hisense.crm.filter.UeditorFilter.doFilter(UeditorFilter.java:17) note The full stack trace of the root cause is available in the Apache Tomcat/6.0.37 logs.

oracle数据库,运行sqlplus,出现ORACLE SQL*PLUS已经停止的错误

直接运行sqlplus命令,以及打开cmd运行sqlplus都会出现,以上问题,小弟急于导数据,求各位大神们解决一下

如何使用codeigniter调用具有in和out参数的oracle存储过程?

<div class="post-text" itemprop="text"> <p>I already setup the codeigniter dbdriver to "oci8".</p> <p>For reference, here's my stored procedure. This is just my sample stored procedure.</p> <pre><code>CREATE OR REPLACE STORED PROCEDURE sp_sample( in_id IN VARCHAR2, out_code OUT varchar, out_desc OUT varchar) IS var_result VARCHAR2(100); CURSOR GetStatus (my_id IN NUMBER) IS SELECT status FROM tbl_sample WHERE id= my_id; BEGIN OPEN GetStatus(in_id); LOOP FETCH GetStatus into var_result; EXIT WHEN GetStatus%NOTFOUND; END LOOP; CLOSE GetStatus; IF(result != 'A') UPDATE tbl_sample SET status = 'A' WHERE id = in_id; COMMIT; out_code := '00'; out_desc := 'Success'; ELSE out_code := '01'; out_desc := 'Already active'; END IF; END sp_sample; </code></pre> <p>And this is how I call the stored proc in codeigniter:</p> <pre><code>$id = '10'; $params = array($id); $result = $this-&gt;db-&gt;query("CALL sp_sample(?, @out_code, @out_desc)", $params); exit($result); </code></pre> <p>Then I get this error message:</p> <pre><code>Query error: ORA-00936: missing expression - Invalid query: CALL sp_sample('10', @out_code, @out_code) </code></pre> <p>My question now is how can I call the oracle stored procedure using codeigniter? How to bind the parameters correctly?</p> <p>Thanks, Irvin</p> </div>

在中国程序员是青春饭吗?

今年,我也32了 ,为了不给大家误导,咨询了猎头、圈内好友,以及年过35岁的几位老程序员……舍了老脸去揭人家伤疤……希望能给大家以帮助,记得帮我点赞哦。 目录: 你以为的人生 一次又一次的伤害 猎头界的真相 如何应对互联网行业的「中年危机」 一、你以为的人生 刚入行时,拿着傲人的工资,想着好好干,以为我们的人生是这样的: 等真到了那一天,你会发现,你的人生很可能是这样的: ...

程序员请照顾好自己,周末病魔差点一套带走我。

程序员在一个周末的时间,得了重病,差点当场去世,还好及时挽救回来了。

技术大佬:我去,你写的 switch 语句也太老土了吧

昨天早上通过远程的方式 review 了两名新来同事的代码,大部分代码都写得很漂亮,严谨的同时注释也很到位,这令我非常满意。但当我看到他们当中有一个人写的 switch 语句时,还是忍不住破口大骂:“我擦,小王,你丫写的 switch 语句也太老土了吧!” 来看看小王写的代码吧,看完不要骂我装逼啊。 private static String createPlayer(PlayerTypes p...

和黑客斗争的 6 天!

互联网公司工作,很难避免不和黑客们打交道,我呆过的两家互联网公司,几乎每月每天每分钟都有黑客在公司网站上扫描。有的是寻找 Sql 注入的缺口,有的是寻找线上服务器可能存在的漏洞,大部分都...

上班一个月,后悔当初着急入职的选择了

最近有个老铁,告诉我说,上班一个月,后悔当初着急入职现在公司了。他之前在美图做手机研发,今年美图那边今年也有一波组织优化调整,他是其中一个,在协商离职后,当时捉急找工作上班,因为有房贷供着,不能没有收入来源。所以匆忙选了一家公司,实际上是一个大型外包公司,主要派遣给其他手机厂商做外包项目。**当时承诺待遇还不错,所以就立马入职去上班了。但是后面入职后,发现薪酬待遇这块并不是HR所说那样,那个HR自...

女程序员,为什么比男程序员少???

昨天看到一档综艺节目,讨论了两个话题:(1)中国学生的数学成绩,平均下来看,会比国外好?为什么?(2)男生的数学成绩,平均下来看,会比女生好?为什么?同时,我又联想到了一个技术圈经常讨...

总结了 150 余个神奇网站,你不来瞅瞅吗?

原博客再更新,可能就没了,之后将持续更新本篇博客。

副业收入是我做程序媛的3倍,工作外的B面人生是怎样的?

提到“程序员”,多数人脑海里首先想到的大约是:为人木讷、薪水超高、工作枯燥…… 然而,当离开工作岗位,撕去层层标签,脱下“程序员”这身外套,有的人生动又有趣,马上展现出了完全不同的A/B面人生! 不论是简单的爱好,还是正经的副业,他们都干得同样出色。偶尔,还能和程序员的特质结合,产生奇妙的“化学反应”。 @Charlotte:平日素颜示人,周末美妆博主 大家都以为程序媛也个个不修边幅,但我们也许...

如果你是老板,你会不会踢了这样的员工?

有个好朋友ZS,是技术总监,昨天问我:“有一个老下属,跟了我很多年,做事勤勤恳恳,主动性也很好。但随着公司的发展,他的进步速度,跟不上团队的步伐了,有点...

我入职阿里后,才知道原来简历这么写

私下里,有不少读者问我:“二哥,如何才能写出一份专业的技术简历呢?我总感觉自己写的简历太烂了,所以投了无数份,都石沉大海了。”说实话,我自己好多年没有写过简历了,但我认识的一个同行,他在阿里,给我说了一些他当年写简历的方法论,我感觉太牛逼了,实在是忍不住,就分享了出来,希望能够帮助到你。 01、简历的本质 作为简历的撰写者,你必须要搞清楚一点,简历的本质是什么,它就是为了来销售你的价值主张的。往深...

外包程序员的幸福生活

今天给你们讲述一个外包程序员的幸福生活。男主是Z哥,不是在外包公司上班的那种,是一名自由职业者,接外包项目自己干。接下来讲的都是真人真事。 先给大家介绍一下男主,Z哥,老程序员,是我十多年前的老同事,技术大牛,当过CTO,也创过业。因为我俩都爱好喝酒、踢球,再加上住的距离不算远,所以一直也断断续续的联系着,我对Z哥的状况也有大概了解。 Z哥几年前创业失败,后来他开始干起了外包,利用自己的技术能...

优雅的替换if-else语句

场景 日常开发,if-else语句写的不少吧??当逻辑分支非常多的时候,if-else套了一层又一层,虽然业务功能倒是实现了,但是看起来是真的很不优雅,尤其是对于我这种有强迫症的程序"猿",看到这么多if-else,脑袋瓜子就嗡嗡的,总想着解锁新姿势:干掉过多的if-else!!!本文将介绍三板斧手段: 优先判断条件,条件不满足的,逻辑及时中断返回; 采用策略模式+工厂模式; 结合注解,锦...

深入剖析Springboot启动原理的底层源码,再也不怕面试官问了!

大家现在应该都对Springboot很熟悉,但是你对他的启动原理了解吗?

离职半年了,老东家又发 offer,回不回?

有小伙伴问松哥这个问题,他在上海某公司,在离职了几个月后,前公司的领导联系到他,希望他能够返聘回去,他很纠结要不要回去? 俗话说好马不吃回头草,但是这个小伙伴既然感到纠结了,我觉得至少说明了两个问题:1.曾经的公司还不错;2.现在的日子也不是很如意。否则应该就不会纠结了。 老实说,松哥之前也有过类似的经历,今天就来和小伙伴们聊聊回头草到底吃不吃。 首先一个基本观点,就是离职了也没必要和老东家弄的苦...

2020阿里全球数学大赛:3万名高手、4道题、2天2夜未交卷

阿里巴巴全球数学竞赛( Alibaba Global Mathematics Competition)由马云发起,由中国科学技术协会、阿里巴巴基金会、阿里巴巴达摩院共同举办。大赛不设报名门槛,全世界爱好数学的人都可参与,不论是否出身数学专业、是否投身数学研究。 2020年阿里巴巴达摩院邀请北京大学、剑桥大学、浙江大学等高校的顶尖数学教师组建了出题组。中科院院士、美国艺术与科学院院士、北京国际数学...

男生更看重女生的身材脸蛋,还是思想?

往往,我们看不进去大段大段的逻辑。深刻的哲理,往往短而精悍,一阵见血。问:产品经理挺漂亮的,有点心动,但不知道合不合得来。男生更看重女生的身材脸蛋,还是...

为什么程序员做外包会被瞧不起?

二哥,有个事想询问下您的意见,您觉得应届生值得去外包吗?公司虽然挺大的,中xx,但待遇感觉挺低,马上要报到,挺纠结的。

当HR压你价,说你只值7K,你该怎么回答?

当HR压你价,说你只值7K时,你可以流畅地回答,记住,是流畅,不能犹豫。 礼貌地说:“7K是吗?了解了。嗯~其实我对贵司的面试官印象很好。只不过,现在我的手头上已经有一份11K的offer。来面试,主要也是自己对贵司挺有兴趣的,所以过来看看……”(未完) 这段话主要是陪HR互诈的同时,从公司兴趣,公司职员印象上,都给予对方正面的肯定,既能提升HR的好感度,又能让谈判气氛融洽,为后面的发挥留足空间。...

面试:第十六章:Java中级开发(16k)

HashMap底层实现原理,红黑树,B+树,B树的结构原理 Spring的AOP和IOC是什么?它们常见的使用场景有哪些?Spring事务,事务的属性,传播行为,数据库隔离级别 Spring和SpringMVC,MyBatis以及SpringBoot的注解分别有哪些?SpringMVC的工作原理,SpringBoot框架的优点,MyBatis框架的优点 SpringCould组件有哪些,他们...

面试阿里p7,被按在地上摩擦,鬼知道我经历了什么?

面试阿里p7被问到的问题(当时我只知道第一个):@Conditional是做什么的?@Conditional多个条件是什么逻辑关系?条件判断在什么时候执...

你期望月薪4万,出门右拐,不送,这几个点,你也就是个初级的水平

先来看几个问题通过注解的方式注入依赖对象,介绍一下你知道的几种方式@Autowired和@Resource有何区别说一下@Autowired查找候选者的...

面试了一个 31 岁程序员,让我有所触动,30岁以上的程序员该何去何从?

最近面试了一个31岁8年经验的程序猿,让我有点感慨,大龄程序猿该何去何从。

大三实习生,字节跳动面经分享,已拿Offer

说实话,自己的算法,我一个不会,太难了吧

程序员垃圾简历长什么样?

已经连续五年参加大厂校招、社招的技术面试工作,简历看的不下于万份 这篇文章会用实例告诉你,什么是差的程序员简历! 疫情快要结束了,各个公司也都开始春招了,作为即将红遍大江南北的新晋UP主,那当然要为小伙伴们做点事(手动狗头)。 就在公众号里公开征简历,义务帮大家看,并一一点评。《启舰:春招在即,义务帮大家看看简历吧》 一石激起千层浪,三天收到两百多封简历。 花光了两个星期的所有空闲时...

《Oracle Java SE编程自学与面试指南》最佳学习路线图2020年最新版(进大厂必备)

正确选择比瞎努力更重要!

《Oracle Java SE编程自学与面试指南》最佳学习路线图(2020最新版)

正确选择比瞎努力更重要!

字节跳动面试官竟然问了我JDBC?

轻松等回家通知

面试官:你连SSO都不懂,就别来面试了

大厂竟然要考我SSO,卧槽。

终于,月薪过5万了!

来看几个问题想不想月薪超过5万?想不想进入公司架构组?想不想成为项目组的负责人?想不想成为spring的高手,超越99%的对手?那么本文内容是你必须要掌握的。本文主要详解bean的生命...

自从喜欢上了B站这12个UP主,我越来越觉得自己是个废柴了!

不怕告诉你,我自从喜欢上了这12个UP主,哔哩哔哩成为了我手机上最耗电的软件,几乎每天都会看,可是吧,看的越多,我就越觉得自己是个废柴,唉,老天不公啊,不信你看看…… 间接性踌躇满志,持续性混吃等死,都是因为你们……但是,自己的学习力在慢慢变强,这是不容忽视的,推荐给你们! 都说B站是个宝,可是有人不会挖啊,没事,今天咱挖好的送你一箩筐,首先啊,我在B站上最喜欢看这个家伙的视频了,为啥 ,咱撇...

立即提问
相关内容推荐