Posts Under 'Tutorials'

Apache 2.x + Tomcat 4.x + Load Balancing

This article contains step by step instructions for configuring an Apache 2.x web server which handles static content and delegates JSP (Java Server Pages) and Servlet requests to two Tomcat 4.x servers using AJP 13 connectors and a load balancing worker. Introduction Apache 2.0 is a standards compliant, fast and mature web server which excels […]

Read more »


How to export mysql table data into csv file using php

This PHP script will export all the mysql table data into a csv file. <? $dbconnection; $table="members"; $csv = NULL; /* link identifier from db connection */ $r = mysql_query("show columns from ".$table); while ($row = mysql_fetch_assoc($r)) { $csv .= $row['col_name'].','; } $csv = substr($csv, 0, -1)."n"; $r = mysql_query("select * from ".$table); while ($row […]

Read more »


HOW TO Subversion+Apache on Fedora

HOW TO Subversion+Apache on Fedora To learn or use Subversion, please read the book. To install subversion run below commands: Then you need to setup at least one repository to test it. Here create the folders.. repos – will contain all the projects users – will contain all the user configs permissions – will contain […]

Read more »


how to find the last insert id in java+mysql?

JDBC 3.0 (MySQL has a JDBC 3 compliant driver) method as such: Statement stat = dbConn.createStatement(); Stat.executeUpdate("Some insert statement here"); ResultSet rs = stat.getGeneratedKeys(); Int insertedKeyValue = rs.getInt(1); Rs.close(); Stat.close();

Read more »


How to Remove jsessionid from URL

A "JSESSIONID" is the unique id of the http session – see the javadoc here. When you start a HTTP session, the session ID is appended to the URL and a cookie is set. If the browser has cookies enabled, the JSESSIONID is not used on subsequent requests. Here is a urlrewrite rule to get […]

Read more »