Databases
StackOverflow2013
Postsdbo
POerror after inserting few rows in database using java program
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POerror after inserting few rows in database using java program
    primarykey
    data
    text
    <p>I am trying to insert values from one server to another using java program. Here is my code:-</p> <pre><code>public static void main(String[] args) throws FileNotFoundException { // TODO code application logic here try { Class.forName("oracle.jdbc.OracleDriver"); } catch (Exception exception) { } Connection conn = null; Connection conn1 = null; ResultSet rs, rs1 = null; Statement pst = null; try { // dbConnect.executequery(sdate, edate); conn = DriverManager.getConnection("jdbc:oracle:thin:@31.4.224.76:1521:RPTPSG", "pihist", "pihist"); String query = "select * from messagemasterhistory where ROWNUM&lt;=1572660"; // String query="select * from messagemasterhistory where createdate&gt;='28-JAN-11' and createdate&lt;='18-FEB-2011'"; pst = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY); // String sql="insert into test(SRN ,UTR) values ("; // pst=conn.prepareStatement(sql); // rs.absolute(2000); // pst.setFetchSize(2000); // pst.setMaxRows(1500000); pst.setFetchDirection(ResultSet.FETCH_FORWARD); rs = pst.executeQuery(query); // String statment="insert into test(UTR,SRN) values('abc','1')"; // PrintWriter wt=new PrintWriter("ritima2.txt"); conn1 = DriverManager.getConnection("jdbc:oracle:thin:@31.4.224.81:1521:RPTPSG", "rptr", "rptr"); Statement stat1 = conn1.createStatement(); while (rs.next()) { String str = rs.getString("FIELDDATA"); String str1 = rs.getString("FIELDINFO"); String statment = "insert into MESSAGEMASTERHISTORY2(UTR,CREATEDATE,SENDER,RECEIVER,SUBMESSAGETYPE,FIELDINFO,FIELDDATA,DUPLICATE) values(" + "'" + rs.getString("UTR") + "'" + "," + "TO_DATE('" + rs.getDate("CREATEDATE") + "'" + ",'YYYY-MM-DD\" \"HH24:MI:SS')" + "," + "'" + rs.getString("SENDER") + "'" + "," + "'" + rs.getString("RECEIVER") + "'" + "," + "'" + rs.getString("SUBMESSAGETYPE") + "'" + "," + "'" + str1 + "'" + "," + "'" + str + "'" + "," + rs.getInt("DUPLICATE") + ")"; // String statment="insert into test1 (fielddata,utr) values("+"'"+(rs.getString("fielddata"))+"'"+","+"'"+rs.getString("UTR")+"')"; System.out.println(count); stat1.executeQuery(statment); System.out.println(str); System.out.println(str1); // System.out.println(rs.getClob("FIELDDATA")); System.gc(); count++; } conn1.commit(); conn1.close(); // wt.close(); System.out.println("Completed"); conn.close(); } catch (Exception e) { e.printStackTrace(); } } } </code></pre> <p>After inserting few rows (6274) it gives error"java.sql.SQLException: ORA-00917: missing comma</p> <pre><code> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:963) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1192) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1315) at javaapplication2.Main.main(Main.java:73) </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDT7
    1. USuser1907534
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POerror after inserting few rows in database using java program
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POerror after inserting few rows in database using java program
      1. This table or related slice is empty.
      1. VTDownMod
    1. COWhich line of code is `Main.java:73`?
      singulars
      1. POerror after inserting few rows in database using java program
      1. USHovercraft Full Of Eels
    2. COThe program does not look good. It is ignoring all the best practices in the world. Create the prepared statement with place holders(bind variables), set the values and add that to batch by calling pstmt.addBatch and finally say pstmt.execute().
      singulars
      1. POerror after inserting few rows in database using java program
      1. USAbhijith Nagarajan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload