Introduction to Fetching Data from an Oracle Database using Java and JDBC part 2
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 simple queries.
Read more »
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 how to process simple queries. The other two articles will look at the PreparedStatement and the CallableStatement.
Read more »
Connect to an Oracle TimesTen In-Memory Database using Java and JDBC
This document will detail establishing a connection to an Oracle TimesTen In-Memory Database using Java and JDBC.
Read more »
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 driver included with JDeveloper to a project.
Read more »
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 identification could be rather straight forward.
Many Oracle products that utilize JDBC connectivity store the JDBC driver used by the product in the ORACLE_PRODUCT_HOME/jdbc/lib directory and include a Readme.txt file that states the driver name. In some products this is not always the case.
Read more »
Database Startup and Shutdown through JDBC
Starting in 11gR1 you have the ability to stop and start the database through a JDBC connection.
Read more »