exception.DBException: SQL-exception in zoekKlant - statementcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from klant where naam = '2' and voornaam = 'test' and geboortedatum = '1998-08-1' at line 1

Stack Overflow | user3227070 | 4 months ago
  1. 0

    Java sql errors with preparedstatement

    Stack Overflow | 4 months ago | user3227070
    exception.DBException: SQL-exception in zoekKlant - statementcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from klant where naam = '2' and voornaam = 'test' and geboortedatum = '1998-08-1' at line 1

    Root Cause Analysis

    1. exception.DBException

      SQL-exception in zoekKlant - statementcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from klant where naam = '2' and voornaam = 'test' and geboortedatum = '1998-08-1' at line 1

      at database.KlantDB.zoekKlant()
    2. database
      KlantDB.zoekKlant
      1. database.KlantDB.zoekKlant(KlantDB.java:116)
      1 frame
    3. Main
      ApplicationTest.testKlantVerwijderen
      1. Main.Application.klantVerwijderen(Application.java:79)
      2. Main.ApplicationTest.testKlantVerwijderen(ApplicationTest.java:101)
      2 frames