Facing problem with startWith() in for loop

[Happy S Singh]

Below is my snippet where I want to check in loop for all the queries passed that whether it starts with "SELECT" But I get the first query as true despite other queries are select

String query="select * from tab1;select * from tab2"
String query1=query.toUpperCase();
String[] results = query1.split(";");
for (int i = 0; i < results.length; i++) {
System.out.println("Starts with..." + results[i]);
 if(results[i].startsWith("SELECT")) {
//code
}
}

I get true in if(results[i].startsWith("SELECT")) only for the first select and after that for all other select's I get false

[Nicola Garofalo]

I tried it and it works...

[Happy S Singh]

yeah its working.but now I am stuck with other exception "java.sql.SQLException: error occurred during batching: batch must be either executed or cleared"

I am getting "java.sql.SQLException: error occurred during batching: batch must be either executed or cleared" in the below code.I want to execute two queries.

String query1 = sql_query.toUpperCase();
			System.out.println("QUERY:::::::::" + query1);
			String[] results = query1.split(";");
			CSVWriter writer = new CSVWriter(new FileWriter(csv_file_path
					+ csv_file_name), ',', CSVWriter.NO_QUOTE_CHARACTER);
			stmt = conn1.createStatement();
			conn1.setAutoCommit(false); 
			//stop();
			for (int i = 0; i < results.length; i++) {

				System.out.println("Starts with..." + results[i]);
				System.out.println("Starts with select...11"
				    + results[i].startsWith("SELECT"));
				 if(results[i].startsWith("SELECT")) {
			
				rs1 = stmt.executeQuery(results[i]);

				writer.writeAll(rs1, true);// writing to csv file
				 }
				 else if(results[i].startsWith("INSERT")){
					 stmt.addBatch(results[i]);
				 }
				 

			}
			writer.close();
			 int [] updateCounts = stmt.executeBatch();
			conn1.commit(); 
			if (rs1 != null)
				rs1.close();
			if (stmt != null)
				stmt.close();
			if (conn1 != null)
				conn1.close();

[Winston Gutkowski]

Happy S Singh wrote:in the below code....

Happy,

I split the very long line in your code. Please re-read the UseCodeTags page.

Winston

[Nicola Garofalo]

Probably you can't, within the same Statement, execute select queries and batch updates.