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

 
Left Curve
More Sample Code
Right Curve
 · Advanced SQLJ Samples
 · Oracle 9i SQLJ Samples
 · JDBC Samples

Left Curve
Discussions
Right Curve
 · Sample Code Forum
 · SQLJ/JDBC
 · Java Stored Procedures

Left Curve
Tutorials
Right Curve
 · JDBC Developer's Guide
 · SQLJ Developer's Guide
 · Oracle Java Roadmap : JDBC

Left Curve
How-To Documents
Right Curve
 · JDBC
 · Java Stored Procedures
 · J2EE
 · JavaServer Pages
 · JMS
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy