[
https://issues.apache.org/jira/browse/SQOOP-1373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gwen Shapira resolved SQOOP-1373.
---------------------------------
Resolution: Cannot Reproduce
Assignee: Gwen Shapira
> Sqoop import schema is locked shows NullPointerException
> --------------------------------------------------------
>
> Key: SQOOP-1373
> URL: https://issues.apache.org/jira/browse/SQOOP-1373
> Project: Sqoop
> Issue Type: Improvement
> Components: connectors/oracle, connectors/sqlserver
> Affects Versions: 1.4.4
> Environment: This was seen on Sqoop which came with CDH5.0.2.
> Reporter: Ranjana Rajendran
> Assignee: Gwen Shapira
> Priority: Minor
> Fix For: 1.4.5
>
>
> The target Oracle database was locked and we were trying to do
> import-all-tables and import table from that database. We get a
> NullPointerException instead of 'database is locked'.
> {code}
> > sqoop import-all-tables --connect jdbc:oracle:thin:@cor:1521/database name
> > --username xxxxx -P --verbose -m 1
> {code}
> {code}
> Warning:
> /opt/cloudera/parcels/CDH-5.0.2-1.cdh5.0.2.p0.13/bin/../lib/sqoop/../accumulo
> does not exist! Accumulo imports will fail.
> Please set $ACCUMULO_HOME to the root of your Accumulo installation.
> 14/07/10 12:47:03 INFO sqoop.Sqoop: Running Sqoop version: 1.4.4-cdh5.0.2
> 14/07/10 12:47:03 DEBUG tool.BaseSqoopTool: Enabled debug logging.
> Enter password:
> 14/07/10 12:47:07 DEBUG sqoop.ConnFactory: Loaded manager factory:
> com.cloudera.sqoop.manager.DefaultManagerFactory
> 14/07/10 12:47:07 DEBUG sqoop.ConnFactory: Trying ManagerFactory:
> com.cloudera.sqoop.manager.DefaultManagerFactory
> 14/07/10 12:47:07 DEBUG manager.DefaultManagerFactory: Trying with scheme:
> jdbc:oracle:thin:@cor
> 14/07/10 12:47:07 DEBUG manager.OracleManager$ConnCache: Instantiated new
> connection cache.
> 14/07/10 12:47:07 INFO manager.SqlManager: Using default fetchSize of 1000
> 14/07/10 12:47:07 DEBUG sqoop.ConnFactory: Instantiated ConnManager
> org.apache.sqoop.manager.OracleManager@5560c7a8
> 14/07/10 12:47:07 DEBUG manager.OracleManager: Creating a new connection for
> jdbc:oracle:thin:@cor:1521/pitaqa.accidentfund.com, using username:
> underwriting
> 14/07/10 12:47:07 DEBUG manager.OracleManager: No connection paramenters
> specified. Using regular API for making connection.
> 14/07/10 12:47:08 ERROR sqoop.Sqoop: Got exception running Sqoop:
> java.lang.NullPointerException
> java.lang.NullPointerException
> at
> org.apache.sqoop.manager.OracleManager.listTables(OracleManager.java:751)
> at
> org.apache.sqoop.tool.ImportAllTablesTool.run(ImportAllTablesTool.java:95)
> 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:222)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:231)
> at org.apache.sqoop.Sqoop.main(Sqoop.java:240)
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
