Teh Kok How

The double-quote doesn't work with MySQL! " So if you use quoted identifiers (even quoted with backtick) in Mys compatibility mode, it will solve the issue." Are you sure!?!

The double-quote doesn't work with MySQL! " So if you use quoted identifiers (even quoted with backtick) in Mys compatibility mode, it will solve the issue." Are you sure? Have you tried it yourself!?!

The double-quote doesn't work with MySQL. " So if you use quoted identifiers (even quoted with backtick) in Mys compatibility mode, it will solve the issue." Are you sure? Have you tried it yourself?

Firstly, regarding the JsonObject, this is my code: List<Author> authors = result.result().getRows().stream().map(Author::new).collect(Collectors.toList()); And in Author class: public Author(JsonObject json) { id = json.getLong("id"); first_name = json.getString("first_name"); last_name = json.getString("last_name"); email = json.getString("email"); phone = json.getString("phone"); } If I don't quote the column names, the json.getString() will throw exception because the property keys are all capitalized...

No, I am talking about constructing query string and deserialize from JsonObject. In the first case, I have to double-quote the column names and second case unless I double-quote, all the JsonObject properties are capitalized. This is terrible for code testing with in-mermory DB when production is using MySQL! I have to springkle code to check if it is HSQDB to build the query string by double-quoting the column names! https://stackoverflow.com/questions/62727569/hsqldb-mysql-compatibility-is-ru...

Hello! How to deserialize the sql query result set to POJO class even after using sql.syntax_mys=true? https://stackoverflow.com/questions/62711738/java-common-jdbc-sql-query-strategy-for-unit-test-using-hsqldb-and-runtime-using/62713305#62713305

Hi, I am creating a docker container of BlazeGraph. I need to initialize the fresh instance with a new namespace. Where is the configuration file stored and what's the format of the config file? Any sample? Thanks!