java.sql.SQLException: oracle.jdbc.driver.OracleSQLException: ORA-00911: invalid character

Oracle Community | KdeGraaf | 8 years ago
  1. 0

    Problem with executing query in a Java Stored Procedure.

    Oracle Community | 8 years ago | KdeGraaf
    java.sql.SQLException: oracle.jdbc.driver.OracleSQLException: ORA-00911: invalid character
  2. 0

    java.sql.SQLException: ORA-00911: invalid character

    Oracle Community | 7 years ago | Ankurbindal-Oracle
    java.sql.SQLException: ORA-00911: invalid character
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Error in html  Page while deleting record.

    Oracle Community | 6 years ago | 805444
    java.sql.SQLException: ORA-00911: invalid character
  5. 0

    When I click on the "Page Poperties" link on the admin menu ,and then edit the properties and submit the form i get the following exception: -The exception is thrown by the method PagePropertyDB.isKeyAlreadyUsedInSiteWithID -This happens only with oracle (Sql Server does not throw this exception). Here is the exception text: Exception StackTrace: Cause level : 0 (level 0 is the most precise exception) java.sql.SQLException: ORA-00911: invalid character at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112) at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:351) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896) at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:383) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1125) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) at org.jahia.services.database.StatementWrapper.executeQuery(StatementWrapper.java:96) at org.jahia.services.pages.PagePropertyDB.isKeyAlreadyUsedInSiteWithID(PagePropertyDB.java:651) at org.jahia.services.pages.JahiaPageBaseService.isKeyAlreadyUsedInSiteWithID(JahiaPageBaseService.java:2118) at org.jahia.engines.pages.PageProperties_Engine.isURLKeyAlreadyUsed(PageProperties_Engine.java:908) at org.jahia.engines.pages.PageProperties_Engine.setPageURLKeyIfValidAndNotEmpty(PageProperties_Engine.java:846) at org.jahia.engines.pages.PageProperties_Engine.updatePageData(PageProperties_Engine.java:772) at org.jahia.engines.pages.PageProperties_Engine.processLastScreen(PageProperties_Engine.java:239) at org.jahia.engines.pages.PageProperties_Engine.handleActions(PageProperties_Engine.java:179) at org.jahia.operations.OperationManager.handleOperations(OperationManager.java:302) at org.jahia.bin.JahiaAction.execute(JahiaAction.java:50) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.jahia.bin.Jahia.process(Jahia.java:1547) at org.jahia.bin.Jahia.service(Jahia.java:862) at javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) Cause level : 1 org.jahia.exceptions.JahiaException: Cannot check for url key uniqueness from the database, Error in PagePropertyDB.isKeyAlreadyUsedInSiteWithID : ORA-00911: invalid character , root cause:ORA-00911: invalid character root cause=java.sql.SQLException: ORA-00911: invalid character at org.jahia.services.pages.PagePropertyDB.isKeyAlreadyUsedInSiteWithID(PagePropertyDB.java:659) at org.jahia.services.pages.JahiaPageBaseService.isKeyAlreadyUsedInSiteWithID(JahiaPageBaseService.java:2118) at org.jahia.engines.pages.PageProperties_Engine.isURLKeyAlreadyUsed(PageProperties_Engine.java:908) at org.jahia.engines.pages.PageProperties_Engine.setPageURLKeyIfValidAndNotEmpty(PageProperties_Engine.java:846) at org.jahia.engines.pages.PageProperties_Engine.updatePageData(PageProperties_Engine.java:772) at org.jahia.engines.pages.PageProperties_Engine.processLastScreen(PageProperties_Engine.java:239) at org.jahia.engines.pages.PageProperties_Engine.handleActions(PageProperties_Engine.java:179) at org.jahia.operations.OperationManager.handleOperations(OperationManager.java:302) at org.jahia.bin.JahiaAction.execute(JahiaAction.java:50) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.jahia.bin.Jahia.process(Jahia.java:1547) at org.jahia.bin.Jahia.service(Jahia.java:862) at javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) Cause level : 2 org.jahia.exceptions.JahiaException: Error during handle of operation, Error during handle of operation, root cause:Cannot check for url key uniqueness from the database, Error in PagePropertyDB.isKeyAlreadyUsedInSiteWithID : ORA-00911: invalid character , root cause:ORA-00911: invalid character root cause=org.jahia.exceptions.JahiaException: Cannot check for url key uniqueness from the database, Error in PagePropertyDB.isKeyAlreadyUsedInSiteWithID : ORA-00911: invalid character , root cause:ORA-00911: invalid character root cause=java.sql.SQLException: ORA-00911: invalid character at org.jahia.operations.OperationManager.handleOperations(OperationManager.java:318) at org.jahia.bin.JahiaAction.execute(JahiaAction.java:50) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.jahia.bin.Jahia.process(Jahia.java:1547) at org.jahia.bin.Jahia.service(Jahia.java:862) at javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534)

    JIRA | 1 decade ago | Madani Benghia
    java.sql.SQLException: ORA-00911: invalid character

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      oracle.jdbc.driver.OracleSQLException: ORA-00911: invalid character

      at ReadEB.read_BankStatement()
    2. Unknown
      ReadEB.read_BankStatement
      1. ReadEB.read_BankStatement(ReadEB.java:84)
      1 frame