As I was not able to create a correct database connection, just left two
half working versions CimAppOrders.java and CimAppCustomer.java.
The latest version is at Customer file, the better working is the Order one.
###############################
##### Database connection #####
##### To have it run, I had to copy the extracted mysql-connector-java-5.1.23-bin
##### jar file to /usr/lib folder and run:
sudo chown -R :www-data /usr/lib/mysql-connector-java-5.1.23-bin/
# to able apache run it as a web service.
##### The following blogs were useful to do it:
# http://stackoverflow.com/questions/13904103/java-lang-classnotfoundexception-oracle-jdbc-driver-oracledriver
Have you copied classes12.jar in lib folder of your web application and set the
classpath in eclipse.
Right-click project in Package explorer Build path -> Add external archives...
Select your ojdbc6.jar archive
# http://stackoverflow.com/questions/8348000/class-not-found-exception-when-trying-to-load-jdbc-mysql-driver
You missed mysql-connector-j jar file in your classpath. Use "java -cp .:
mysql.jar...". Ou. It's a webapp! Then put mysql jar file to WEB-INF/lib folder.