Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

CHAPTER 3: Introduction to JDBC > Introducing JDBCUtil

Introducing JDBCUtil

JDBCUtil is a class I wrote that contains useful utility methods that you will add to as and when you learn different concepts in this book. In this chapter, you learned how to obtain a connection to a database and release resources associated with Connection, Statement, and ResultSet objects. These are ideal candidates for being incorporated in the JDBCUtil class for use in code written in later chapters.

I have put the JDBCUtil class in the package book.util. You can download this class from the Downloads area of the Apress website ( Let's look at the method getConnection() in this class, which takes as parameters a username, password, and database name (SID or service name):

  public static Connection getConnection( String username,
    String password, String dbName)
    throws SQLException
    OracleDataSource ods = null;
    Connection connection = null;
    ods = new OracleDataSource();
    // set the properties that define the connection
    ods.setDriverType ( "thin" );      // type of driver
    ods.setServerName ( "rmenon-lap" ); // database server name
    ods.setNetworkProtocol("tcp");     // tcp is the default anyway
    ods.setDatabaseName(dbName);     // Oracle SID
    ods.setPortNumber(1521);       // my 10g listener port number
    ods.setUser(username);           // username
    ods.setPassword(password);       // password
    System.out.println( "URL:" + ods.getURL());System.out.flush();
    connection = ods.getConnection();
    connection.setAutoCommit( false );
    return connection;


You are currently reading a PREVIEW of this book.


Get instant access to over $1 million worth of books and videos.


Start a Free 10-Day Trial

  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint