Reply
Highlighted
New Contributor
Posts: 3
Registered: ‎03-28-2019

Oracle JDBC connection issue

Hi Team

 

We are trying to connect to Oracle DB in Sqoop using JDBC connector but receving below error. We even tried to set the below property in the sqoop command but not able to resolve the issue. Any solution to this issue is really helpful.

 

sqoop list-tables -Dmapred.child.java.opts="\-Djava.security.egd=file:/dev/../dev/urandom"+ 

 

 

Error:

19/04/03 14:35:18 WARN sqoop.ConnFactory: Parameter --driver is set to an explicit driver however appropriate connection manager is not being set (via --connection-manager). Sqoop is going to fall back to org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which connection manager should be used next time.
19/04/03 14:35:18 INFO manager.SqlManager: Using default fetchSize of 1000
19/04/03 14:35:18 DEBUG manager.SqlManager: No connection paramenters specified. Using regular API for making connection.
19/04/03 14:35:18 ERROR manager.SqlManager: Error reading database metadata: java.sql.SQLRecoverableException: IO Error: Connection reset
java.sql.SQLRecoverableException: IO Error: Connection reset
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:498)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:903)
at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
at org.apache.sqoop.manager.SqlManager.listTables(SqlManager.java:538)
at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)
at org.apache.sqoop.Sqoop.main(Sqoop.java:252)
Caused by: java.net.SocketException: Connection reset

Cloudera Employee
Posts: 39
Registered: ‎01-07-2019

Re: Oracle JDBC connection issue

[ Edited ]

Please try explicitly specifying the --connection-manager in your sqoop command (if you already tried this, please share the full sqoop command).

Also make sure the driver is installed.

Announcements