Manish Kapasiya

package javax.servlet.* does not exist.
package javax.servlet.servlet.http.* does not exist.

Sir Martin,
I have used Resultset.TYPE_SCROLL_INSENSITIVE rather... Don't be confused with my early code posted because I typed it mistakenly.... It's my mistake.....

sir i am a student and preparing for ocpjp 1.7 and the topic is on the course that's why i am doing that way (updatable resultset).

Thanks Mr. Armitage.
problem is solved.
can you tell me why it is necessary to give specific coloumn names?
the link you provided is not clearing my doubt.

i have resolved the problem....
now i added the required jar files in the ext folder for extension class loader to locate... no need to set User environment variable.

package database.example1; import java.sql.*; abstract class DBConnector{ public static Connection getDbCon()throws SQLException,ClassNotFoundException{ Class.forName("oracle.jdbc.driver.OracleDriver"); String url="jdbc:oracle:thin:@localhost:1521:"; String database="xe"; String userName="system"; String password="manish"; return DriverManager.getConnection(url+database,userName,password); } } public class DbQuery{ public static void main(String[] args)throws SQLException{ Connection con=null; Statement st=null; ResultSet rs=null; ResultSetMetaData rsmd=null; try{ con=DBConnector.getDbCon(); st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE ); rs=st.executeQuery("Select * from contact where firstName='Manish'"); rsmd=rs.getMetaData(); int columnCount=rsmd.getColumnCount(); System.out.println("******* Before Update*******\n\n"); for(int j=1;j<=columnCount;j++){ if(j==4){ System.out.print(rsmd.getColumnName(j)+"\t\t"); } else{ System.out.print(rsmd.getColumnName(j)+"\t"); } } while(rs.next()){ System.out.println(); System.out.print(rs.getObject(1)+"\t"); System.out.print(rs.getObject(2)+"\t"); System.out.print(rs.getObject(3)+"\t"); System.out.print(rs.getObject(4)+"\t"); System.out.print(rs.getObject(5)+"\t"); } System.out.println("\n\n\n\n*******After Update*******\n\n"); rs.absolute(1);//for moving the cursor to point to the first row in the result set rs.updateString(5,"9999655832");//for updating the contents of the current row in the result set rs.updateRow();// for reflecting changes in the database rs.beforeFirst(); for(int j=1;j<=columnCount;j++){ if(j==4){ System.out.print(rsmd.getColumnName(j)+"\t\t"); } else{ System.out.print(rsmd.getColumnName(j)+"\t"); } } while(rs.next()){ System.out.println(); System.out.print(rs.getObject(1)+"\t"); System.out.print(rs.getObject(2)+"\t"); System.out.print(rs.getObject(3)+"\t"); System.out.print(rs.getObject(4)+"\t"); System.out.print(rs.getObject(5)+"\t"); } }catch(SQLException sq){ sq.printStackTrace(); } catch(ClassNotFoundException cnfe){ } finally{ rs.close(); st.close(); con.close(); } } }

getting java.sql.SQLEception: Invalid operation for read only result set..

Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at DataBase.CustData..main(CustData.java)

i am getting this exception..


what is the reason of getting this error and how can i resolve it.

please tell about some books for ocpjp 1.7 prepration.

Passed OCAJP 7 with 88% on this friday 28-06-2014.

Study Material:-

K&B
Mala Gupta
Enthuware Mock Tests....

Thank you coderanchers, your suggestions help me a lot.

I am OCAJP 7 certified. Am i eligible for WEB Component Development with Servlet And JSP Java EE 6

Public void init()
{
ServletContext ctx=getServletContext();
}
Servlet context is one per web app.
Container makes a servlet context object when the web app is deployed on to the server... This object reference is provided throughout the web app using a method getServletContext()..
When container calls init(ServletConfig) the servlet context object is already there for you to use in your overloaded version init().....