UK Sales: 0800 035 6364 | sales@2020media.com | We'll Call You

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)
{
...........
}

where
db_username , db_password, db_servername and db_database_sid are detailed in your account information.

We urge you to use code as close to this as possible, as it aids our debugging of any problems.

 

The source for the test page is available in the 'src' directory.

 

More Information

Database Migration Kits: http://technet.oracle.com/
Oracle on Linux: http://technet.oracle.com/tech/linux/
Oracle Documentation: http://technet.oracle.com/docs/content.html

2020Media is a leading provider of small business Wi-Fi hotspots. If you want to offer free Wi-Fi to your customers or users, our service could be exactly what you are looking for. Our Hotspots are managed in the cloud, ultra-reliable and give you loads of information about behaviour patterns of your users. Read More   Read more...
2020Media introduces Moodle Hosting - UK servers and UK Moodle experts setup your site ready to use. Read more...
Special Offer for Longer Registration Periods Register or renew a .com, .net or .org domain name for 5 years we'll include 1 year free*. Read more...
2020Media is now offering zero-click installation of the popular TYPO3 content management system. Read more...

Our blog is regularly updated with news, tips and industry opinion.

Clients

  • AggieWestons
  • baker-and-mckenzie
  • arts-council-england
  • Big Finish
  • barratt-developments-logo
  • City-of-Lincoln-council-logo
  • brora-logo
  • DenisMacShane
  • Construction-Industry-Council
  • colchester