Shopping Cart
Your Shopping Cart is empty

Jump Setup Instructions

Thanks to the DBAs and Web Administrators who helped with this guide!
Show Container Instructions

After table creation, be sure to apply Select, Insert, Update and Delete permissions

Database - MySQL

Create database and schema:

        Create Database url_shortener;

        USE url_shortener;

        CREATE TABLE ShortenedURL (
        id varchar(60) NOT NULL,
        shortName varchar(255) DEFAULT NULL,
        targetURL blob,
        owner varchar(255) DEFAULT NULL,
        clickCount bigint(20) DEFAULT NULL,
        effectiveDate bigint(20) DEFAULT NULL,
        expirationDate bigint(20) DEFAULT NULL,
        PRIMARY KEY (id)
        );

Copy MySQL driver to server lib directory

Tomcat MySQL server.xml setup - Tomcat example below

Database - Oracle

        Create Database: url_shortener;

        CREATE TABLE ShortenedURL (
        id VARCHAR(60) NOT NULL,
        shortName VARCHAR(255),
        targetURL CLOB(4000),
        owner VARCHAR(255),
        clickCount NUMBER(19),
        effectiveDate NUMBER(19),
        expirationDate NUMBER(19),
        CONSTRAINT urlshortener_pk PRIMARY KEY (id)
        );
Tomcat Oracle server.xml setup

Database - MS SQL Server

        Create Database: url_shortener;

        CREATE TABLE ShortenedURL (
        id VARCHAR(60) NOT NULL,
        shortName VARCHAR(255),
        targetURL TEXT,
        owner VARCHAR(255),
        clickCount NUMBER(19),
        effectiveDate NUMBER(19),
        expirationDate NUMBER(19),
        CONSTRAINT pk_urlshortener PRIMARY KEY NONCLUSTERED (id)
        );
Note a NONCLUSTERED index is used to prevent sharding as the value stored is a GUID. Tomcat MS SQL server.xml setup

Database - SyBase

        Create Database: url_shortener;

        CREATE TABLE ShortenedURL (
        id VARCHAR(60) NOT NULL,
        shortName VARCHAR(255),
        targetURL TEXT,
        owner VARCHAR(255),
        clickCount NUMBER(19),
        effectiveDate NUMBER(19),
        expirationDate NUMBER(19),
        PRIMARY KEY (id)
        );
Tomcat SyBase server.xml setup

Database - PostGres

        Create Database: url_shortener;

        CREATE TABLE ShortenedURL (
        id VARCHAR(60) NOT NULL,
        shortName VARCHAR(255),
        targetURL TEXT,
        owner VARCHAR(255),
        clickCount BIGINT,
        effectiveDate BIGINT,
        expirationDate BIGINT,
        PRIMARY KEY (id)
        );
Tomcat Postgres server.xml setup

Database - DB2

        Create Database: url_shortener;

        CREATE TABLE ShortenedURL (
        id VARCHAR(60) NOT NULL,
        shortName VARCHAR(255),
        targetURL CLOB(4000),
        owner VARCHAR(255),
        clickCount INTEGER,
        effectiveDate INTEGER,
        expirationDate INTEGER,
        PRIMARY KEY (id)
        );
Tomcat DB2 server.xml setup

Databases - Java DB, Derby, CloudScape

        Create Database: url_shortener;

        CREATE TABLE ShortenedURL (
        id VARCHAR(60) NOT NULL,
        shortName VARCHAR(255),
        targetURL CLOB(4000),
        owner VARCHAR(255),
        clickCount BIGINT,
        effectiveDate BIGINT,
        expirationDate BIGINT,
        PRIMARY KEY (id)
        );

Apply Select, Insert, Update permissions


Container - Tomcat MySQL Example

Copy database driver to server/lib directory

Copy DBCP Pool driver to server/lib directory

Add to server context.xml file:

<ResourceLink name="jdbc/AckDevJump"
global="jdbc/AckDevJump"
type="javax.sql.DataSource"/>

Add to server.xml file (MySQL Example):

<Resource name="jdbc/AckDevJump"
global="jdbc/AckDevJump"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.cj.jdbc.Driver"
url="jdbc:mysql://YOUR_SERVER_ADDRESS:YOUR_SERVER_PORT/url_shortener"
username="YOUR_DB_LOGON"
password="YOUR_DB_PASSWORD"
maxActive="100"
maxIdle="20"
minIdle="5"
maxWait="-1" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
timeBetweenEvictionRunsMillis="300000"
minEvictableIdleTimeMillis="30000"
/>
Note driver class name will change based on technology and version.

Restart server

copy ROOT.war to webapps directory

Additional help and tuning options for tomcat available here

Request your local DNS address similar to "Jump" (Keep it short!)