You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "sathish (Created) (JIRA)" <ji...@apache.org> on 2012/03/09 01:41:57 UTC
[jira] [Created] (SQOOP-457) Issue with connecting oracle
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
[jira] [Issue Comment Edited] (SQOOP-457) Issue with connecting
oracle
Posted by "Kathleen Ting (Issue Comment Edited) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13225791#comment-13225791 ]
Kathleen Ting edited comment on SQOOP-457 at 3/9/12 2:25 AM:
-------------------------------------------------------------
@sathish - As it happens, by explicitly specifying the driver oracle.jdbc.driver.OracleDriver, the impact is the opposite of your intent. That is, when the driver option is included in the Sqoop command, the built-in connection manager selection defaults to the generic connection manager, which is not your intended Oracle driver. This is because by default, the built-in Oracle connection manager will chose the very driver you are trying to pass in. As a result, please remove the option "driver oracle.jdbc.driver.OracleDriver" and then re-run your Sqoop command. Once you've verified your command works, please close this JIRA as not a bug. Going forward, for faster response, please post user-related questions to sqoop-user@incubator.apache.org. Thanks.
was (Author: kathleen):
@sathish - As it happens, by explicitly specifying the driver oracle.jdbc.driver.OracleDriver, the impact is the opposite of your intent. That is, when the --driver option is included in the Sqoop command, the built-in connection manager selection defaults to the generic connection manager, which is not your intended Oracle driver. This is because by default, the built-in Oracle connection manager will chose the very driver you are trying to pass in. As a result, please remove the option "--driver oracle.jdbc.driver.OracleDriver" and then re-run your Sqoop command. Once you've verified your command works, please close this JIRA as not a bug. Going forward, for faster response, please post user-related questions to sqoop-user@incubator.apache.org. Thanks.
> 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
[jira] [Closed] (SQOOP-457) Issue with connecting oracle
Posted by "sathish (Closed) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
sathish closed SQOOP-457.
-------------------------
Issue is resolved.
> 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
[jira] [Updated] (SQOOP-457) Issue with connecting oracle
Posted by "Kathleen Ting (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathleen Ting updated SQOOP-457:
--------------------------------
Priority: Trivial (was: Major)
Issue Type: Task (was: Bug)
> Issue with connecting oracle
> ----------------------------
>
> Key: SQOOP-457
> URL: https://issues.apache.org/jira/browse/SQOOP-457
> Project: Sqoop
> Issue Type: Task
> Components: connectors/oracle
> Affects Versions: 1.4.1-incubating
> Environment: Linux
> Reporter: sathish
> Assignee: Kathleen Ting
> Priority: Trivial
>
> 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
[jira] [Commented] (SQOOP-457) Issue with connecting oracle
Posted by "Kathleen Ting (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13226319#comment-13226319 ]
Kathleen Ting commented on SQOOP-457:
-------------------------------------
@sathish - Since this is not a bug, please reopen the JIRA and update the resolution to "not-a-bug" for tracking purposes. Thanks.
> 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
[jira] [Assigned] (SQOOP-457) Issue with connecting oracle
Posted by "Kathleen Ting (Assigned) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathleen Ting reassigned SQOOP-457:
-----------------------------------
Assignee: Kathleen Ting
> 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
> Assignee: Kathleen Ting
>
> 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
[jira] [Commented] (SQOOP-457) Issue with connecting oracle
Posted by "Kathleen Ting (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13225791#comment-13225791 ]
Kathleen Ting commented on SQOOP-457:
-------------------------------------
@sathish - As it happens, by explicitly specifying the driver oracle.jdbc.driver.OracleDriver, the impact is the opposite of your intent. That is, when the --driver option is included in the Sqoop command, the built-in connection manager selection defaults to the generic connection manager, which is not your intended Oracle driver. This is because by default, the built-in Oracle connection manager will chose the very driver you are trying to pass in. As a result, please remove the option "--driver oracle.jdbc.driver.OracleDriver" and then re-run your Sqoop command. Once you've verified your command works, please close this JIRA as not a bug. Going forward, for faster response, please post user-related questions to sqoop-user@incubator.apache.org. Thanks.
> 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
[jira] [Resolved] (SQOOP-457) Issue with connecting oracle
Posted by "sathish (Resolved) (JIRA)" <ji...@apache.org>.
[ 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