Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

java.sql.SQLException: Invalid column index

Go to solution
Former Member

on ‎2013 Dec 30 11:42 AM

4,925

Hello Experts,

I am developing one application on web dynpro java, here the users will enter data and the data will be stored in Oracle database, while saving the form i am having this exception:

java.sql.SQLException: Invalid column index

please help me out with this error

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
View Entire Topic
Former Member
‎2013 Dec 30 12:05 PM
0 Likes

the application have two tables. i will show them and while saving the form i am encountering one more error:

java.sql.SQLException: ORA-00913: too many values

the tables are:

insert into hsemonthly_report1(bgroup,bvertical,pvertical,site,months,years,key1,key2,key3,key4,key5,manhour1, manhour2,mh_total,ip_emp1,ip_emp2,ip_emp3,ip_emp4,ip_con1,ip_con2,ip_con3,ip_con4,ip_cases,ip_injured,ip_totalman,ip_totalcost,ht_topic,ht_train_mth,ht_manhrs_mth,ht_toolbox_mth,ht_hours_mth,ht_inducted_mth,ht_manhrs_ca,ht_toolbox_ca,ht_hours_ca,ht_inducted_ca,lc_govt_mo,lc_penalties_mo,lc_cause_mo,lc_other_mo,lc_govt_co,lc_penalties_co,lc_cause_co,lc_other_co,PK_VALUE,euser, incidence_performance1, incidence_performance2, lti_contractor, lti_total, ip_fy1, mdl_contractor, mdl_total, ip_fy2, fr_1, fr1_emp, fr2con, fr_emp, fr_con, fr, sr1_emp, sr2_con, sr_1, sr_emp, sr_con, sr, capa_closed, comment1  )" +
       " values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
    PreparedStatement pstat=null;
    pstat=conn.prepareStatement(queryinsert);
    pstat.setString(1,(ele.getBusiness_group()));
    pstat.setString(2,(ele.getProjectname()));
    pstat.setString(3,(ele.getProjectvertical()));
    pstat.setString(4,(ele.getSite()));
    pstat.setString(5,(ele.getMonth()));
    pstat.setString(6,(ele.getYear()));
    pstat.setString(7,(key.getK1()));
    pstat.setString(8,(key.getK2()));
    pstat.setString(9,(key.getK3()));
    pstat.setString(10,(key.getK4()));
    pstat.setString(11,(key.getK5()));
    pstat.setFloat(12,(ele.getManhour1()));
    pstat.setFloat(13,(ele.getManhour2()));
    pstat.setFloat(14,(ele.getMH_Total()));
    pstat.setInt(15,(inc.getEmp_m1()));
    pstat.setInt(16,(inc.getEmp_m2()));
    pstat.setInt(17,(inc.getEmp_m3()));
    pstat.setInt(18,(inc.getEmp_m4()));
    pstat.setInt(19,(inc.getCon_m1()));
    pstat.setInt(20,(inc.getCon_m2()));
    pstat.setInt(21,(inc.getCon_m3()));
    pstat.setInt(22,(inc.getCon_m4()));
    pstat.setInt(23,(inc.getM1()));
    pstat.setInt(24,(inc.getM2()));
    pstat.setInt(25,(inc.getM3()));
    pstat.setInt(26,(inc.getM4()));
    pstat.setString(27,(tra.getTopic()));
    pstat.setInt(28,(tra.getM1()));
    pstat.setInt(29,(tra.getM2()));
    pstat.setInt(30,(tra.getM3()));
    pstat.setInt(31,(tra.getM4()));
    pstat.setInt(32,(tra.getM5()));
    pstat.setString(33,(tra.getC1()));
    pstat.setString(34,(tra.getC2()));
    pstat.setString(35,(tra.getC3()));
    pstat.setString(36,(tra.getC4()));
    pstat.setInt(37,(leg.getM1()));
    pstat.setInt(38,(leg.getM2()));
    pstat.setInt(39,(leg.getM3()));
    pstat.setInt(40,(leg.getM4()));
    pstat.setString(41,(leg.getC1()));
    pstat.setString(42,(leg.getC2()));
    pstat.setString(43,(leg.getC3()));
    pstat.setString(44,(leg.getC4()));
    pstat.setString(45,pk);
    pstat.setString(46,euser);
    pstat.setFloat(47,(ele.getIncident_performance1()));
    pstat.setFloat(48,(ele.getIncident_performance2()));
    pstat.setFloat(49,(ele.getLti_contractor()));
    pstat.setFloat(50,(ele.getLti_total()));
    pstat.setFloat(51,(ele.getIp_fy1()));
    pstat.setFloat(52,(ele.getIp_fy2()));
    pstat.setFloat(53,(ele.getMdl_contractor()));
    pstat.setFloat(54,(ele.getMdl_total()));
    pstat.setFloat(55,(ele.getFr_1()));
    pstat.setFloat(56,(ele.getFr1_emp()));
    pstat.setFloat(57,(ele.getFr2con()));
    pstat.setFloat(58,(ele.getFr_emp()));
    pstat.setFloat(59,(ele.getFr_con()));
    pstat.setFloat(60,(ele.getFr()));
    pstat.setFloat(61,(ele.getSr1_emp()));
    pstat.setFloat(62,(ele.getSr2_con()));
    pstat.setFloat(63,(ele.getSr_1()));
    pstat.setFloat(64,(ele.getSr_emp()));
    pstat.setFloat(65,(ele.getSr_con()));
    pstat.setFloat(66,(ele.getSr()));
    pstat.setFloat(67,(ele.getCapa_closed()));
    pstat.setString(68,(inc.getComment1()));
   
    a=pstat.executeUpdate();


"insert into hsemonthly_report2(bgroup,bvertical,pvertical,site,months,years,ia_inspections_mo, ia_audits_mo, ia_layer1, ia_stake_mo, ia_other_mo, ia_extagencies, ia_obs_closed_mo, ia_obs_open_mo, ia_HSEsteering,ia_inspections_co, ia_audits_co, ia_layer_co, ia_stake_co, ia_other_co, ia_extagencies_co, ia_obs_co,  ia_HSEsteering_co, oh_examination, oh_health, oh_other, plan_m, erp_hydrant, eme_year1, eme_year2, env_energy, env_fuels, env_consumed, env_nonhazadous, env_hazardous, env_release, env_spillage, env_programmes, env_other, Con_m, Per_m, Con_y, Per_y)" +
        
        " values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
              PreparedStatement pstat1=null;
              pstat1=conn.prepareStatement(queryinsert1);
              pstat1.setString(1,(ele.getBusiness_group()));
              pstat1.setString(2,(ele.getProjectname()));
              pstat1.setString(3,(ele.getProjectvertical()));
              pstat1.setString(4,(ele.getSite()));
              pstat1.setString(5,(ele.getMonth()));
              pstat1.setString(6,(ele.getYear()));

              pstat1.setInt(7,(ins.getM1()));
              pstat1.setInt(8,(ins.getM2()));
              pstat1.setFloat(9,(ins.getM3()));
              pstat1.setInt(10,(ins.getM4()));
              pstat1.setInt(11,(ins.getM5()));
              pstat1.setFloat(12,(ins.getM6()));
              pstat1.setInt(13,(ins.getM3c1()));
              pstat1.setInt(14,(ins.getM3o1()));
              pstat1.setFloat(15,(ins.getM7()));
              pstat1.setString(16,(ins.getC1()));
              pstat1.setString(17,(ins.getC2()));
              pstat1.setString(18,(ins.getC3()));
              pstat1.setString(19,(ins.getC4()));
              pstat1.setString(20,(ins.getC5()));
              pstat1.setString(21,(ins.getC6()));
              pstat1.setString(22,(ins.getC7()));
              pstat1.setString(23,(ins.getC8()));

              pstat1.setInt(24,(occ.getM1()));
              pstat1.setInt(25,(occ.getM2()));
              pstat1.setString(26,(occ.getM3()));
     
              pstat1.setString(27,(eme.getM1()));
              pstat1.setInt(28,(eme.getM2()));
              pstat1.setString(29,(eme.getYear1()));
              pstat1.setString(30,(eme.getYear2()));
              pstat1.setInt(31,(eme.getM3()));
              pstat1.setInt(32,(eme.getM4()));
              pstat1.setInt(33,(eme.getM5()));
              pstat1.setInt(34,(eme.getM6()));
              pstat1.setString(35,(eme.getM7()));
     
              pstat1.setInt(36,(env.getM1()));
              pstat1.setInt(37,(env.getM2()));
              pstat1.setInt(38,(env.getM3()));
              pstat1.setInt(39,(env.getM4()));
              pstat1.setInt(40,(env.getM5()));
              pstat1.setInt(41,(env.getM6()));
              pstat1.setInt(42,(env.getM7()));
              pstat1.setString(43,(env.getM8()));
              pstat1.setString(44,(env.getM9()));
     
              pstat1.setString(45,(ele.getCon_m()));
              pstat1.setString(46,(ele.getCon_y()));
              pstat1.setString(47,(ele.getPer_m()));
              pstat1.setString(48,(ele.getPer_y()));
              pstat1.setString(49,(ele.getAnyother()));
              pstat1.setString(50,pk);
      
             b=pstat1.executeUpdate();

please help me out

Show replies
Show replies
Former Member
‎2013 Dec 30 12:15 PM
0 Likes

Please see the following links

ORA-00913: too many values tips

Oracle/PLSQL: ORA-00913 Error

Thanks

Rishi

Former Member
‎2013 Dec 30 3:29 PM
0 Likes

Check the "," value has inside of your data provided into the sql statement

Ask a Question