Tomcat

Servlet Set Up
Viewing the Tomcat Logs
Connect jsp <> mysql
Restarting Tomcat

MySQL

Creating MySQL Database

For more help on MySQL please login to the control panel of your website by going to: www.yourdomain.com/admin/ and follow the HELP link.

Servlet Set Up - READ CAREFULLY

To setup servlet, you need to configure servlet into the file web.xml which needs to be placed in /var/www/html/WEB-INF directory.

www root directory or webapps:/var/www/htm

Classes directory located in: /var/www/html/WEB-INF/Classes/
There you will need to upload your Java class file.

Our default url-mapping for servlet is: /servlet/*  
To check servlet in your browser: www.mydomain.net/servlet/HelloWorld
Jsp Files - Upload anywhere in /var/www/html

DOUBLE CHECK:
Double Check that that url-mapping for servlers is entered corectly in web.xml
Double Check that Java class file is uploaded in the corect place.
Without these two things your servlet will not work.

Viewing Tomcat Logs

By default all the logging activity will be placed within the /var/log/ directory of your application. If a ssh shell is enabled on your account then 'tailing' the logs can provide a powerful tool in debugging your web application.
Viewing the logs is recommended when you suspect that errors are occurring during the loading/reloading of your web application.

To get SSH acces you'll need to request it, it is not enabled by default on all accounts.

Connect jsp <> mysql

Example

Please make sure that you have created database through the control panel and that you have setup password for db. Write down your database name - this is very important !

Instructions for database set up available in your initial account activation email titled " MySQL Set Up Instructions"

After this steps, edit dbtest.jsp and enter correct informations, upload this two files and test them

This is an example with org.gjt.mm.mysql.Driver MySQL driver. We also support com.mysql.jdbc.Driver

--------------------------------------------------------------------------------

File 1: dbtest.jsp

<%
String dbhost1 = request.getParameter("dbhost");
String dbname1 = request.getParameter("dbname");
String user1 = request.getParameter("user");
String pass1 = request.getParameter("pass");

if( dbhost1==null )
dbhost1="localhost";
if( dbname1==null )
dbname1="ENTER=HERE-YOUR-DB-NAME";
if( user1==null)
user1="YOUR-USER-NAME";
if( pass1==null )
pass1="MYSQL-PASSWORD";
%>

<form action="dbsubmit.jsp" method=get>
<table>
<tr>
<td>dbhost
<td><input size=60 name="dbhost" type=text value="<%=dbhost1%>">
<tr>
<td>dbname
<td><input size=60 name="dbname" type=text value="<%=dbname1%>">
<tr>
<td>user
<td><input name="user" type=text value="<%=user1%>">
<tr>
<td>password
<td><input name="pass" type=text value="<%=pass1%>">
<tr>
<td colspan="2">
<input type=submit>
</table>

</form>

------------------------------------End of dbtest.jsp

--------------------------------------------------------------------------------

File 2 - dbsubmit.jsp

<%
String dbhost = request.getParameter("dbhost");
String dbname = request.getParameter("dbname");
String user = request.getParameter("user");
String pass = request.getParameter("pass");
String connURL =
"jdbc:mysql://"+dbhost+"/"+dbname+"?user="+user+"&password="+pass;

try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
java.sql.Connection conn = java.sql.DriverManager.getConnection(connURL);
response.getWriter().println("<font color=green><b>");
response.getWriter().println("Connection success!!!");
response.getWriter().println("</b></font>");
}
catch(Exception e)
{
response.getWriter().println("<font color=red><b>[");
response.getWriter().println(e.getMessage());
response.getWriter().println("]<br>");
response.getWriter().println("Connection URL:["+connURL+"]");
response.getWriter().println("</b></font>");
}
%>

<%@include file="dbtest.jsp"%>

--------------------------------End of dbsubmit.jsp

Restarting Tomcat

Shared Tomcat Plan: You'll need to email us and we'll restart the Tomcat for you.
Private Tomcat Plan: Restart Tomcat via SSH access.

Setting Up MySQL Database

Go to www.yourdomain.com/admin/   and login to your account
------> Follow the MySQL link
2.Create a database
3. Write down database name
4. Set up database password

Our MySQL address (hostname)= "localhost"