how can i set sql-mode through a conf file

[panqizhen]

Question

I am using shardingsphere-proxy with php and I need to set mysql sql-mode. now i can only set sql-mode after start shardingsphere-proxy, but it will be invalid after restart. I did not find any method in the docs and i can not understand the source code. How can i set sql-mode durable

For English only, other languages will not accept.

Before asking a question, make sure you have:

• Googled your question.
• Searched open and closed GitHub issues.
• Read documentation: ShardingSphere Doc.

Please pay attention on issues you submitted, because we maybe need more details. If no response anymore and we cannot reproduce it on current information, we will close it.

[terrymanu]

Just set it in your database

[panqizhen]

Just set it in your database

But i can not remove STRICT_TRANS_TABLES

[panqizhen]

Just set it in your database

hwo can i change this sql_mode and remove "STRICT_TRANS_TABLES"

[TeslaCN]

Try setting jdbcCompliantTruncation=false in JDBC URL.

Such as

jdbc:mysql://127.0.0.1:3306/ds?jdbcCompliantTruncation=false

[panqizhen]

Try setting jdbcCompliantTruncation=false in JDBC URL.

Such as

jdbc:mysql://127.0.0.1:3306/ds?jdbcCompliantTruncation=false

Thank you very much! It works