CODEWITHSUNDEEP
javamysqljdbc
Prabu
Prabu

Reputation: 3728

mysql between and used via JDBC preparedstatement - getting Parameter index out of range exception

From the select query parameterized the value (date value with BETWEEN , AND)

my query

SELECT COUNT(*) AS assignedtotalcount FROM ticket, ticket_data
WHERE ticket.`ticket_id` = ticket_data.`ticket_id`
AND ticket.`created` BETWEEN '?' AND '?'

from the above query parameterized the values in BETWEEN , AND

Java code

static String dateFrom = "2018-01-01";
static String dateTo = "2018-01-31";
String query = reportQuery.toString();
statement = connection.createStatement();
preparedStatement = connection.prepareStatement(query);
preparedStatement.setString(1, dateFrom);
preparedStatement.setString(2, dateTo);
resultSet = preparedStatement.executeQuery(query);

while execute i am getting the below exception

java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).

please help me to resolved

Upvotes: 0

Views: 289

Answers (1)

Abdou Rayes
Abdou Rayes

Reputation: 430

Do not quote the placeholders. You need to change the '?' to ?.

So the query become like this 

SELECT COUNT(*) AS assignedtotalcount FROM ticket, ticket_data
WHERE ticket.`ticket_id` = ticket_data.`ticket_id`
AND ticket.`created` BETWEEN ? AND ?

Upvotes: 4

Related Questions