S I T E  S E C T I O N S

Home
Sales
Dedicated Servers
Reseller Hosting
Virtual Private Server
Web Hosting
Support
articles
Site Design Quote
Privacy

S E C T I O N S

cpanel demo
Nameserver demo
WHM demo
Hosting Manual
Getting Started
Agora Shopping Cart
Anonymous ftp
Backup Manager
CGI Setup
CGI Centre
MS Frontpage
Ftp Help
Change Password
File Manager
Form Mail
Email
Mail List
Mime Types
MySql
Network Tools
Path Information
PGP Email
PHP information
_Directory password
Search Submit
Secure Server
SSH Telnet
_Server Side Include
Stats Overview
URL Redirection
Java
Control Panel
FAQ
Web Resources
Internet Security Alerts

           The steps required to implement serverside java on your Arachno Net hosting account

  • 1/ Some basic information: Our JDK is version 1.4
  • We use Tomcat 4 java server with which you can implement jsp, servlets and enterprise java beans.
  • a/ Tomcat 4.0 will implement the Servlet 2.3 and JSP 1.2 container specifications.Tomcat 4.0 also supports web applications built for the Servlet 2.2 and JSP 1.1 specifications with no changes.
  • b/ To have java enabled for your site, please email support@arachnonet.com and request that it be installed on your site, please provide your username and site url with the request.
  • c/ When it is installed a java directory structure will appear in your site root directory, the structure will be like this /java/WEB-INF/classes
  • d/ jsp files will go in the /java directory or subdirectories under it, and will be called with the url http://www.yourdomainname.com/java/filename.jsp, it is important to use the www in the URL format as www.yourdomainname.com is your sites context definition within the server.xml file, and therefore no other format will work
  • e/ Your web.xml files used to define your servlets go in the /java/WEB-INF directory
  • f/ Your servlets (class files will go in the /java/WEB-INF/classes directory and you can call the servlets using http://www.yourdomainname.com/java/servlet/servletname
  • 2/ Our JDBC mysql driver is mm.mysql if you wish to use JDBC follow these instructions
  • a/ In your control panel use the mysql manager to create your database and user then assign the user to the database.
  • Use the connection string given in the mysql manager with the addition of the connection port, please see the example below.
  • JDBC Connection C = DriverManager.getConnection( "jdbc:mysql://localhost:3306/database_name?user=something_user&password=xxxxxxxx");
  • You can use the sample code below to check your database connection This sample code was made available by thebeastunleashed.com

<%

       // ---- configure this for your site

       // The URL that will connect to our MySQL server. Syntax: jdbc:TYPE:machine:port/DB_NAME

    

      String url = "jdbc:mysql://localhost:3306/database_name?user=xxx_xxx&password=yyyyy";

       // A canned query string

      String queryString = "SELECT the_column from your_table_name";

    

      // INSTALL/load the Driver (Vendor specific Code)

       try {

         Class.forName("org.gjt.mm.mysql.Driver");

       } catch(java.lang.ClassNotFoundException e) {

         System.out.print("ClassNotFoundException: ");

        System.out.println(e.getMessage());

       }

    

       // Here's where we start the connection and then submit a request

       out.println ("<h1>Connecting to a mySQL database</h1><hr>");

       try {

          java.sql.Connection con;

          java.sql.Statement stmt;

    

       // Establish Connection to the database at URL with usename and password

           con = java.sql.DriverManager.getConnection(url);

           out.println ("<BR>Ok, connection to the DB worked.");

           out.println ("<BR>Let's see if we can retrieve something with: <STRONG>" + queryString + "</strong>");

    

    

      // Create a Statement Object

      stmt = con.createStatement();

      out.println ("<BR><br>Created statement ...");

      // Send the query and bind to the result set

        java.sql.ResultSet rs = stmt.executeQuery(queryString);

        out.println ("<BR><BR>Got result set .. it is " + (rs == null ? " NULL" : "not null") +  "<BR><br>");

    

        int counter =       0;

        while (rs.next()) {

             String s = rs.getString("cl_name");

             out.println("Column <strong>the_column</strong> for row " + (++counter) + " is " + s + "<BR>");

       }

       // Close resources

      stmt.close();

      con.close();

       }

       // print out decent error messages

        catch(java.sql.SQLException ex) {

        out.println("==> SQLException: ");

      while (ex != null) {

         out.println("Message:   " + ex.getMessage () +"<BR>");

         out.println("SQLState:  " + ex.getSQLState () + "<BR>");

         out.println("ErrorCode: " + ex.getErrorCode () + "<BR>");

         ex = ex.getNextException();

         out.println("<BR>");

       }

       } catch (Exception e1) {

             out.println ("Other exception - " + e1.getMessage ());

       }

     %>

 

[Home] [Web Hosting] [Reseller Hosting] [Virtual Private Server] [Dedicated Servers] [Sales] [Support]

Please contact our Webmaster with questions or comments.                          
©Copyright 2000 Arachno Net  All rights reserved.