All Examples  This Package

Class examples.jdbc.oracle.exsql 

java.lang.Object
   |
   +----examples.jdbc.oracle.exsql
public class exsql
extends Object
This simple example shows how JDBC Extended SQL can be embedded in standard SQL sent to the DBMS. Extended SQL is part of the JDBC spec, and provides a DBMS-neutral way of using the many secondary functions that all DBMSes provide, but in a proprietary syntax. The WebLogic JDBC drivers will convert extended SQL syntax to the DBMS-specific syntax for the relevant function. Please see our documentation for links to the complete Extended SQL specification.

This example is run on the command line and is output to System.out.

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 Oracle configuration. If you need more help, check the section on connecting to a database in the Developers Guide, Using WebLogic jDriver for Oracle.

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

    $ javac -d %CLIENT_CLASSES% exsql.java

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

    $ java examples.jdbc.oracle.exsql

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

Constructor Index

o exsql()

Method Index

o main(String[])
In the main, we set properties for the connection, acquire a Connection object, and then create the Extended SQL and execute it in the Statement.

Constructors

o exsql 
 public exsql()

Methods

o main 
 public static void main(String argv[]) throws Exception
In the main, we set properties for the connection, acquire a Connection object, and then create the Extended SQL and execute it in the Statement. The Extended SQL we use here is an example of SQL that includes a few Extended SQL escapes. Note that an Extended SQL element is enclosed by {}. This example uses the function dayname, the function now(), and a date, time, and timestamp escape. Note that Extended SQL escapes can be nested. 

All Examples  This Package