You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Kathleen Ting (Created) (JIRA)" <ji...@apache.org> on 2012/03/11 08:03:58 UTC
[jira] [Created] (SQOOP-461) Sqoop User Guide's troubleshooting
section should include Oracle Connection Errors
Sqoop User Guide's troubleshooting section should include Oracle Connection Errors
----------------------------------------------------------------------------------
Key: SQOOP-461
URL: https://issues.apache.org/jira/browse/SQOOP-461
Project: Sqoop
Issue Type: Improvement
Components: docs
Affects Versions: 1.4.1-incubating
Reporter: Kathleen Ting
Assignee: Kathleen Ting
While working with Oracle you may encounter the below problem when the Sqoop command explicitly specifies the --driver oracle.jdbc.driver.OracleDriver option. 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 the intended Oracle driver. This is because if the driver option is not specified, the built-in Oracle connection manager will chose the very driver that is being passed in. It would be helpful if this was documented in the troubleshooting section of the Sqoop User Guide.
--
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-461) Sqoop User Guide's troubleshooting
section should include Oracle Connection Errors
Posted by "Kathleen Ting (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-461?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathleen Ting updated SQOOP-461:
--------------------------------
Status: Patch Available (was: Open)
> Sqoop User Guide's troubleshooting section should include Oracle Connection Errors
> ----------------------------------------------------------------------------------
>
> Key: SQOOP-461
> URL: https://issues.apache.org/jira/browse/SQOOP-461
> Project: Sqoop
> Issue Type: Improvement
> Components: docs
> Affects Versions: 1.4.1-incubating
> Reporter: Kathleen Ting
> Assignee: Kathleen Ting
> Attachments: SQOOP-461.patch
>
>
> While working with Oracle you may encounter the below problem when the Sqoop command explicitly specifies the --driver oracle.jdbc.driver.OracleDriver option. 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 the intended Oracle driver. This is because if the driver option is not specified, the built-in Oracle connection manager will chose the very driver that is being passed in. It would be helpful if this was documented in the troubleshooting section of the Sqoop User Guide.
--
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-461) Sqoop User Guide's troubleshooting
section should include Oracle Connection Errors
Posted by "Hudson (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13227794#comment-13227794 ]
Hudson commented on SQOOP-461:
------------------------------
Integrated in Sqoop-ant-jdk-1.6 #96 (See [https://builds.apache.org/job/Sqoop-ant-jdk-1.6/96/])
SQOOP-461. Adding Oracle error to troubleshooting section of user guide.
(Kathleen Ting via Arvind Prabhakar) (Revision 1299784)
Result = SUCCESS
arvind : http://svn.apache.org/viewvc/?view=rev&rev=1299784
Files :
* /incubator/sqoop/trunk/src/docs/user/troubleshooting.txt
> Sqoop User Guide's troubleshooting section should include Oracle Connection Errors
> ----------------------------------------------------------------------------------
>
> Key: SQOOP-461
> URL: https://issues.apache.org/jira/browse/SQOOP-461
> Project: Sqoop
> Issue Type: Improvement
> Components: docs
> Affects Versions: 1.4.1-incubating
> Reporter: Kathleen Ting
> Assignee: Kathleen Ting
> Fix For: 1.4.2-incubating
>
> Attachments: SQOOP-461-1.patch, SQOOP-461.patch
>
>
> While working with Oracle you may encounter the below problem when the Sqoop command explicitly specifies the --driver oracle.jdbc.driver.OracleDriver option. 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 the intended Oracle driver. This is because if the driver option is not specified, the built-in Oracle connection manager will chose the very driver that is being passed in. It would be helpful if this was documented in the troubleshooting section of the Sqoop User Guide.
--
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-461) Sqoop User Guide's troubleshooting
section should include Oracle Connection Errors
Posted by "Kathleen Ting (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-461?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathleen Ting updated SQOOP-461:
--------------------------------
Attachment: SQOOP-461-1.patch
Thanks Arvind for the feedback, which I've incorporated in the attached file SQOOP-461-1.patch.
> Sqoop User Guide's troubleshooting section should include Oracle Connection Errors
> ----------------------------------------------------------------------------------
>
> Key: SQOOP-461
> URL: https://issues.apache.org/jira/browse/SQOOP-461
> Project: Sqoop
> Issue Type: Improvement
> Components: docs
> Affects Versions: 1.4.1-incubating
> Reporter: Kathleen Ting
> Assignee: Kathleen Ting
> Attachments: SQOOP-461-1.patch, SQOOP-461.patch
>
>
> While working with Oracle you may encounter the below problem when the Sqoop command explicitly specifies the --driver oracle.jdbc.driver.OracleDriver option. 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 the intended Oracle driver. This is because if the driver option is not specified, the built-in Oracle connection manager will chose the very driver that is being passed in. It would be helpful if this was documented in the troubleshooting section of the Sqoop User Guide.
--
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-461) Sqoop User Guide's troubleshooting
section should include Oracle Connection Errors
Posted by "Arvind Prabhakar (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-461?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arvind Prabhakar updated SQOOP-461:
-----------------------------------
Resolution: Fixed
Fix Version/s: 1.4.2-incubating
Status: Resolved (was: Patch Available)
Patch committed. Thanks Kathleen!
> Sqoop User Guide's troubleshooting section should include Oracle Connection Errors
> ----------------------------------------------------------------------------------
>
> Key: SQOOP-461
> URL: https://issues.apache.org/jira/browse/SQOOP-461
> Project: Sqoop
> Issue Type: Improvement
> Components: docs
> Affects Versions: 1.4.1-incubating
> Reporter: Kathleen Ting
> Assignee: Kathleen Ting
> Fix For: 1.4.2-incubating
>
> Attachments: SQOOP-461-1.patch, SQOOP-461.patch
>
>
> While working with Oracle you may encounter the below problem when the Sqoop command explicitly specifies the --driver oracle.jdbc.driver.OracleDriver option. 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 the intended Oracle driver. This is because if the driver option is not specified, the built-in Oracle connection manager will chose the very driver that is being passed in. It would be helpful if this was documented in the troubleshooting section of the Sqoop User Guide.
--
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-461) Sqoop User Guide's troubleshooting
section should include Oracle Connection Errors
Posted by "Kathleen Ting (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-461?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathleen Ting updated SQOOP-461:
--------------------------------
Attachment: SQOOP-461.patch
> Sqoop User Guide's troubleshooting section should include Oracle Connection Errors
> ----------------------------------------------------------------------------------
>
> Key: SQOOP-461
> URL: https://issues.apache.org/jira/browse/SQOOP-461
> Project: Sqoop
> Issue Type: Improvement
> Components: docs
> Affects Versions: 1.4.1-incubating
> Reporter: Kathleen Ting
> Assignee: Kathleen Ting
> Attachments: SQOOP-461.patch
>
>
> While working with Oracle you may encounter the below problem when the Sqoop command explicitly specifies the --driver oracle.jdbc.driver.OracleDriver option. 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 the intended Oracle driver. This is because if the driver option is not specified, the built-in Oracle connection manager will chose the very driver that is being passed in. It would be helpful if this was documented in the troubleshooting section of the Sqoop User Guide.
--
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-461) Sqoop User Guide's troubleshooting
section should include Oracle Connection Errors
Posted by "jiraposter@reviews.apache.org (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13227299#comment-13227299 ]
jiraposter@reviews.apache.org commented on SQOOP-461:
-----------------------------------------------------
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/4287/#review5833
-----------------------------------------------------------
Thanks for the patch Kathleen. Changes look good, one minor suggestion below for you to consider:
./src/docs/user/troubleshooting.txt
<https://reviews.apache.org/r/4287/#comment12735>
The error is more of a SQL syntax error instead of a connection error.
I suggest that you modify the title to:
Oracle: ORA-00933 error (SQL command not properly ended)
- Arvind
On 2012-03-11 17:14:43, Kathleen Ting wrote:
bq.
bq. -----------------------------------------------------------
bq. This is an automatically generated e-mail. To reply, visit:
bq. https://reviews.apache.org/r/4287/
bq. -----------------------------------------------------------
bq.
bq. (Updated 2012-03-11 17:14:43)
bq.
bq.
bq. Review request for Sqoop and Arvind Prabhakar.
bq.
bq.
bq. Summary
bq. -------
bq.
bq. Updated Documentation.
bq.
bq.
bq. This addresses bug SQOOP-461.
bq. https://issues.apache.org/jira/browse/SQOOP-461
bq.
bq.
bq. Diffs
bq. -----
bq.
bq. ./src/docs/user/troubleshooting.txt 1299394
bq.
bq. Diff: https://reviews.apache.org/r/4287/diff
bq.
bq.
bq. Testing
bq. -------
bq.
bq. Built docs and verified.
bq.
bq.
bq. Thanks,
bq.
bq. Kathleen
bq.
bq.
> Sqoop User Guide's troubleshooting section should include Oracle Connection Errors
> ----------------------------------------------------------------------------------
>
> Key: SQOOP-461
> URL: https://issues.apache.org/jira/browse/SQOOP-461
> Project: Sqoop
> Issue Type: Improvement
> Components: docs
> Affects Versions: 1.4.1-incubating
> Reporter: Kathleen Ting
> Assignee: Kathleen Ting
> Attachments: SQOOP-461.patch
>
>
> While working with Oracle you may encounter the below problem when the Sqoop command explicitly specifies the --driver oracle.jdbc.driver.OracleDriver option. 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 the intended Oracle driver. This is because if the driver option is not specified, the built-in Oracle connection manager will chose the very driver that is being passed in. It would be helpful if this was documented in the troubleshooting section of the Sqoop User Guide.
--
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-461) Sqoop User Guide's troubleshooting
section should include Oracle Connection Errors
Posted by "jiraposter@reviews.apache.org (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13227098#comment-13227098 ]
jiraposter@reviews.apache.org commented on SQOOP-461:
-----------------------------------------------------
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/4287/
-----------------------------------------------------------
Review request for Sqoop and Arvind Prabhakar.
Summary
-------
Updated Documentation.
This addresses bug SQOOP-461.
https://issues.apache.org/jira/browse/SQOOP-461
Diffs
-----
./src/docs/user/troubleshooting.txt 1299394
Diff: https://reviews.apache.org/r/4287/diff
Testing
-------
Built docs and verified.
Thanks,
Kathleen
> Sqoop User Guide's troubleshooting section should include Oracle Connection Errors
> ----------------------------------------------------------------------------------
>
> Key: SQOOP-461
> URL: https://issues.apache.org/jira/browse/SQOOP-461
> Project: Sqoop
> Issue Type: Improvement
> Components: docs
> Affects Versions: 1.4.1-incubating
> Reporter: Kathleen Ting
> Assignee: Kathleen Ting
>
> While working with Oracle you may encounter the below problem when the Sqoop command explicitly specifies the --driver oracle.jdbc.driver.OracleDriver option. 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 the intended Oracle driver. This is because if the driver option is not specified, the built-in Oracle connection manager will chose the very driver that is being passed in. It would be helpful if this was documented in the troubleshooting section of the Sqoop User Guide.
--
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-461) Sqoop User Guide's troubleshooting
section should include Oracle Connection Errors
Posted by "jiraposter@reviews.apache.org (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13227739#comment-13227739 ]
jiraposter@reviews.apache.org commented on SQOOP-461:
-----------------------------------------------------
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/4287/
-----------------------------------------------------------
(Updated 2012-03-12 18:18:58.435413)
Review request for Sqoop and Arvind Prabhakar.
Changes
-------
Thanks Arvind for your feedback, which I've incorporated.
Summary
-------
Updated Documentation.
This addresses bug SQOOP-461.
https://issues.apache.org/jira/browse/SQOOP-461
Diffs (updated)
-----
./src/docs/user/troubleshooting.txt 1299737
Diff: https://reviews.apache.org/r/4287/diff
Testing
-------
Built docs and verified.
Thanks,
Kathleen
> Sqoop User Guide's troubleshooting section should include Oracle Connection Errors
> ----------------------------------------------------------------------------------
>
> Key: SQOOP-461
> URL: https://issues.apache.org/jira/browse/SQOOP-461
> Project: Sqoop
> Issue Type: Improvement
> Components: docs
> Affects Versions: 1.4.1-incubating
> Reporter: Kathleen Ting
> Assignee: Kathleen Ting
> Attachments: SQOOP-461-1.patch, SQOOP-461.patch
>
>
> While working with Oracle you may encounter the below problem when the Sqoop command explicitly specifies the --driver oracle.jdbc.driver.OracleDriver option. 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 the intended Oracle driver. This is because if the driver option is not specified, the built-in Oracle connection manager will chose the very driver that is being passed in. It would be helpful if this was documented in the troubleshooting section of the Sqoop User Guide.
--
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-461) Sqoop User Guide's troubleshooting
section should include Oracle Connection Errors
Posted by "jiraposter@reviews.apache.org (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13227778#comment-13227778 ]
jiraposter@reviews.apache.org commented on SQOOP-461:
-----------------------------------------------------
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/4287/#review5843
-----------------------------------------------------------
Ship it!
+1
- Arvind
On 2012-03-12 18:18:58, Kathleen Ting wrote:
bq.
bq. -----------------------------------------------------------
bq. This is an automatically generated e-mail. To reply, visit:
bq. https://reviews.apache.org/r/4287/
bq. -----------------------------------------------------------
bq.
bq. (Updated 2012-03-12 18:18:58)
bq.
bq.
bq. Review request for Sqoop and Arvind Prabhakar.
bq.
bq.
bq. Summary
bq. -------
bq.
bq. Updated Documentation.
bq.
bq.
bq. This addresses bug SQOOP-461.
bq. https://issues.apache.org/jira/browse/SQOOP-461
bq.
bq.
bq. Diffs
bq. -----
bq.
bq. ./src/docs/user/troubleshooting.txt 1299737
bq.
bq. Diff: https://reviews.apache.org/r/4287/diff
bq.
bq.
bq. Testing
bq. -------
bq.
bq. Built docs and verified.
bq.
bq.
bq. Thanks,
bq.
bq. Kathleen
bq.
bq.
> Sqoop User Guide's troubleshooting section should include Oracle Connection Errors
> ----------------------------------------------------------------------------------
>
> Key: SQOOP-461
> URL: https://issues.apache.org/jira/browse/SQOOP-461
> Project: Sqoop
> Issue Type: Improvement
> Components: docs
> Affects Versions: 1.4.1-incubating
> Reporter: Kathleen Ting
> Assignee: Kathleen Ting
> Fix For: 1.4.2-incubating
>
> Attachments: SQOOP-461-1.patch, SQOOP-461.patch
>
>
> While working with Oracle you may encounter the below problem when the Sqoop command explicitly specifies the --driver oracle.jdbc.driver.OracleDriver option. 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 the intended Oracle driver. This is because if the driver option is not specified, the built-in Oracle connection manager will chose the very driver that is being passed in. It would be helpful if this was documented in the troubleshooting section of the Sqoop User Guide.
--
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