title: Connecting web app on Glassfish to an Oracle database
body: <p>I'm currently working on this dynamic web project. I have a database and table that I've created in Oracle. </p>
  
  <p>What I need to do right now is have this table connected to my project so that I can retrieve the data from there. </p>
  
  <p>I read that I will need a JDBC driver downloaded and I found it <a href="http://www.oracle.com/technetwork/database/features/jdbc/jdbc-ucp-122-3110062.html" rel="nofollow noreferrer">here</a></p>
  
  <p>But, it's not clear which one is the right one to download and where should I place it after that? in connection pool through admin console? </p>
  
  <p>all toturials I see are related to mySql even this one:</p>
  
  <pre><code>public void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
  
        // JDBC driver name and database URL
        static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";  
        static final String DB_URL="jdbc:mysql://localhost/TEST";
  
        //  Database credentials
        static final String USER = "root";
        static final String PASS = "password";
  </code></pre>
  
  <p>How can I use the same thing for oracle?</p>