New (Upgrade/Change) Database Server
This page describes the procedure to upgrade/change to a new database server:
- 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 &
- 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';
- 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
- Update JDBC (derby.jar) file in lexdev
- ${PROJECTS}/lexAccesLb
- ${TOMCAT}/WebLexAcces.Lb
- ${TOMCAT}/WebLexBuild