to Java Skyline

Skyline Boulevard Systems, Inc

Presents Adhoc SQL - a testing servlet you can use to ensure that the servlet environment you are using can access databases.

Last updates: Apr 18, 1999

System Requirements

• Any web server and/or Java server supporting HTTP and Servlet API (see the Java Skyline List)
• The appropriate JDBC driver for your database (see Java Skylne Resources: Database)
• A JRE and/or JDK 1.1.x or greater (see java.sun.com).

Installation Instructions

• Download adhocsql.zip here
• Unpack the files into a temporary directory.
• Place AdhocSQL.class in the servlet directory for your Java server.
• Place adhocsql.html an HTML document directory for your web server.
• If you are using the JDBC-ODBC bridge (that comes with the JDK and JRE), you're done.
• If you are using a different driver, you need to ensure that CLASSPATH for the Java server points properly to the driver as described in the documentation for your driver.

Operating Instructions

Navigate to adhocsql.html with your browser. The screen appears as follows:

• Enter the database name and URL. If you're using JDBC-ODBC bridge, you can leave the URL blank.
• Enter the User ID and password for the database.
• Select the database server type. If the type you need isn't listed, add a Select option to the pull-down box in the adhocsql.html source.

Next:

• To list the tables in the database, click the Catalog button or
• Enter a SELECT SQL statement in the text area and click Run, or
• Enter a table name in the text area and click Columns to list the columns for a table.

For assistance e-mail: richkatz@earthlink.net