java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

incubator-sqoop-user | bejoy ks | 6 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

    Re: Fw: Fw: [sqoop-user] sqoop import shows ORA-00933: SQL command notproperlyended error

    incubator-sqoop-user | 6 years ago | bejoy ks
    java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
  2. 0

    Re: Fw: Fw: [sqoop-user] sqoop import shows ORA-00933: SQL command notproperlyended error

    incubator-sqoop-user | 6 years ago | bejoy ks
    java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
  3. 0

    Fw: [sqoop-user] sqoop import shows ORA-00933: SQL command not properlyended error

    incubator-sqoop-user | 6 years ago | bejoyks@gmail.com
    java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: Fw: Fw: [sqoop-user] sqoop import shows ORA-00933: SQL command notproperlyended error

    incubator-sqoop-user | 6 years ago | Reju R
    java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
  6. 0

    JPA EclipseLink oracle db missing right parenthesis

    Stack Overflow | 3 years ago | Dave
    java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

  1. tomthomas 10 times, last 3 weeks ago
  2. rp 1 times, last 2 months ago
  3. jpvee 2 times, last 2 months ago
  4. Nikolay Rybak 2 times, last 2 months ago
  5. rafafviola 1 times, last 3 months ago
4 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-00907: missing right parenthesis

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    13 frames
  3. com.cloudera.sqoop
    Sqoop.run
    1. com.cloudera.sqoop.manager.SqlManager.execute(SqlManager.java:442)
    2. com.cloudera.sqoop.manager.SqlManager.getColumnNamesForRawQuery(SqlManager.java:112)
    3. com.cloudera.sqoop.manager.SqlManager.getColumnNamesForQuery(SqlManager.java:103)
    4. com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:927)
    5. com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
    6. com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:337)
    7. com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
    8. com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
    8 frames
  4. Hadoop
    ToolRunner.run
    1. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
    2. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79)
    2 frames
  5. com.cloudera.sqoop
    Sqoop.main
    1. com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
    2. com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:218)
    3. com.cloudera.sqoop.Sqoop.main(Sqoop.java:228)
    3 frames