error is "column cannot be inserted".........give send me the ans

DataInputStream dis; try { dis=new DataInputStream(System.in); System.out.println("enter no. of records to be inserted"); int nrec=Integer.parseInt(dis.readLine()); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:test","scott","tiger"); Statement st=con.createStatement(); for(int i=1;i<=nrec;i++) { System.out.println("pno");

         int pno=Integer.parseInt(dis.readLine());
          System.out.println("pname:");
          String pname=dis.readLine();
           System.out.println("page:");
           int page=Integer.parseInt(dis.readLine());
          String query="insert into person values("+pno+","+pname+","+page+")";
          st.executeUpdate(query);
          System.out.println("record inserted");
     }

st.close(); con.close(); } catch(Exception e) { System.out.println(e.getMessage()); }

} }

July 19, 2011 at 4:04 PM

Please visit the following link:

http://www.roseindia.net/tutorial/java/io/insertFileData.html

Above link will be helpful for you. Just change the driver you want to use.