Increasing Heap Memory of Tomcat

If your server gives error like Out Of Memory :java heap size then try the following.


Apache Tomcat

To increase minimum and maximum heap size for Tomcat applications set the CATALINA_OPTS environment variable before starting Tomcat. To set the same heap sizes, on UNIX edit the Tomcat startup.sh script and add a line:


    export CATALINA_OPTS=-Xms16m -Xmx256m;

Load a comma delimited file (CSV) into the database

Load a comma delimited file (CSV) into the database:

Command: LOAD DATA LOCAL INFILE "/tmp/TableData.csv" INTO TABLE employer FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY """" LINES TERMINATED BY "\r\n" (Name, Dept, jobTitle);