sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sathish (Created) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-457) Issue with connecting oracle
Date Fri, 09 Mar 2012 00:41:57 GMT
Issue with connecting oracle

                 Key: SQOOP-457
                 URL: https://issues.apache.org/jira/browse/SQOOP-457
             Project: Sqoop
          Issue Type: Bug
          Components: connectors/oracle
    Affects Versions: 1.4.1-incubating
         Environment: Linux
            Reporter: sathish

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

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message