Thanks Jacques, Thanks & Regards -- Deepak Dixit www.hotwaxsystems.com
On Mon, May 1, 2017 at 2:34 PM, Jacques Le Roux < [email protected]> wrote: > Thanks Deepak, > > I copied it from http://markmail.org/message/i4wxc3qpqhv7njmz and I must > say I did not test, it was an obvious change to me :/ > > I though wondered why there was a white space between true and ";". > > I now understand what happened, somehow the "&" Ingo wrote got > transformed into a simple & and I copied it with a space before because it > got also split at this location by the email channel. > > I also updated https://cwiki.apache.org/confluence/display/OFBIZ/How+to+ > migrate+OFBiz+from+Derby+to+MySQL+database where I did start 1st. > > Sorry for that :) > > Jacques > > > Le 01/05/2017 à 08:57, Deepak Dixit a écrit : > >> Hi Jacques, >> >> Did you get a chance to test it? >> >> I am getting error while connecting with mysql due to this change. >> jdbc-uri pattern should be >> >> >> *https://dev.mysql.com/doc/connector-j/5.1/en/connector-j- >> reference-configuration-properties.html >> <https://dev.mysql.com/doc/connector-j/5.1/en/connector-j- >> reference-configuration-properties.html>* >> >> <https://dev.mysql.com/doc/connector-j/5.1/en/connector-j- >> reference-configuration-properties.html> >> *jdbc:mysql://[host1][:port1][,[host2][:port2]]...[/[database]] >> [?propertyName1=propertyValue1[&propertyName2=propertyValue2]...]* >> >> >> According to this we need to add & to pass characterEncoding in >> jdbc-uri. >> >> jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz_odbc?autoReconnect=tr >> ue&characterEncoding=UTF-8" >> >> >> Thanks & Regards >> -- >> Deepak Dixit >> www.hotwaxsystems.com >> >> On Fri, Apr 14, 2017 at 6:32 PM, <[email protected]> wrote: >> >> Author: jleroux >>> Date: Fri Apr 14 13:02:33 2017 >>> New Revision: 1791361 >>> >>> URL: http://svn.apache.org/viewvc?rev=1791361&view=rev >>> Log: >>> After changing the How+to+migrate+OFBiz+from+Derby+to+MySQL+database >>> page >>> in >>> wiki following Ingo's suggestion on user ML, adapts also the entityengine >>> definition to modern mySQL use >>> >>> Modified: >>> ofbiz/ofbiz-framework/trunk/framework/entity/config/entitye >>> ngine.xml >>> >>> Modified: ofbiz/ofbiz-framework/trunk/framework/entity/config/ >>> entityengine.xml >>> URL: http://svn.apache.org/viewvc/ofbiz/ofbiz-framework/trunk/ >>> framework/entity/config/entityengine.xml?rev=1791361& >>> r1=1791360&r2=1791361&view=diff >>> ============================================================ >>> ================== >>> --- ofbiz/ofbiz-framework/trunk/framework/entity/config/entityengine.xml >>> (original) >>> +++ ofbiz/ofbiz-framework/trunk/framework/entity/config/entityengine.xml >>> Fri Apr 14 13:02:33 2017 >>> @@ -321,6 +321,19 @@ access. For a detailed description see t >>> time-between-eviction-runs-millis="600000"/> >>> </datasource> >>> >>> + <!-- Also consider: >>> + mysql.conf >>> + [client] >>> + default-character-set=utf8 >>> + [mysql] >>> + default-character-set=utf8 >>> + [mysqld] >>> + collation-server = utf8_unicode_ci >>> + init-connect='SET NAMES utf8' >>> + character-set-server = utf8 >>> + >>> + Mysql Version: > 5.6.4 (supports datetime milliseconds) >>> + --> >>> <datasource name="localmysql" >>> helper-class="org.apache.ofbiz.entity.datasource. >>> GenericHelperDAO" >>> field-type-name="mysql" >>> @@ -332,8 +345,8 @@ access. For a detailed description see t >>> alias-view-columns="false" >>> drop-fk-use-foreign-key-keyword="true" >>> table-type="InnoDB" >>> - character-set="latin1" >>> - collate="latin1_general_cs"> >>> + character-set="utf8" >>> + collate="utf8_general_ci"> >>> <read-data reader-name="tenant"/> >>> <read-data reader-name="seed"/> >>> <read-data reader-name="seed-initial"/> >>> @@ -343,7 +356,7 @@ access. For a detailed description see t >>> <read-data reader-name="ext-demo"/> >>> <inline-jdbc >>> jdbc-driver="com.mysql.jdbc.Driver" >>> - jdbc-uri="jdbc:mysql://127.0.0 >>> .1/ofbiz?autoReconnect=true >>> " >>> + jdbc-uri="jdbc:mysql://127.0.0 >>> .1/ofbiz?autoReconnect=true >>> ;characterEncoding=UTF-8" >>> jdbc-username="ofbiz" >>> jdbc-password="ofbiz" >>> isolation-level="ReadCommitted" >>> @@ -365,8 +378,8 @@ access. For a detailed description see t >>> alias-view-columns="false" >>> drop-fk-use-foreign-key-keyword="true" >>> table-type="InnoDB" >>> - character-set="latin1" >>> - collate="latin1_general_cs"> >>> + character-set="utf8" >>> + collate="utf8_general_ci"> >>> <read-data reader-name="tenant"/> >>> <read-data reader-name="seed"/> >>> <read-data reader-name="seed-initial"/> >>> @@ -376,7 +389,7 @@ access. For a detailed description see t >>> <read-data reader-name="ext-demo"/> >>> <inline-jdbc >>> jdbc-driver="com.mysql.jdbc.Driver" >>> - jdbc-uri="jdbc:mysql://127.0.0 >>> .1/ofbizolap?autoReconnect= >>> true" >>> + jdbc-uri="jdbc:mysql://127.0.0 >>> .1/ofbizolap?autoReconnect= >>> true ;characterEncoding=UTF-8" >>> jdbc-username="ofbiz" >>> jdbc-password="ofbiz" >>> isolation-level="ReadCommitted" >>> @@ -398,8 +411,8 @@ access. For a detailed description see t >>> alias-view-columns="false" >>> drop-fk-use-foreign-key-keyword="true" >>> table-type="InnoDB" >>> - character-set="latin1" >>> - collate="latin1_general_cs"> >>> + character-set="utf8" >>> + collate="utf8_general_ci"> >>> <read-data reader-name="tenant"/> >>> <read-data reader-name="seed"/> >>> <read-data reader-name="seed-initial"/> >>> @@ -409,7 +422,7 @@ access. For a detailed description see t >>> <read-data reader-name="ext-demo"/> >>> <inline-jdbc >>> jdbc-driver="com.mysql.jdbc.Driver" >>> - jdbc-uri="jdbc:mysql://127.0. >>> 0.1/ofbiztenant?autoReconnect=true" >>> + jdbc-uri="jdbc:mysql://127.0. >>> 0.1/ofbiztenant?autoReconnect=true ;characterEncoding=UTF-8" >>> jdbc-username="ofbiz" >>> jdbc-password="ofbiz" >>> isolation-level="ReadCommitted" >>> @@ -431,13 +444,13 @@ access. For a detailed description see t >>> alias-view-columns="false" >>> drop-fk-use-foreign-key-keyword="true" >>> table-type="InnoDB" >>> - character-set="latin1" >>> - collate="latin1_general_cs"> >>> + character-set="utf8" >>> + collate="utf8_general_ci"> >>> <read-data reader-name="tenant"/> >>> <read-data reader-name="seed"/> >>> <inline-jdbc >>> jdbc-driver="com.mysql.jdbc.Driver" >>> - jdbc-uri="jdbc:mysql://127.0. >>> 0.1/ofbiz_odbc?autoReconnect=true" >>> + jdbc-uri="jdbc:mysql://127.0. >>> 0.1/ofbiz_odbc?autoReconnect=true ;characterEncoding=UTF-8" >>> jdbc-username="ofbiz" >>> jdbc-password="ofbiz" >>> isolation-level="ReadCommitted" >>> >>> >>> >>> >
