Turn OFBiz slimming [verified, 9.04-11.04 for slight modification available]

OFBiz slimming
Because OFBiz has many tables and does not have much information for our reference (at least the Chinese version is the same), I don't know where to start learning. After one night of study (of course there is also a half-month basis), I finally reduced the OFBiz table to only 66, which makes it much easier to learn. The specific method is as follows:

1. Create the database OFBiz in MySQL and modify the file OFBiz \ framework \ entity \ config \ entityengine. xml,

XML Code

2. delegator name = " default " entity entity-model- reader = "Main" entity -group-reader = "Main" entity-ECA-reader = "Main" distributed -Cache-clear -enabled = "false"
4. <Group-Map Group-name="Org. OFBiz" Datasource-name="Localmysql"/>
6. </Delegator>
10. <Datasource Name="Localmysql"
12. Helper-class="Org. OFBiz. entity. datasource. generichelperdao"
14. Field-type-name="MySQL"
16. Check-on-start="True"
18. Add-missing-on-start="True"
20. Check-PKS-on-start="False"
22. Use-foreign-keys="True"
24. Join-style="ANSI-no-parenthesis"
26. Alias-View-Columns="False"
28. Drop-FK-use-foreign-key-Keyword="True"
30. Table-type="InnoDB"
32. Character-Set="Latin1"
34. Collate="Latin1_general_cs">
36. <Read-Data Reader-name="Seed"/>
38. <Read-Data Reader-name="Demo"/>
40. <Read-Data Reader-name="Ext"/>
42. <Inline-JDBC
44. JDBC-driver="Com. MySQL. JDBC. Driver"
46. JDBC-Uri="JDBC: mysql: // 127.0.0.1/OFBiz? Autoreconnect = true"
48. JDBC-Username="Root"
50. JDBC-Password="Root"
52. Isolation-level="Readcommitted"
54. Pool-minsize="2"
56. Pool-maxsize="20"/>
58. <! -- <JNDI-jdbc JNDI-server-name = "localjndi" JNDI-name = "Java:/mysqldatasource" isolation-level = "serializable"/> -->
60. </Datasource>

2. Comment out applications, specialpurpose and hot-deploy in OFBiz \ framework \ base \ config \ component-load.xml. The result is as follows:

XML Code

2. <Component-loader Xmlns: xsi=Http://www.w3.org/2001/XMLSchema-instance"Xsi: nonamespaceschemalocation=Http://www.ofbiz.org/dtds/component-loader.xsd">
4. <Load-Components Parent-directory="$ {OFBiz. Home}/framework"/>
6. <! -- <Load-components parent-directory = "$ {OFBiz. Home}/Applications"/> -->
8. <! -- <Load-components parent-directory = "$ {OFBiz. Home}/specialpurpose"/> -->
10. <! -- <Load-components parent-directory = "$ {OFBiz. Home}/hot-deploy"/> -->
12. </Component-loader>

3. comment out the workflow, testtools, and example in the OFBiz \ framework \ component-load.xml file. The result is as follows:

XML Code

2. <Component-loader Xmlns: xsi=Http://www.w3.org/2001/XMLSchema-instance"Xsi: nonamespaceschemalocation=Http://www.ofbiz.org/dtds/component-loader.xsd">
4. <Load-component Component-location="$ {OFBiz. Home}/framework/Geronimo"/>
6. <Load-component Component-location="$ {OFBiz. Home}/framework/entity"/>
8. <Load-component Component-location="$ {OFBiz. Home}/framework/Catalina"/>
10. <! -- <Load-component-location = "$ {OFBiz. Home}/framework/Jetty"/> -->
12. <Load-component Component-location="$ {OFBiz. Home}/framework/security"/>
14. <Load-component Component-location="$ {OFBiz. Home}/framework/datafile"/>
16. <Load-component Component-location="$ {OFBiz. Home}/framework/minilang"/>
18. <Load-component Component-location="$ {OFBiz. Home}/Framework/Common"/>
20. <Load-component Component-location="$ {OFBiz. Home}/framework/service"/>
22. <Load-component Component-location="$ {OFBiz. Home}/framework/entityext"/>
24. <Load-component Component-location="$ {OFBiz. Home}/framework/webapp"/>
26. <Load-component Component-location="$ {OFBiz. Home}/framework/guiapp"/>
28. <Load-component Component-location="$ {OFBiz. Home}/framework/widget"/>
30. <Load-component Component-location="$ {OFBiz. Home}/framework/appserver"/>
32. <! -- <Load-component-location = "$ {OFBiz. Home}/framework/workflow"/> -->
34. <! -- Load-component-location = "$ {OFBiz. Home}/framework/shark"/> -->
36. <! -- <Load-component-location = "$ {OFBiz. Home}/framework/testtools"/> -->
38. <Load-component Component-location="$ {OFBiz. Home}/framework/WebTools"/>
40. <Load-component Component-location="$ {OFBiz. Home}/framework/images"/>
42. <! -- <Load-component-location = "$ {OFBiz. Home}/framework/example"/> -->
44. </Component-loader>

4. Open the doc and run the following command in the OFBiz directory:

Ant clean-all

Ant run-install

Startofbiz. bat

7. https: // localhost: 8443/WebTools/

5. after step 1 is executed, there is only one system record in the user_login table, but the password field of the record is empty. You need to change it to the "OFBiz" encryption code, in addition, the value of the enable field is "N", indicating that the user is unavailable. You need to change the value to "Y". The two SQL statements executed are as follows:

SQL code

1. UpdateUser_loginSetCurrent_password ='47ca69ebb4bdc9ae0adec130880165d2cc05db1a';
2. UpdateUser_loginSetEnabled ='Y';

6. Start OFBiz. Currently only WebTools are available (http: // localhost: 8080/WebTools). User Name/password: System/OFBiz

 

Reprinted from: http://zhaxg.iteye.com/blog/510547