From 04fb799d9836a61c47a08f1126d747c86f8b9d4e Mon Sep 17 00:00:00 2001 From: Marco Zanon Date: Sun, 11 Nov 2018 13:28:42 +0000 Subject: [PATCH] Forced TRADITIONAL mode to database connections. --- .../marcozanon/macaco/database/MDatabaseConnection.java | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/src/java/com/marcozanon/macaco/database/MDatabaseConnection.java b/src/java/com/marcozanon/macaco/database/MDatabaseConnection.java index c8f102a..9e5e2c2 100644 --- a/src/java/com/marcozanon/macaco/database/MDatabaseConnection.java +++ b/src/java/com/marcozanon/macaco/database/MDatabaseConnection.java @@ -84,13 +84,13 @@ public class MDatabaseConnection extends MObject { catch (SQLException exception) { throw new MDatabaseConnectionFailureException("Could not get database connection.", exception); } - // Set SQL mode to standard ANSI. + // Set SQL mode to standard ANSI and TRADITIONAL. try { - this.getConnection().createStatement().executeUpdate("SET SQL_MODE='ANSI'"); - this.logStatement("### SET SQL_MODE='ANSI' ###"); + this.getConnection().createStatement().executeUpdate("SET SQL_MODE='ANSI,TRADITIONAL'"); + this.logStatement("### SET SQL_MODE='ANSI,TRADITIONAL' ###"); } catch (SQLException exception) { - throw new MDatabaseConnectionFailureException("Could not set SQL mode to ANSI.", exception); + throw new MDatabaseConnectionFailureException("Could not set SQL mode to ANSI and TRADITIONAL.", exception); } } -- 2.30.2