We import java.io to be able to read from the command line
You need to import the java.sql and JDBC packages to use JDBC * Just run it and provide the connect information.
* This sample can be used to check the JDBC installation. The JdbcCheckup.java program, which uses the JDBC OCI driver, is as follows: /* Imports the necessary Java classes, including JDBC classes If the results of the query print without error, then your Java and JDBC installations are correct.Īlthough JdbcCheckup.java is a simple program, it demonstrates several important functions by performing the following: Traverse to the samples directory, and compile and run JdbcCheckup.java. The program connects to the database, queries for the string " Hello World", and prints it to the screen. The program queries for the user name, password, and the name of the database to which you want to connect. One of the programs, JdbcCheckup.java, is designed to test JDBC and the database connection.
The samples directory contains sample programs for a particular Oracle JDBC driver. These are only required if you are using JTA features for distributed transaction management or JNDI features for naming services.Ģ.2.5 Testing JDBC and the Database Connection These files contain classes for the Java Transaction API (JTA) and the Java Naming and Directory Interface (JNDI) for JDK 1.2.x, 1.3.x, and 1.4. This file contains late-breaking and release-specific information about the drivers, which may not have been included in other documentation on the product.Ĭheck whether the following directories have been created and populated in the ORACLE_HOME /jlib directory: The lib directory contains the following required Java classes:Ĭontains classes for globalization and multibyte character sets supportĬontain the JDBC driver classes for use with JDK releases after 1.2 and before 1.4Ĭontain the JDBC driver classes for use with JDK 1.4 This directory contains the javadoc.zip file, which is the Oracle JDBC application programming interface (API) documentation.
The samples directory contains sample programs, including examples of how to use SQL92 and Oracle SQL syntax, PL/SQL blocks, streams, user-defined types, additional Oracle type extensions, and Oracle performance extensions. When you uncompress this compressed file, the samples directory and the Samples-Readme.txt file is created. This directory contains a compressed file, demo.zip or demo.tar. Installing the Oracle Java products creates, among other things, the following directories:Ĭheck whether the following directories have been created and populated in the ORACLE_HOME /jdbc directory: 2.2.1 Checking Installed Directories and Files
0 kommentar(er)
