Running fimsship with derby on another machine

On remote machine (lets call it "shuttle")

Put the derby db in C:\apps\apache-tomcat-5.5.20\bin\fims_dev_ship

SET DERBY_HOME=C:\apps\db-derby-10.2.2.0-bin
SET DERBY_OPTS=-Dderby.system.home=C:\apps\apache-tomcat-5.5.20/bin

Modify C:\apps\db-derby-10.2.2.0-bin\startNetworkServer.bat to read

:runNoClasspath
"%_JAVACMD%" %DERBY_OPTS% -Dderby.drda.host=0.0.0.0 -classpath "%LOCALCLASSPATH%" org.apache.derby.drda.NetworkServerControl start
goto end

:runWithClasspath
"%_JAVACMD%" %DERBY_OPTS% -Dderby.drda.host=0.0.0.0 -classpath "%CLASSPATH%;%LOCALCLASSPATH%" org.apache.derby.drda.NetworkServerControl start
goto end


Note: Do NOT be termpted to add "-Dderby.drda.host=0.0.0.0" to DERBY_OPTS or otherwise you cannot stop the server with stopNetworkServer.bat (it will say can't connect to 0.0.0.0)

On the remote machine run startNetworkServer.bat (and stop it with stopNetworkServer.bat)

On the development machine use this to build a version of fimsship that works with remote derby

ant -f build-ship-dev.xml clean deploy

but make sure that the host is correct in properties-ship-dev.xml

Note: I have had some problems starting the server. "Cannot listen on port 1527 on interface 0.0.0.0. Note sure why, but the fix is to run stopNetworkServer a couple of times and try again.