title: What is a best way to give connection string for derby database?
body: <p>I am trying to connect derby database and inserting some value to the table.for that i use the bellow code.</p>
  
  <pre><code>Class.forName("org.apache.derby.jdbc.ClientDriver");
  Connection con=DriverManager.getConnection(
          "jdbc:derby://localhost:1527/raptor;create=true","root","root");
  if (con != null) {
      System.out.println("Connected to database - mydb");
  }
  Statement st=con.createStatement();
  String q="insert into VINOTH values(7)";
  
  st.executeUpdate(q);
  </code></pre>
  
  <p>In the above code when calling <code>getConnection</code> method I give database user "root" and password as "root", but it gives me the error</p>
  
  <blockquote>
    <p>Schema 'ROOT' does not exist</p>
  </blockquote>
  
  <p>Actually root was a database user but it takes as a schema. Why is this happening?</p>
  
  <p>If I give "APP" instead of database user "root" it is working fine. But I need to know why it doesn't take my user and password.</p>