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

sqoop-user | Tony Burton | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Can't import or eval from Oracle database

    sqoop-user | 2 years ago | Tony Burton
    java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
  2. 0

    Apache Hadoop user mailing list

    gmane.org | 1 year ago
    java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
  3. 0

    Re: sqoop export query error out..

    sqoop-user | 2 years ago | Abraham Elmahrek
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ODI-1227: Task SrcSet0 (Loading) fails on the source ORACLE connection

    Oracle Community | 4 years ago | 988501
    java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
  6. 0

    Spring Boot with Spring Data JPA gives invalid character issue for findOne(…) on Oracle database

    Stack Overflow | 2 years ago | Rohit
    org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

  1. osvzs 27 times, last 3 weeks ago
  2. tomthomas 20 times, last 1 month ago
  3. rp 1 times, last 4 months ago
  4. jpvee 2 times, last 4 months ago
  5. Nikolay Rybak 2 times, last 4 months ago
5 more registered users
30 unregistered visitors
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.SQLSyntaxErrorException

    ORA-00911: invalid character

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
    13 frames
  3. org.apache.sqoop
    Sqoop.run
    1. org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:750)
    2. org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:759)
    3. org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:269)
    4. org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240)
    5. org.apache.sqoop.manager.SqlManager.getColumnTypesForQuery(SqlManager.java:233)
    6. org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:304)
    7. org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1773)
    8. org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1578)
    9. org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96)
    10. org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478)
    11. org.apache.sqoop.tool.ImportTool.run(ImportTool.java:601)
    12. org.apache.sqoop.Sqoop.run(Sqoop.java:143)
    12 frames
  4. Hadoop
    ToolRunner.run
    1. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
    1 frame
  5. org.apache.sqoop
    Sqoop.main
    1. org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
    2. org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
    3. org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
    4. org.apache.sqoop.Sqoop.main(Sqoop.java:236)
    4 frames