Caused by: java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile
<p>I have replaced sqoop metatsore with a MySQL db.</p>

<p>When I try to run a saved sqoop job from the command line, it "asks" me for the password and run the job when I supply it.</p>

<p>However, I need to run this job through oozie.</p>

<p>--password is not recognized as a valid argument here in command line while executing sqoop saved job and anyway, it keeps asking for password through the prompt.</p>

<p>Now, when I try to run it through oozie,</p>

<p>I get</p>

<pre><code>Caused by: java.sql.SQLException: The database is already in use by 

another process: org.hsqldb.persist.NIOLockFile@950abfc6[file 

=/home/yarn/.sqoop/metastore.db.lck, exists=false, locked=false, 

 valid=false, fl =null]: java.io.FileNotFoundException: 

/home/yarn/.sqoop/metastore.db.lck (No such file or directory)
</code></pre>

<p>What is this and why is this? I am directly connecting to my MySQL metatsore and have configured sqoop-site.xml accordingly.</p>

<p>Why is this trying to to connect to hsqldb?</p>

<p>Why is it locked?</p>

<p>How do I fix this?</p>

<p>Also, how do I supply password for execution of sqoop job in oozie?</p>