I' m getting error in java.sql.BatchUpdateException: ORA-00917: missing comma

Question

                            //  Statement stmt=con.createStatement();
 String SQL = "insert into JMX(MAXThreads number(10),currentThreadCount number(10),MaxkeepAliveRequest number(10),threadPriority number(10), maxTime number(10),requestCount number(10),bytesReceived number(10),bytesSent number(10),processingTime number(10),modelerType varchar2(50) ,errorCount number(10)) values (?,?,?,?,?,?,?,?,?,?,?)";
 
 
 
                                try (PreparedStatement pst=con.prepareStatement(SQL)) {
                                    pst.setObject(1,  memoryMbean);
                                    pst.setObject(2,  osMbean);
                                    pst.setObject(3,  tmMbean);
                                    pst.setObject(4,  smMbean);
                                    pst.setObject(5,  grpMbean);
                                    pst.setObject(6,  grpMbean1);
                                    pst.setObject(7,  grpMbean2);
                                    pst.setObject(8,  grpMbean3);
                                    pst.setObject(9,  grpMbean4);
                                    pst.setObject(10,  grpMbean5);
                                    pst.setObject(11,  grpMbean6);
                                    
                                    pst.addBatch();

                                    pst.setObject(1,  memoryMbean);
                                    pst.setObject(2,  osMbean);
                                    pst.setObject(3,  tmMbean);
                                    pst.setObject(4,  smMbean);
                                    pst.setObject(5,  grpMbean);
                                    pst.setObject(6,  grpMbean1);
                                    pst.setObject(7,  grpMbean2);
                                    pst.setObject(8,  grpMbean3);
                                    pst.setObject(9,  grpMbean4);
                                    pst.setObject(10,  grpMbean5);
                                    pst.setObject(11,  grpMbean6);
                                    pst.executeBatch();
                                    con.commit();

                                   // JOptionPane.showMessageDialog(null,"Done");

                                } catch (SQLException e) {
                                    e.printStackTrace();
                                }

This is my output im getting: START java.sql.BatchUpdateException: ORA-00917: missing comma

PROCESS COMPLETED at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:9711) at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1447) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9487) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:237) at com.jmx.Connection2.waitMethod(Connection2.java:304) at com.jmx.Connection2.main(Connection2.java:173)

Ori Marko · Accepted Answer · 2020-09-08 10:20:12Z

1

You don't need to specify the types, remove the columns types:

"insert into JMX(MAXThreads , currentThreadCount , MaxkeepAliveRequest 
, threadPriority , maxTime , requestCount , bytesReceived , bytesSent 
, processingTime , modelerType , errorCount ) values (?,?,?,?,?,?,?,?,?,?,?)";

Also why are you setting values again (duplicate) after addBatch?

answered Sep 8, 2020 at 10:20

Ori Marko

59.3k26 gold badges158 silver badges259 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

I' m getting error in java.sql.BatchUpdateException: ORA-00917: missing comma

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related