LexBuild

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