hello one and all,
here is the code....
String scn=bcrc_scno.getText();
int prn=Integer.parseInt(bcrc_prno.getText());
int mamt=Integer.parseInt(bcrc_misamt.getText());
int recon=Integer.parseInt(bcrc_reconchg.getText());
String brn=bcrc_brno.getText();
String ptr=bcrc_ptrdt.getText();
String mamtcd=bcrc_misamtcd.getText();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("Jdbc
dbc:venkat","scott"," tiger");
con.setAutoCommit(false);
Statement stmt = con.createStatement();
System.out.println("connection established......XXXXXXXXXXX");
/* columns in the table payment1 ptscno,ptprno,ptmisamt,ptreconchg,ptbcrno,ptprdt,ptmisamtcd */
stmt.executeUpdate("insert into payment1(ptscno,ptprno,ptmisamt,ptreconchg,ptbcrno,ptprdt,ptmisamtcd) values (scn,prn,mamt,recon,brn,ptr,mamtcd)");
con.commit();
con.setAutoCommit(true);
con.close();
}catch(SQLException p){
System.out.println("sorry failed"+p);
p.printStackTrace();
}catch(Exception e){
System.out.print(e);
}
after executing this i am getting column not allowed oracle error
-----------
i have taken the data from a textfield.
please help me
thanq in advance
stalin.