Basic SQLJ Samples
SQLJ allows programmers to intersperse SQL code in Java
programmes. This enables speedy development and eases database
access from Java code. The SQLJ Basic Samples demonstrate the
usage of various features introduced in JDBC 1.0 specification
defined by Sun Microsystems. SQLJ helps in developing database
applications in a faster and concise manner. All the samples have also been certified on Red Hat Linux Advanced Server 2.1 
Accessing PL/SQL Stored Procedures
[04-Apr-2003]
This sample application demonstrates how
to invoke PLSQL Stored Procedures from the database using SQLJ.
Oracle JDBC drivers support execution of PL/SQL stored procedures
from java applications.
Download
Now (JAR, 23KB)
Readme
Source
Date Datatype [04-Apr-2003]
The application shows
how to access the DATE datatype columns from a Oracle database using
SQLJ.
Download
Now (JAR, 21KB)
Readme
Source
Data Manipulation [04-Apr-2003]
This sample application demonstrates how
to perform basic SQL operations like SELECT, INSERT, UPDATE, and
DELETE from a java application using SQLJ.
Download
Now (JAR, 25KB)
Readme
Source
Refcursor Sample [04-Apr-2003]
This sample application demonstrates how
to retrieve and process a REFCURSOR from a java application using
SQLJ. The sample creates a PLSQL Function that returns a REFCURSOR.
This PLSQL Function is invoked from the application and the REFCURSOR
returned by the function is processed using JDBC APIs.
Download
Now (JAR, 24KB)
Readme
Source
Rowid Sample [04-Apr-2003]
This sample application
illustrates how to access rows in a database table through its ROWID
from a java application. ROWIDs can be accessed either as a string,
or as a oracle.sql.ROWID type using the SQLJ.
Download
Now (JAR, 25KB)
Readme
Source
Long Datatype [04-Apr-2003]
This application shows how to perform the
data manipulation on a LONG column of a database table from a java
application using SQLJ. To access the data in a LONG column, you
can get the column as a java InputStream and use the read() method
of the InputStream object.
Download
Now (JAR, 31KB)
Readme
Source
LongRaw Datatype [04-Apr-2003]
This sample application demonstrates how
to perform the data manipulation on a LONGRAW column of a database
table from a java application using SQLJ.
Download
Now (JAR, 32KB)
Readme
Source
Varchar2 and Char Datatypes [04-Apr-2003]
This sample application demonstrates how
to access Varchar2 and Char columns of a database table using SQLJ.
Download
Now (JAR, 24KB)
Readme
Source
|