New (Upgrade/Change) Database Server

This page describes the procedure to upgrade/change to a new database server:

1. Upgrade the server
   • Follow the instruction to upgrade/change the database server
   • Start up the new database server
   • Example: Apache-Derby
     • Set up DB server: Apache-Derby 10.14.2.0
     • shell>ln ./db-derby-10.14.2.0 javadb
     • Environment variables: set ${DERBY_HOME}, ${DB_DIR}
     • Update java CLASSPATH
       • ${DERBY_HOME}/lib/derby.jar (for embedded mode, etc.)
       • ${DERBY_HOME}/lib/derbynet.jar (for servers)
       • ${DERBY_HOME}/lib/derbyclient.jar (for java programs)
       • ${DERBY_HOME}/lib/derbytools.jar (for ij)
     • Setup Derby Data directory
       • Create data directory: ${DB_DIR}/JavaDb/data
       • Add derby.properties to ${DB_DIR}/JavaDb/data
     • Start DB server:
shell> java -Xms128m -Dderby.system.home=${DB_DIR}/JavaDb/data -jar ${DERBY_HOME}/lib/derbyrun.jar server start &
2. Create new database in Derby
   
shell>java org.apache.derby.tools.ij
ij>connect 'jdbc:derby://server:portNum/lexBuild;user=lexBuild;password=LexBuildPasswd;create=true';
3. Update jar files
   • ${DERBY_HOME}/lib/derbyclient.jar:
     • ${LB_DIR}/Tools/LoadDb/DbScript
     • ${LB_DIR}/Tools/LoadDb/GenScript
     • ${LB_DIR}/Tools/LoadDb/runDb

     • ${LB_DIR}/Tools/PostProcessing/CheckCrossRef
     • ${LB_DIR}/Tools/PostProcessing/CheckIrreg
     • ${LB_DIR}/Tools/PostProcessing/CheckTradeMark
     • ${LB_DIR}/Tools/PostProcessing/CleanUpNewTerms
     • ${LB_DIR}/Tools/PostProcessing/FixHiddenRecords
     • ${LB_DIR}/Tools/PostProcessing/GenerateGSpellDic

     • ${LB_DIR}/Tools/WebScript/AutoFix
     • ${LB_DIR}/Tools/WebScript/backupTables
     • ${LB_DIR}/Tools/WebScript/CheckCrossRef
     • ${LB_DIR}/Tools/WebScript/GenerateInflVars
     • ${LB_DIR}/Tools/WebScript/GenerateLexicon
     • ${LB_DIR}/Tools/WebScript/GenerateLexiconInflVars
     • ${LB_DIR}/Tools/WebScript/ReIndexDic

   • ${WEB_LB}/web/WEB-INF/lib/
     • derbyclient.jar
     • derbyLocale_cs.jar
     • derbyLocale_de_DE.jar
     • derbyLocale_es.jar
     • derbyLocale_fr.jar
     • derbyLocale_hu.jar
     • derbyLocale_it.jar
     • derbyLocale_ja_JP.jar
     • derbyLocale_ko_KR.jar
     • derbyLocale_pl.jar
     • derbyLocale_pt_BR.jar
     • derbyLocale_ru.jar
     • derbyLocale_zh_CN.jar
     • derbyLocale_zh_TW.jar
4. Update JDBC (derby.jar) file in lexdev
   • ${PROJECTS}/lexAccesLb
   • ${TOMCAT}/WebLexAcces.Lb
   • ${TOMCAT}/WebLexBuild