Test your Oracle / Java Account is working {Legacy}

At this point it is assumed that the basic servlets are working. To see how to test this go to Using Servlets

To test that the connection to Oracle is working, open up a web browser and go to

http:// webserver /mountpoint / testDB2020

where

webserver is the name for your web server
mountpoint is the name of the mount points for servlets.

Both of these are in the account detail letter.

This should bring up a page looking like:

2020Media Database Servlet Connection Working

You have connected successfully

If this does not happen, then contact support at Contact Us.

Connecting to Oracle

The following code fragments show the supported method of connecting to Oracle.







import java.sql.*;

import java.io.*;

import java.util.*;


import javax.servlet.*;

import javax.servlet.http.*;

......

public static final String DB_URL = "jdbc:oracle:thin@db_servername:1521:db_database_sid";

public static final String DB_USERNAME = "db_username";

public static final String DB_PASSWORD  = "db_password";

public static final String DB_DRIVER = "oracle.jdbc.driver.OracleDriver";

......

public void init() throws ServletException

{
    try
    {
        Class.forName(DB_DRIVER);
    }
    catch(java.lang.ClassNotFoundException e)
    {
		......
    }
    try
    {
       con = DriverManager.getConnection(DB_URL,
                                   DB_USERNAME, DB_PASSWORD);
    }
    catch(SQLException ex)
    {
       ...........
    }