In this three part series of posts we will look at fetching data from an Oracle Database using Java and JDBC. In this second post we look at the PreparedStatement interface and how to process […]
Introduction to Fetching Data from an Oracle Database using Java and JDBC part 1
In this three part series of posts we will look at fetching data from an Oracle Database using Java and JDBC. In this first post we look at the basics of the Statement interface and […]
java.sql.SQLException: Problems with loading native library/missing methods: no ttJdbc1121 in java.library.path
When trying to execute a Java program that connects to remote Oracle TimesTen database you receive the following stack trace.
Adding the Oracle JDBC Drivers to a JDeveloper 11gR1 Project
Nearly all of the Java examples presented on Oracle Distilled are developed and tested in Oracle JDeveloper with the exception of those documents targeting Netbeans. This document will detail how to add the Oracle JDBC […]
Connect to an Oracle Database using Java and JDBC
This document will detail establishing a connection to an Oracle Database using Java and JDBC. Errors that could arise in making JDBC connections will be examined at the end of the document.
Determine JDBC Driver Version
You may be required to determine the version of a JDBC driver used to connect to your Oracle Database. In cases were the JDBC driver used is the one included with Oracle Client or Database […]
Database Startup and Shutdown through JDBC
Starting in 11gR1 you have the ability to stop and start the database through a JDBC connection.