You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "sam liu (JIRA)" <ji...@apache.org> on 2013/11/21 08:11:35 UTC
[jira] [Commented] (SQOOP-1241) 'SQLException: Parameter not set'
exception occurs when run 'sqoop job --list' command
[ https://issues.apache.org/jira/browse/SQOOP-1241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13828561#comment-13828561 ]
sam liu commented on SQOOP-1241:
--------------------------------
The exception info:
13/11/20 22:58:44 INFO persist.Logger: Checkpoint start
13/11/20 22:58:47 INFO persist.Logger: Checkpoint end
13/11/20 22:58:47 ERROR tool.JobTool: I/O error performing job operation: java.io.IOException: Exception creating SQL connection
at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:216)
at org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112)
at org.apache.sqoop.tool.JobTool.run(JobTool.java:274)
at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57)
Caused by: java.sql.SQLException: Parameter not set
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.checkParametersSet(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.setRootProperty(HsqldbJobStorage.java:618)
at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.createRootTable(HsqldbJobStorage.java:531)
at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:185)
... 9 more
Caused by: org.hsqldb.HsqlException: Parameter not set
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
... 16 more
> 'SQLException: Parameter not set' exception occurs when run 'sqoop job --list' command
> --------------------------------------------------------------------------------------
>
> Key: SQOOP-1241
> URL: https://issues.apache.org/jira/browse/SQOOP-1241
> Project: Sqoop
> Issue Type: Bug
> Components: metastore
> Affects Versions: 1.4.3
> Environment: RHEL 5.4, Sqoop-1.4.3, Hadoop-2.0.4-alpha
> Reporter: sam liu
> Assignee: sam liu
> Priority: Blocker
>
> Sqoop-1.4.3 depends on hsqldb-1.8.0.10.jar and store it in its lib folder. For upgrading hsqldb to a higher version, I replaced lib/hsqldb-1.8.0.10.jar with lib/hsqldb-2.0.0.jar. And then, I failed to run command 'sqoop job --list' and encountered SQLException.
--
This message was sent by Atlassian JIRA
(v6.1#6144)