Details

    • Type: Task Task
    • Status: Closed
    • Priority: Trivial Trivial
    • Resolution: Fixed
    • Affects Version/s: 1.4.1-incubating
    • Fix Version/s: no-release
    • Component/s: connectors/oracle
    • Labels:
      None
    • Environment:

      Linux

      Description

      While trying to connect using the Oracle JDBC URL getting errors

      sqoop import --connect jdbc:oracle:thin:@myhose:myport/SID --username scott --password tiger --driver oracle.jdbc.driver.OracleDriver --table=TEST_SQOOP

      INFO manager.SqlManager: Using default fetchSize of 1000
      12/03/08 15:51:14 INFO tool.CodeGenTool: Beginning code generation
      12/03/08 15:51:15 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM TEST_SQOOP AS t WHERE 1=0
      12/03/08 15:51:15 ERROR manager.SqlManager: Error executing statement: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

      java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

      I read and understood this issue is fixed via SQOOP 317 but still it doesnt work for me. This table test_scoop is created in the default user schema.

      Please help

      sqoop version
      Sqoop 1.4.1-incubating
      git commit id
      Compiled by jarcec on Tue Feb 7 20:46:19 CET 2012

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Kathleen Ting
              Reporter:
              sathish
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development