Java MYSQL Exception in executeQuery()

Question

I get a Java MySQL exception

@Override

public ResultSet executeQuery (String query, ArrayList<Argument> arguments) throws SQLException
{
    final PreparedStatement pstmt = getPstmt(query, arguments);
    final ResultSet retrievedData = pstmt.executeQuery();
    return retrievedData;
}




//getpstmt()

private PreparedStatement getPstmt (String query, ArrayList<Argument> arguments) throws SQLException
    {
        PreparedStatement pstmt = null;
        try {
            pstmt = connection.prepareStatement(query);

            if (arguments != null) {
                int argPosition = 1;
                for (final Argument arg : arguments) {
                    if (arg.getType() == ARGUMENT_TYPE.INTEGER) {
                        pstmt.setInt(argPosition++, arg.getInt());
                    }
                    else {
                        pstmt.setString(argPosition++, arg.getString());
                    }
                }
            }
        }
        catch (final Exception ex) {
            NmsLogger.writeDebugLog(ex);
            return null;
        }

        return pstmt;

    }



// One instance of calling executeQuery

public String getProperty(String propertyName) 
    {

        try 
        {
            ArrayList<Argument> arguments = new ArrayList<Argument>();
            arguments.add(new Argument(propertyName));

            final java.sql.ResultSet resultset = Application.getDBHandler().executeQuery(SQLQueries.GET_PROPERTY, null);
            Application.getDBHandler().executeQuery(SQLQueries.GET_PROPERTY, arguments);
            if(resultset.next())
            {
                resultset.getString(1);

            }
            return resultset.toString();
        }
        catch (SQLException e)
        {
            NmsLogger.writeDebugLog(e);
            e.printStackTrace();
        }

        return null;
    }

I get the following error when I debug the following code :

java.sql.SQLException: No value specified for parameter 1

Someone do suggest a way to solve..Why I get such an exception?

@JohnTotetWoo I have edited the question.. Hope u get it now. — Gapchoos
– Gapchoos, Commented Aug 10, 2012 at 4:51
Can you add a breakpoint at for (final Argument arg : arguments) { and see if arguments is empty? — Bhesh Gurung
– Bhesh Gurung, Commented Aug 10, 2012 at 4:54
GET_PROPERTY is an example query. public static final String GET_PROPERTY = "Select * from app_config where Property = ? "; — Gapchoos
– Gapchoos, Commented Aug 10, 2012 at 5:02

Luiggi Mendoza · Accepted Answer · 2012-08-10 05:12:42Z

3

You're passing null to executeQuery instead of list of arguments here:

Application.getDBHandler().executeQuery(SQLQueries.GET_PROPERTY, null);

So, the no value in the place of ? in the query "Select * from app_config where Property = ?", hence the exception.

Hope this helps.

edited Aug 10, 2012 at 5:12

Luiggi Mendoza

85.9k16 gold badges159 silver badges354 bronze badges

answered Aug 10, 2012 at 5:10

Senthil Kumar

10.4k8 gold badges39 silver badges46 bronze badges

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

1 Comment

Gapchoos Over a year ago

@Senthil Thanks.this helped and there were few other changes.:) Its clear now

Collectives™ on Stack Overflow

Java MYSQL Exception in executeQuery()

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related