Can not issue data manipulation statements with executeQuery() and StringTokenizer

Question

Hi I want to do something like that:

StringTokenizer tokenizer = new StringTokenizer(getCompletedAnswers, "$");
                while(tokenizer.hasMoreTokens()){

                    System.out.println(tokenizer.nextToken());
                    rs = st.executeQuery("INSERT INTO "+db+".answersTable(`answer`) VALUES ('"+tokenizer.nextToken()+"')");

                }

But it gives me an error Can not issue data manipulation statements with executeQuery().

As I read in documentation that I have to use executeUpdate() I'm doing it:

rs = st.executeUpdate("INSERT INTO "+db+".answersTable(`answer`) VALUES ('"+tokenizer.nextToken()+"')");

and it tells me: Type mismatch: cannot convert from int to ResultSet

Any idea how to use StringTokenizer to put those tokens into database ? thank you

Suraj Chandran · Accepted Answer · 2012-05-31 16:33:59Z

2

You should use Statement.executeUpdate instead

The executeUpdate method returns an int:

Returns: either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing

answered May 31, 2012 at 16:33

Suraj Chandran

24.9k12 gold badges67 silver badges96 bronze badges

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

5 Comments

takeit Over a year ago

ok it works but it only adds one token to database, if I have 2 tokens abc1 and abc2 read from tokenizer.nextToken() it adds only abc2, any idea why?

Suraj Chandran Over a year ago

The reason is that you cannot reuse a Statement (st). So initialize st inside the while loop instead of outside the while loop.

takeit Over a year ago

is what I did and still no result, same like it was before. I have used Statement st = null; and then st.executeUpdate("INSERT INTO "+db+".answersTable(answer) VALUES ('"+tokenizer.nextToken()+"')"); inside the while loop

takeit Over a year ago

ok problem has been solved, needed to assign tokenizer.nextToken() to string String str = tokenizer.nextToken();

Suraj Chandran Over a year ago

also my bad, the sql statement can actually be reused

Collectives™ on Stack Overflow

Can not issue data manipulation statements with executeQuery() and StringTokenizer

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related