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&nbsp 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

Running and Debugging OFBiz in Eclipse 

Change a field type in Derby
Working with multiple Derby databases
Browse a Derby database and more using SQuirrel

Use cvv codes in OFBiz

Ajax : Disable Browser Cache for Module
Ajax : Integrate OFBiz with Yui-Ext

Patch on Windows
Run OFBiz as a Windows service

Change a field type in Derby 

1. Export the table to xml
2. Drop the table
3. Start OFBiz - table recreated with new structure
4. 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

http://docs.ofbiz.org/x/CAo

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