java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax near '= 13.05' at line 1at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)

Oracle Community | 807549 | 1 decade ago
  1. 0

    SELECT statement ???

    Oracle Community | 1 decade ago | 807549
    java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax near '= 13.05' at line 1at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
  2. 0

    MySQL Lists: mysql: JDBC and dates

    mysql.com | 8 months ago
    java.sql.SQLException: Error during query: Unexpected Exception: java.sql.SQLException message given: Syntax error or access violation: You have an error in your SQL syntax near '1947-06-05'', 'M', '391-82-1573', ''2000-04-16'', ''2000-04-16'', ''2000-04-16''' at line 1
  3. 0

    JSP, MySQL and Strings

    Oracle Community | 1 decade ago | 843835
    java.sql.SQLException: Column not found: Unknown column 'villa' in 'where clause'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    mm.mysql JDBC Driver and the WHERE clause

    Oracle Community | 1 decade ago | 843854
    java.sql.SQLException: Column not found: Unknown column 'available' in 'where clause'
  6. 0

    Deadlock found...

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: null: Deadlock found when trying to get lock; Try restarting transaction

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Syntax error or access violation: You have an error in your SQL syntax near '= 13.05' at line 1at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)

      at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect()
    2. MySQL jdbc
      Statement.executeQuery
      1. org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)
      2. org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
      3. org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
      4. org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
      5. org.gjt.mm.mysql.Statement.executeQuery(Unknown Source)
      5 frames
    3. org.gjt.mm
      Statement.executeQuery
      1. org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Unknown Source)
      1 frame
    4. testClasses
      DBConnection.main
      1. testClasses.DBConnection.main(DBConnection.java:144)
      1 frame