Java Error Chapter One

Tag: java.sql.sqlsyntaxerrorexception:ora-00911: Invalid character exception

java.sql.sqlsyntaxerrorexception: ora-00911:  Invalid character at oracle.jdbc.driver.t4cttioer.processerror ( t4cttioer.java:439) At oracle.jdbc.driver.t4cttioer.processerror (t4cttioer.java:395) at  Oracle.jdbc.driver.T4C8Oall.processError (t4c8oall.java:802) at oracle.jdbc.driver.t4cttifun.receive ( t4cttifun.java:436) At oracle.jdbc.driver.t4cttifun.dorpc (t4cttifun.java:186) at  Oracle.jdbc.driver.T4C8Oall.doOALL (t4c8oall.java:521) At oracle.jdbc.driver.t4cpreparedstatement.dooall8 ( t4cpreparedstatement.java:205) At oracle.jdbc.driver.t4cpreparedstatement.executefordescribe ( t4cpreparedstatement.java:861) At oracle.jdbc.driver.oraclestatement.executemaybedescribe ( oraclestatement.java:1145) At oracle.jdbc.driver.oraclestatement.doexecutewithtimeout (OracleStatement.java : 1267) at oracle.jdbc.driver.oraclepreparedstatement.executeinternal (oraclepreparedstatement.java:3449) at  oracle.jdbc.driver.oraclepreparedstatement.executequery (Oraclepreparedstatement.java:3493) At oracle.jdbc.driver.oraclepreparedstatementwrapper.executequery ( oraclepreparedstatementwrapper.java:1491) At com.itxt.blog.dao.basedao.runselectsql (BaseDAO.java:47) at  com.itxt.blog.dao.weibodao.queryallwbs (weibodao.java:22) At com.itxt.blog.action.useraction.execute ( useraction.java:56) 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.xwork2.DefaultActionInvocation.invokeAction (defaultactioninvocation.java:452) at  Com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly (defaultactioninvocation.java:291) at  Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:254) at  Com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.Dointercept (defaultworkflowinterceptor.java:176) at  Com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept (methodfilterinterceptor.java:98) at  Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:248) at  Com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept (validationinterceptor.java:263) at  Org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept ( annotationvalidationinterceptor.java:68) at  Com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept (methodfilterinterceptor.java:98) at  Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:248) at  Com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept (conversionerrorinterceptor.java:133) At com.opensymphony.xwork2.defaultactioninvocation.invoke (defaultactioninvocation.java:248) at  Com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept (parametersinterceptor.java:207) At com.opensymphony.xwork2.interceptor.methodfilterinterceptor.intercept ( methodfilterinterceptor.java:98) At com.opensymphony.xwork2.defaultactioninvocation.invoke ( defaultactioninvocation.java:248) at com.opensymphony.xwork2.interceptor.parametersinterceptor.dointercept (parametersinterceptor.java:207) At com.opensymphony.xwork2.interceptor.methodfilterinterceptor.intercept ( methodfilterinterceptor.java:98) At com.opensymphony.xwork2.defaultactioninvocation.invoke ( defaultactioninvocation.java:248) at  Com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept (staticparametersinterceptor.java:190 ) At com.opensymphony.xwork2.defaultactioninvocation.invoke (defaultactioninvocation.java:248) at  Org.apache.struts2.interceptor.MultiselectInterceptor.intercept (multiselectinterceptor.java:75) at  Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:248) at  Org.apache.struts2.interceptor.CheCkboxinterceptor.intercept (checkboxinterceptor.java:94) at  Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:248) at  Org.apache.struts2.interceptor.FileUploadInterceptor.intercept (fileuploadinterceptor.java:243) at  Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:248) at  Com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept (modeldriveninterceptor.java:100) at  Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:248) at  Com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept (Scopedmodeldriveninterceptor.java : 141) At com.opensymphony.xwork2.defaultactioninvocation.invoke (defaultactioninvocation.java:248) at  Org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept (debugginginterceptor.java:267) at  Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:248) at  Com.opensymphonY.xwork2.interceptor.chaininginterceptor.intercept (chaininginterceptor.java:142) at  Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:248) at  Com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept (prepareinterceptor.java:166) at  Com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept (methodfilterinterceptor.java:98) at  Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:248) at  Com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept (i18ninterceptor.java:176) at  Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:248) at  Org.apache.struts2.interceptor.ServletConfigInterceptor.intercept (servletconfiginterceptor.java:164) at  Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:248) at  Com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept (aliasinterceptor.java:190) at  Com.opensymphonY.xwork2.defaultactioninvocation.invoke (defaultactioninvocation.java:248) at  Com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept (exceptionmappinginterceptor.java:187 ) At com.opensymphony.xwork2.defaultactioninvocation.invoke (defaultactioninvocation.java:248) at  Org.apache.struts2.impl.StrutsActionProxy.execute (strutsactionproxy.java:52) at  Org.apache.struts2.dispatcher.Dispatcher.serviceAction (dispatcher.java:485) at  Org.apache.struts2.dispatcher.FilterDispatcher.doFilter (filterdispatcher.java:395) at  Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:241) at  Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:208) at  Org.apache.catalina.core.StandardWrapperValve.invoke (standardwrappervalve.java:220) at  Org.apache.catalina.core.StandardContextValve.invoke (standardcontextvalve.java:122) at  Org.apache.catalina.authenticator.AuthenticatorBase.invoke (Authenticatorbase.java:503) At org.apache.catalina.core.standardhostvalve.invoke (StandardHostValve.java:170) at  org.apache.catalina.valves.errorreportvalve.invoke (errorreportvalve.java:103) at  Org.apache.catalina.valves.AccessLogValve.invoke (accesslogvalve.java:950) at  Org.apache.catalina.core.StandardEngineValve.invoke (standardenginevalve.java:116) at  Org.apache.catalina.connector.CoyoteAdapter.service (coyoteadapter.java:421) at  Org.apache.coyote.http11.AbstractHttp11Processor.process (abstracthttp11processor.java:1070) at  Org.apache.coyote.abstractprotocol$abstractconnectionhandler.process (abstractprotocol.java:611) at  Org.apache.tomcat.util.net.jioendpoint$socketprocessor.run (jioendpoint.java:316) at  Java.util.concurrent.threadpoolexecutor$worker.runtask (threadpoolexecutor.java:886) at  Java.util.concurrent.threadpoolexecutor$worker.run (threadpoolexecutor.java:908) at  Org.apache.tomcat.util.threads.taskthread$wrappingrunnable.run (Taskthread.java: At java.lang.thread.run (thread.java:619) 

Novice many cases will appear this exception error, when encountered, please check your SQL statement, it is likely to be a grammatical error

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6F/F0/wKiom1Wt4F7x9DOEAABB02hwbjo827.jpg "title=" 1.png " alt= "Wkiom1wt4f7x9doeaabb02hwbjo827.jpg"/>

Like the above, remove the semicolon inside the quotation marks.

This article from "9374701" blog, declined reprint!

Java Error Chapter One