[SQOOP-457] Issue with connecting oracle

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

Environment

Linux

• Assignee: Kathleen Ting
• Reporter: sathish
• Created: 09/Mar/12 00:40
• Updated: 15/Nov/14 01:31
• Resolved: 09/Mar/12 17:31

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

• relates to: SQOOP-461 Sqoop User Guide's troubleshooting section should include Oracle Connection Errors