![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e235. Connecting to an Oracle DatabaseThis example uses an Oracle JDBC driver to connect to an Oracle database instance located at128.0.0.0:1521 with an sid called
mydatabase .
Connection connection = null; try { // Load the JDBC driver String driverName = "oracle.jdbc.driver.OracleDriver"; Class.forName(driverName); // Create a connection to the database String serverName = "127.0.0.1"; String portNumber = "1521"; String sid = "mydatabase"; String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid; String username = "username"; String password = "password"; connection = DriverManager.getConnection(url, username, password); } catch (ClassNotFoundException e) { // Could not find the database driver } catch (SQLException e) { // Could not connect to the database }
e237. Connecting to a SQLServer Database e238. Listing All Available Parameters for Creating a JDBC Connection e239. Determining If a Database Supports Transactions e240. Committing and Rolling Back Updates to a Database e241. Handling a SQL Exception e242. Determining If a SQL Warning Occurred e243. Getting the Driver of a Connection e244. Setting the Number of Rows to Prefetch When Executing a SQL Query © 2002 Addison-Wesley. |