This page is intended to be the root of cookbooks and/or FAQ (work in progress FAQ and cookbook Cookbook, FAQ, Tips, Tricks, HowTo, etc. (will perhaps be separated later).
I'm in the process of integrating interesting points fromhttp://ofbizwiki.go-integral.com/Wiki.jsp?page=FAQ 
I would to integrate interesting points from http://www.opensourcestrategies.com/ofbiz/tutorials.php (OFBiz Cookbooks part)
...
but I don't know the licence status.
Tables of content
Ajax - Javascript - Json
- Disable Browser Cache for Module
- Integrate OFBiz with Yui-Ext
- An easy way to get a data structure from server to Javascript in client browser
Birt
DataBases
Derby
- Change a field type in Derby
- Working with multiple Derby databases
- Browse a Derby database and more using SQuirrel
Oracle
OFBiz's Data File Tools
Eclipse
Lamba Probe
Miscellaneous
Nabble
Netbeans
- OFBiz in NetBeans
This page may be a bit outdated but most informations are still relevant. You should also look at the nbproject.zip file in https://issues.apache.org/jira/browse/OFBIZ-3
Production Tips
Quick Start Guides
Selenium
Windows
FAQ - TIPS - Cookbook - How to
Anchor | ||||
---|---|---|---|---|
|
Change a field type in Derby
- Export the table to xml
- Drop the table
- Start OFBiz - table recreated with new structure
- Import xml data from #1
Advice from Adrian Crum.
Anchor | ||||
---|---|---|---|---|
|
Browse a Derby database and more using SQuirrel
http://db.apache.org/derby/integrate/SQuirreL_Derby.html#N101C7
For the URL use something like jdbc:derby:c:/ofbiz/runtime/data/derby/ofbiz (of course using your right path)
Link from Sundeep Ray. There is an alternative to this solution : http://docs.ofbiz.org/display/OFBIZ/Running+and+Debugging+OFBiz+in+Eclipse#RunningandDebuggingOFBizinEclipse-Connectingthedatabase
Anchor | ||||
---|---|---|---|---|
|
Use CVV (also called CV2 and more acronyms) codes in OFBiz
As of rev. 585172 (date 2008-10-16) the changes mentioned below have been officially included in the OFBiz trunk.
...
Anchor | ||||
---|---|---|---|---|
|
Ajax : Disable Browser Cache for Module
A tip from Krzysztof Podejma
Anchor | ||||
---|---|---|---|---|
|
Ajax : Integrate OFBiz with Yui-Ext
http://www.nabble.com/Re%3A-integrate-OFBiz-with-Yui-Ext-p11131937.html
...
Anchor | ||||
---|---|---|---|---|
|
Patch on Windows
Creating patches
Using Eclipse => Subclipse (Create Patch, Apply Patch context menu options)
...
I let you find the tools (Eclipse/Subclipse, Tortoise, Subversion client, patch.exe, todos.exe with google ;o)
Applying patches
To patch on Windows you have to download patch.exe. But you may encouter EOL problems with patch.exe.
...
Anchor | ||||
---|---|---|---|---|
|
Run OFBiz as a Windows service
- You need JavaService.exeThis is freely available at http://javaservice.objectweb.org/.
Documentation and example code are also available
Unzip the JavaService-bin-1.2.x.zip (or JavaService-2.0.x.zip) - Where should the expanded files be located?
Set up and run your script with the appropriate path. Ex:Code Block javaservice -install OFBiz %java_home%\jre\bin\server\jvm.dll -Xms256M -Xmx512M -Djava.class.path=%java_home%\lib\tools.jar;%ofbiz_home%\ofbiz.jar -start org.ofbiz.base.start.Start -out %ofbiz_home%\logs\serviceLog.txt -err %ofbiz_home%\logs\serviceErr.txt -current %ofbiz_home% -manual
Note: If your java sdk is installed under a directory with a space in it, the service will install, but not start properly, unless you change java_home to the DOS 8.3 name. For example, if your java sdk is installed inC:\Program Files\Java\j2sdk1.4.2_xx
then you wouldset java_home=C:\PROGRA~1\Java\j2sdk1.4.2_xx
* Go to the win2k services app and you should now find a service 'OFBiz' set up to run manually (this of course can be changed to run automatically if so desired).
...
Anchor | ||||
---|---|---|---|---|
|
Some Selenium tips
Due to some license issues with external libraries used in Selenium we cannot include this in the Apache trunk. However, a new component has been created which is free to download and use, but lives in an ofbizext repository.
https://svn.hotwaxmedia.com/svn/ofbizext/selenium Drop this in hot-deploy. If you want to know more, please look at https://issues.apache.org/jira/browse/OFBIZ-680
1) For running "successive" test cases I used browser "Refresh" button but I think there might be some better option to handle this. Is there any option exists in Selenium IDE ?
If you want to chain execution of different tests, there is the notion of test suite. A list of tests to run one after the other (see http://labs.libre-entreprise.org/plugins/scmcvs/cvsweb.php/ofbizNeogia/neogia/manufacturing/webapp/manufacturing/tests/ManufacturingTestSuite.html?rev=1.9;content-type=text%2Fplain;cvsroot=neogia)
...