sql update statement not working from Java but working manually?

Question

EDIT: I had a letter off, it's working now.

I have the following sql statement

UPDATE names set sent_count = sent_count + 1  where user_name = 'name' AND category = 'test' AND service = 'test'

this works by increasing the sent_count each time I run the sql from PGAdmin3, but I have the following method in a Java program using Postgresql JDBC, it's not throwing any exceptions but it's not increasing sent_count here is the method below

public void increaseUsernameResponseCount(String userName, String category, String service, String country) throws SQLException
{
    Connection conn = null;
    PreparedStatement pst = null;
    // ResultSet rs = null;

    try
    {
        Class.forName("org.postgresql.Driver");
        conn = DriverManager.getConnection(url, props);
        pst = conn.prepareStatement("UPDATE names set sent_count = sent_count + 1  where user_name = ? AND category = ? AND service = ?");
        pst.setString(1, userName);
        pst.setString(2, category);
        pst.setString(3, service);

        int count = pst.executeUpdate();
        System.out.println(count);

    }
    catch (Exception e)
    {
        System.out.println(e);
    }
    finally
    {
        pst.close();
        conn.close();
    }
}

the count counter prints 0 when this method is ran. Any idea why it does not work from the method but it works when I execute the sql query?

I take it you've made absolutely sure that userName, category and service are exactly the same as in your pgadmin session? — NPE
– NPE, Commented Jan 4, 2013 at 11:38
Use System.out.println to print the values of username, category, service. — Marko Topolnik
– Marko Topolnik, Commented Jan 4, 2013 at 11:39
And of course make sure you're connecting to the same database, and not some UAT copy or something (been there :)) — NPE
– NPE, Commented Jan 4, 2013 at 11:41

TechSpellBound · Accepted Answer · 2013-01-04 13:41:23Z

2

Check if you have two databases containing the same table. This generally happens if you work at two different locations and keep changing database names while importing it from the dump.

Also check if the "url" and "props" strings are correct for the database.

answered Jan 4, 2013 at 13:41

TechSpellBound

2,5456 gold badges26 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

sql update statement not working from Java but working manually?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related