Sybase JDBC LookUp Sample

(with NSAPI on Netscape Enterprise Server)

This sample will connect to a SQL Anywhere database, look up and display customer information for a customer with the specified first and last name.

This file contains instructions for running this sample with the Netscape Enterprise Server. For instructions on running the sample with either the Microsoft Internet Information Server or the Microsoft Personal Web Server, please refer to the file IJDBC_Lookup.html. This file will only provide the instructions to run this sample. For a more detailed explanation of the components, please refer to the file NetscapeInstall.html.

Click here for installation instructions.

Installation Instructions

To run this sample on your machine, you will need to install the following components:

Netscape Enterprise Server
Microsoft Java VM
SQL Anywhere (and a SQL Anywhere database)
Open Server Gateway components from SQL Anywhere

Server Side Instructions

To configure the Netscape Enterprise Server

Go to your \Netscape\Server\docs directory

Create a file named service.wjava and add these statements to it:

    <HTML>
    <HEAD>
    <TITLE>Optima++ Java Netscape Service Placeholder</TITLE>
    </HEAD>
    <BODY>
    <BLOCKQUOTE>
    <FONT SIZE=+3>P</FONT><FONT SIZE=+1>laceholder for Optima++ Java
    support. If you see this file on your browser, you have not installed
    or setup the JAVANSAPI.DLL properly.
    </BODY>
    </HTML>

Save service.wjava and close the file
Go to your \Netscape\Server\https-serverName\config directory, where serverName is the name of your Netscape Enterprise Server.
```
    For example: d:\Netscape\Server\https-mnguyen\config 
```
Open the file obj.conf.

Add this line after the last Init fn= statement (all on 1 line, without newlines):

    Init fn="load-modules" shlib="%Starbuck%/system/javansapi.dll"
    funcs="wjava-fn,wjava-ntrans"
        where %Starbuck% is the directory where Starbuck is installed

    For example:
        Init fn="load-modules" shlib="d:/starbuck20/system/javansapi.dll"
        funcs="wjava-fn,wjava-ntrans"

Add this line after the <Object name="default"> statement:
```
    NameTrans fn=wjava-ntrans 
```
Add these lines after </Object> statement that closes the <Object name="default">
section:
```
    <Object name=wjava>
    Service fn=wjava-fn
    </Object> 
```
Save obj.conf and restart your Netscape Enterprise Server

To configure the Open Server Gateway for a SQL Anywhere Database

Install the Open Server Gateway components (SQL Anywhere Open Server Gateway and Sybase Open Server components) when installing SQL Anywhere Server.
Check that your SYBASE environment variable is set to point to the directory where you've installed the Open Server Gateway components.
```
    For example: SYBASE = d:\sybase 
```
Run \sybase\bin\sqledit.exe to provide an Open Server Gateway name for your SQL Anywhere database and configures your connection profile.
Click on the Input Server Name box and type the Open Server Gateway name you want to give your SQL Anywhere database. The convention is to give the Open Server Gateway the same name as your SQL Anywhere database.
```
    For example: sademo 
```
Click on Add to add this name to the list of Server Entries.
From the Service Type list, select query to add a query service
From the Platform list, select the appropriate platform (NT, dos, or win3).
From the Net-Library Driver list, select NLWNSCK. This is the WinSock network-library driver.
Click on the Connection Information/Network Address box. Then type your machine name, a comma and then the port number where client programs can access this SQL Anywhere database. Here, you can choose any unused port number.
```
    For example: MNGUYEN, 8000 
```
Click Add Service to add this query service.
From the Service Type list, select master to add a master service
Repeat Steps 7, 8 and 9.
From the File menu of the main SQLEDIT menu bar, click Save to save this sql.ini file.

Check that you have the following information in your sql.ini file displayed in SQLEDIT:

In the Server Entry list, an entry for your SQL Anywhere database resembling:
sademo
From the Server Entry list, click on the name of your SQL Anywhere database:
sademo
In the Connection Server Entry list, a query service entry resembling:
query = NLWNSCK, MNGUYEN, 8000
In the Connection Server Entry list, a master service entry resembling:
master = NLWNSCK, MNGUYEN, 8000

To modify the `classpath` form field

The classpath field is the path to the Java class files for this sample as well as the path to the Starbuck Java class files. If you run this sample from Starbuck, Starbuck will copy the class files and this html file to your \Netscape\Server\docs\NJDBC_Lookup directory. From your HTML editor, modify the classpath field to point to the following directories

%Starbuck%\java\lib, where %Starbuck% is the directory where Starbuck is installed
\Netscape\Server\docs\NJDBC_Lookup directory

To modify the `host` form field

The host form field is the host name of your computer, not the Open Server Gateway name for the SQL Anywhere database. From your HTML editor, modify the host field to your machine name.

To modify the `port` form field

The host form field is the port number to connect to the SQL Anywhere database. From your HTML editor, modify the port field to the port number on your computer.

Client Side Instructions

To run this sample from Starbuck

Start the SQL Anywhere database by clicking on the Start button on your Windows desktop, choosing Run and then typing in the following command (or by typing in the following at the command line in a DOS box):
```
    dbeng50 db_name 
        where db_name is the path to your SQL Anywhere database

    For example: dbeng50 d:\sqlany50\sademo.db 
```

Start the Open Server Gateway for NT by typing in the following at the command line in a DOS box:

    dbos50 -v server_name
        where server_name is the Open Server Gateway name for your
        SQL Anywhere database. (The -v switch is for verbose mode.)

    For example: dbos50 -v sademo

Start the Netscape Enterprise Server
Start Starbuck
Open this sample project: IJDBC_Lookup.wxp
From the View menu of the main Starbuck menu bar, click Targets
In the Targets window, use the right button to click on NJDBC_LookUpWebApp. Then choose Run Options
On the General page, click Publish, then run a web browser
Click Configure and choose your Web browser
Click on the Initial URL for the browser box and type in the following URL:
```
    http://localhost/NJDBC_Lookup/NJDBC_Lookup.html 
```
Click OK
Click the Publish tab. On the Publish page, click Copy the files to a folder
Click in the Folder box and then type the path to your \Netscape\Server\docs\NJDBC_Lookup
```
    For example: d:\Netscape\Server\docs\NJDBC_Lookup\ 
```
Click OK to finish
To run this sample, from the Run menu of the main Starbuck menu bar, click Run
In the Default Program window, click on NJDBC_LookUpWebApp and click OK
Wait for your Web browser to load this file
In the Customer Information Submission Form, click on the First Name box and then type the first name of the customer whose information you want to retrieve.
In the Customer Information Submission Form, click on the Last Name box and then type the last name of the customer whose information you want to retrieve.
Click on View Customer to view the customer's information

Stop the Open Server Gateway for NT by typing in the following at the command line in a DOS box:

    dbosstop -S server_name -U userID -P password -x thx1138
        where server_name is the Open Server Gateway name for your 
                  SQL Anywhere database
              userID is the user Id for the SQL Anywhere database
              password is the password for the SQL Anywhere database

    For example: dbosstop -S sademo -U dba -P sql -x thx1138

To run this sample from outside Starbuck

Make sure that this html file and the class files for this project are copied to your \Netscape\Server\docs\NJDBC_Lookup directory. The class files for this project are located in %Starbuck%\samples\IJDBC_Lookup\Debug directory, where %Starbuck% is the directory where you installed Starbuck
Start the SQL Anywhere database by clicking on the Start button on your Windows desktop, choosing Run and then typing in the following command (or by typing in the following at the command line in a DOS box):
```
    dbeng50 db_name 
        where db_name is the path to your SQL Anywhere database

    For example: dbeng50 d:\sqlany50\sademo.db 
```

Start the Open Server Gateway for NT by typing in the following at the command line in a DOS box:

    dbos50 -v server_name
        where server_name is the Open Server Gateway name for your
        SQL Anywhere database. (The -v switch is for verbose mode.)
    
    For example: dbos50 -v sademo

Start the Netscape Enterprise Server

Start your Web browser and type in the following URL:

    http://localhost/NJDBC_Lookup/NJDBC_Lookup.html

In the Customer Information Submission Form, click on the First Name box and then type the first name of the customer whose information you want to retrieve.
In the Customer Information Submission Form, click on the Last Name box and then type the last name of the customer whose information you want to retrieve.
Click on View Customer to view the customer's information

Stop the Open Server Gateway for NT by typing in the following at the command line in a DOS box:

    dbosstop -S server_name -U userID -P password -x thx1138
        where server_name is the Open Server Gateway name for your
                  SQL Anywhere database
              userID is the user Id for the SQL Anywhere database
              password is the password for the SQL Anywhere database

    For example: dbosstop -S sademo -U dba -P sql -x thx1138

Sybase JDBC LookUp Sample

(with NSAPI on Netscape Enterprise Server)

Customer Information Submission Form using POST method

(Before submitting this form, you must modify the `classpath,` `host` `and` `port`fields. )

Customer Information Submission Form using GET method

(Before submitting this form, you must modify the `classpath,` `host` `and` `port`fields. )

Installation Instructions

Server Side Instructions

To configure the Netscape Enterprise Server

To configure the Open Server Gateway for a SQL Anywhere Database

To modify the `classpath` form field

To modify the `host` form field

To modify the `port` form field

Client Side Instructions

To run this sample from Starbuck

To run this sample from outside Starbuck

Sybase JDBC LookUp Sample

(with NSAPI on Netscape Enterprise Server)

Customer Information Submission Form using POST method

(Before submitting this form, you must modify the classpath, host and port fields. )

Customer Information Submission Form using GET method

(Before submitting this form, you must modify the classpath, host and port fields. )

Installation Instructions

Server Side Instructions

To configure the Netscape Enterprise Server

To configure the Open Server Gateway for a SQL Anywhere Database

To modify the classpath form field

To modify the host form field

To modify the port form field

Client Side Instructions

To run this sample from Starbuck

To run this sample from outside Starbuck

(Before submitting this form, you must modify the `classpath,` `host` `and` `port`fields. )

(Before submitting this form, you must modify the `classpath,` `host` `and` `port`fields. )

To modify the `classpath` form field

To modify the `host` form field

To modify the `port` form field