MySQL Forums
Forum List  »  Connector/J, JDBC and Java

Advanced Search
New Topic

Re: Urgent J Connector URL Syntax for MySQL ignore-spaces Option
Posted by: Filipe Silva
Date: July 29, 2014 05:38AM

In your case, "IGNORE_SPACE" will replace any value previously set in the MySQL configuration file. But that's not all. Whether you set a new value for 'sql_mode' or not, if the property 'jdbcCompliantTruncation' is "true" (which is the default case), the connector/J also appends the value "STRICT_TRANS_TABLES" to 'sql_mode'. So, your final 'sql_mode' should be "IGNORE_SPACE,STRICT_TRANS_TABLES".

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Urgent J Connector URL Syntax for MySQL ignore-spaces Option
Prashant Nirgun
July 23, 2014 08:31AM
Re: Urgent J Connector URL Syntax for MySQL ignore-spaces Option
Filipe Silva
July 25, 2014 04:55AM
Re: Urgent J Connector URL Syntax for MySQL ignore-spaces Option
Prashant Nirgun
July 26, 2014 05:55AM
Re: Urgent J Connector URL Syntax for MySQL ignore-spaces Option
Filipe Silva
July 29, 2014 05:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.