No data in combobox while retrieving from database

Question

<select name="qualification">
   <%
     Connection con=null;
     Statement st=null;
     ResultSet res;
     try{
       Class.forName("oracle.jdbc.driver.OracleDriver");
       con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:XE","system","123");
       st=con.createStatement();
       res=st.executeQuery("select qualification from course");
       while(res.next()){
         String qualification = res.getString("qualification");
  %>
      <option value="<%=qualification%>"><%=qualification%></option>
  <%
      }
    }catch(Exception e)
    {    out.print(e);
    }
 %>

</select>

Here I am trying to display values in the combox box, but the combobox shows empty in the output! My db table has just two fields, name and qualification with enough values.

Are there any error messages in the server logs (tomcat or whatever?) — Axel Amthor, Dec 30 '15 at 16:43
No error ! Code works fine..but the comboxbox is yet empty. Table has enough values to be displayed. — TrueDroider, Dec 30 '15 at 16:48
did you check the html code rendered (view source, inspect element)? — Axel Amthor, Dec 30 '15 at 16:52
Oh..it shows classNotFoundException though everything is been set up correctly ! — TrueDroider, Dec 30 '15 at 17:00
It can't. You can't argue with a `classNotFoundException`. What class is not found (My guess: Oracle driver) — Axel Amthor, Dec 30 '15 at 17:01
Yes Exception occurred : java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver — TrueDroider, Dec 30 '15 at 17:03
have a look here (besides original oracle docs): http://stackoverflow.com/questions/17701610/cannot-find-or-load-oracle-jdbc-driver-oracledriver — Axel Amthor, Dec 30 '15 at 17:23

score 0 · Answer 1 · answered Jan 02 '16 at 08:36

Your code

 }catch(Exception e)
{    out.print(e);
}

Outputs the error into your html where it's hard to find. Consider logging full stacktrace into server-log as well

 }catch(Exception e) {    
   e.printStackTrace ();
   out.print(e);
 }

As you mentioned in comment you see a class not found for the oracle driver - make sure to add ojdbc6.jar (or ojdbc7.jar) into your WEB-INF/lib or into your tomcat/lib folder (or similar depending on your servlet engine)

No data in combobox while retrieving from database

1 Answers1