title: how to deploy javafx application with sqlite database(preferably using inno script)
body: <p>I want to deploy a javafx fxml application. I have used sqlite3 database. I tried deploying it using inno script by adding .db file, the first login page shows up but after i enter the credentials and Log-in the window just collapses. I think its because of an exception which I have not programmed to display in a pop window. The programs works just fine when i run in netbeans. Please suggest the best way to deploy an fxml application with sqlite database.</p>
  
  <p>The contents of the project :</p>
  
  <ol>
  <li>main project files</li>
  <li>images in a separate folder named images(background image is displayed in login page)  </li>
  <li>database file.</li>
  </ol>
  
  <p><strong>EDIT</strong></p>
  
  <p>I believe the problem was the missing driver. It was not able to connect to the .db file. so I added the following lines to the code where it is connecting to the Database</p>
  
  <pre><code>stmt.executeUpdate("CREATE TABLE IF NOT EXISTS admin_users (ID PRIMARY KEY NOT NULL, USERNAME TEXT UNIQUE NOT NULL,PASSWORD TEXT UNIQUE NOT NULL)");
  </code></pre>
  
  <p>and</p>
  
  <pre><code>stmt.executeUpdate("INSERT INTO admin_users (ID,USERNAME,PASSWORD) SELECT * FROM (SELECT 1,'admin','xxxxx') AS tmp WHERE NOT EXISTS (SELECT USERNAME from admin_users WHERE USERNAME= 'admin') LIMIT 1");
  </code></pre>
  
  <p>Now it is creating a database file where I execute the jar. It is going past the login page and everything works fine. But, when I deploy the project using Inno Script. Same problem persists and the application force closes when I click submit.</p>