All Examples  This Package

Class examples.jdbc.t3client.storedprocs1

java.lang.Object
   |
   +----examples.jdbc.t3client.storedprocs1

public class storedprocs1
extends Object
This example demonstrates the syntax and usage for Microsoft SQL Server stored procedures and functions and requires that you have the WebLogic Type 4 SQL Server driver, jdbcKona/MSSQLServer4 installed on your system. This driver is available separately from BEA Systems. The code shows how to create and call stored procedures and how to register parameters.

To set up this example:

  1. Set up your development shell as described in Setting up your environment.

  2. Change connection parameters to correspond to your database configuration. If you need more help, check the section on connecting to a database in the Developers Guide, Using jdbcKona/MSSQLServer4.

  3. Compile the example by executing the following command in your development shell:

    $ javac -d %CLIENT_CLASSES% storedprocs1.java

  4. Start WebLogic Server in a separate shell. Be sure to place the classes for the jdbcKona/MSSQLServer4 JDBC driver in the weblogic.class.path when you start WebLogic Server.

  5. Run this example by executing the following command in your development shell:

    $ java examples.jdbc.t3client.storedprocs1

Author:
Copyright (c) 1996-1999 by BEA Systems, Inc. All Rights Reserved.

Constructor Index

 o storedprocs1()

Method Index

 o main(String[])
Runs this example from the command line.

Constructors

 o storedprocs1
 public storedprocs1()

Methods

 o main
 public static void main(String[] argv) throws Exception
Runs this example from the command line.

All Examples  This Package