Support Questions
Find answers, ask questions, and share your expertise

Issue with oracle JDBC url showing up as warning in sqoop.log file.

Issue with oracle JDBC url showing up as warning in sqoop.log file.

New Contributor

Hi, We are trying to connect to oralce exadata using sqoop and load data into S3. We are good with loading data to S3 through sqoop but the problem is sqoop.log showing up connect string JDBC URL as warning and exposing pwd in log file. Here is the JDBC connect string url which we are using to connect to oracle exadata. Is there any way i can restrict connect string URL showing up in log files? This connect string showing up in both sqoop.log and syslog. JDBC connect string: jdbc:oracle:thin:AP_AP_ABC/*********@8.10.**.**.**:1521/orcl Here is the warning message: ************************************************** *** Using Data Connector for Oracle and Hadoop *** ************************************************** 2018-03-23 20:00:16,626 INFO org.apache.sqoop.manager.oracle.OraOopManagerFactory (main): Oracle Database version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production 2018-03-23 20:00:16,629 INFO org.apache.sqoop.manager.oracle.OraOopManagerFactory (main): This Oracle database is not a RAC. 2018-03-23 20:00:16,630 INFO org.apache.sqoop.manager.oracle.OraOopManagerFactory (main): Unable to parse the JDBC connection URL "jdbc:oracle:thin:AP_AP_ABC/*********@8.10.**.**.**:1521/orcl" as a connection that uses the Oracle 'thin' JDBC driver.

1 REPLY 1

Re: Issue with oracle JDBC url showing up as warning in sqoop.log file.

Mentor

@Srini M

Check my thread in HCC you can use a password file ONLY readable to the user. See Sqoop password encryption