why sqlite exception returned?

Question

i don`t know what should i do about "not supported by PreparedStatment" exception.

my code is

connection = connectToDB();
        print("Connection Success");

        String sql = "Create Table test(id Integer primary key not null," +
                 "name Varchar(32)," +
                 "age Integer)";
        Statement statement = connection.createStatement();
        statement.execute(sql);
        print("Created Table");

        sql = "Insert into test Values(1, 'Mr.Maeda', 23)";
        statement.execute(sql);
        print("Inserted Data");

        ResultSet result;
        sql = "select * from test";
        PreparedStatement preStatement = connection.prepareStatement("select * from test where age = ?");
        preStatement.setString(1, "23");
        result = preStatement.executeQuery(sql);
        while(result.next()){
            print(result.getString(result.getRow()));               
        }

and I am using eclipse & java.

Where exactly are you getting the exception?

Thihara
– Thihara

2013-06-18 05:09:34 +00:00
Commented Jun 18, 2013 at 5:09 — Thihara
– Thihara, Commented Jun 18, 2013 at 5:09

Phil Goetz · Accepted Answer · 2013-07-13 19:26:24Z

1

Change

result = preStatement.executeQuery(sql);

to

result = preStatement.executeQuery();

PreparedStatement.executeQuery() doesn't take the query string as an argument because it's already prepared it.

answered Jul 13, 2013 at 19:26

Phil Goetz

6055 silver badges14 bronze badges

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

Comments

Juned Ahsan · Accepted Answer · 2013-06-18 05:07:55Z

0

You need to call executeUpdate() instead of execute while inseritng the records:

 sql = "Insert into test Values(1, 'Mr.Maeda', 23)";
 statement.executeUpdate(sql);

instead of

 sql = "Insert into test Values(1, 'Mr.Maeda', 23)";
 statement.execute(sql);

Difference between execute and executeUpdate:

boolean execute() Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement.

executeUpdate() Executes the SQL statement in this PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.

For more information read javadocs

answered Jun 18, 2013 at 5:07

Juned Ahsan

68.9k12 gold badges101 silver badges138 bronze badges

2 Comments

Eng.Fouad Over a year ago

I don't think this would solve the issue. I believe execute() will work as well for UPDATE.

AllTooSir Over a year ago

Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement.

Collectives™ on Stack Overflow

why sqlite exception returned?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related