This page is intended to be the root of cookbooks and/or FAQ (work in progress FAQ and cookbook will perhaps be separated later).
I hope to integrate interesting points from
http://ofbizwiki.go-integral.com/Wiki.jsp?page=FAQ  and http://www.opensourcestrategies.com/ofbiz/tutorials.php (OFBiz Cookbooks part). For the later it depends on OpenSource Strategies agreement (still waiting for it ;o).
But perhaps links to them may be sufficient... Until they diseappear... then I will see...
Tables of content
Nabble
Search in Nabble OFBiz forum from Firefox
Eclipse
Running and Debugging OFBiz in Eclipse
Derby
Change a field type in Derby
Working with multiple Derby databases
Browse a Derby database and more using SQuirrel
Ajax
Disable Browser Cache for Module
Integrate OFBiz with Yui-Ext
Windows
Patch on Windows
Run OFBiz as a Windows service
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.
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
Use CVV (also called CV2 and more acronyms) codes in OFBiz
https://issues.apache.org/jira/browse/OFBIZ-767#action_12476855
Ajax : Disable Browser Cache for Module
A tip from Krzysztof Podejma
Ajax : Integrate OFBiz with Yui-Ext
http://www.nabble.com/Re%3A-integrate-OFBiz-with-Yui-Ext-p11131937.html
A tip from Jason Wu
Patch on Windows
To patch on Windows you have to download patch.exe. But you may encouter EOL problems with patch.exe.
That's why I prefer to use Tortoise's "Apply Patch" option in a 1st step. Tortoise is the best SVN and CVS UI existing, either on Linux or Windows. Besides Tortoise comes from Tigris too.
Then if I get problems with Tortoise (or Eclipse's "Apply Patch" option wich is near Tortoise for patching but less supple for this option and far more ingeneral) I use the patch command. Something to understand is that Tortoise actually use "SVN merge" so in certains cases problems arise.
To avoid EOL problems with the patch command, I use a bat file patchdos.bat :
todos %1
patch -p0 < %1
where todos is and exe to download. Of course you will have to deal with path. But at this stage I guess it's easy...
I just learned from https://sourceforge.net/project/shownotes.php?release_id=508633 that the "--binary" option may be used in that case, did no try yet...
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: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 in C:\Program Files\Java\j2sdk1.4.2_xx
then you would set 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).
- Alternatively, the service can be started with the command:net start OFBiz
- And the service can then be stopped with the command:net stop OFBiz
Advice from enki_ at users.sourceforge.net. There is an alternative to this solution : How to Run OFBiz as Windows Service with Java Service Wrapper