[
https://issues.apache.org/jira/browse/SQOOP-457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
sathish resolved SQOOP-457.
---------------------------
Resolution: Fixed
Thanks kathleen. This fixed the issue.
sqoop import --connect jdbc:oracle:thin:@host:port/SID --username user
--password pass --table EXAMPLE.TESTING_SQOOP
As you mentioned the issue is by specifying the driver.
> 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
