Java SQLite Delete [duplicate]

Question

I'm trying to delete an entry from a SQLite database with java, the code I'm using is this:

      public static void main( String args[] )
  {
    Connection c = null;
    Statement stmt = null;
    try {
      Class.forName("org.sqlite.JDBC");
      c = DriverManager.getConnection("jdbc:sqlite:students.db");
      c.setAutoCommit(false);

      stmt = c.createStatement();
      String sql = "DELETE FROM Grade12 WHERE Name = james";
      stmt.executeUpdate(sql);
      c.commit();
      stmt.close();
      c.close();
    } catch ( Exception e ) {
      System.err.println( e.getClass().getName() + ": " + e.getMessage() );
      System.exit(0);
    }
  }

But I keep getting the error java.sql.SQLException: no such column: james

Anyone know how to fix this?

You might want to try your SQL statement in your database first. Some databases also help you creating those queries. Then you use the statement which worked, and you are fine. — PKlumpp
– PKlumpp, Commented Sep 8, 2014 at 11:25

Dávid Horváth · Accepted Answer · 2014-09-08 11:24:32Z

3

Try with qoutes:

String sql = "DELETE FROM Grade12 WHERE Name = 'james'";

answered Sep 8, 2014 at 11:24

Dávid Horváth

4,3901 gold badge26 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kensen john · Accepted Answer · 2014-09-08 11:24:43Z

3

Please enclose james in quotes and try it out.

String sql = "DELETE FROM Grade12 WHERE Name = 'james'";

answered Sep 8, 2014 at 11:24

kensen john

5,5195 gold badges31 silver badges36 bronze badges

Comments

Deb · Accepted Answer · 2014-09-08 11:25:06Z

2

Try

String sql = "DELETE FROM Grade12 WHERE Name = 'james'"

instead of

String sql = "DELETE FROM Grade12 WHERE Name = james"

answered Sep 8, 2014 at 11:25

Deb

2,9721 gold badge19 silver badges33 bronze badges

1 Comment

Deb Over a year ago

@theThird Please try your query on database first to make sure that the query you are using is right. Sometime it's gets frustrating for no reason. :)

Collectives™ on Stack Overflow

Java SQLite Delete [duplicate]

3 Answers 3

Comments

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Linked

Related