UPDATE with JDBC fail

Поиск
Список
Период
Сортировка
От Jose.Silva@isotrol.com
Тема UPDATE with JDBC fail
Дата
Msg-id 33339.192.168.102.86.1091701964.squirrel@192.168.102.86
обсуждение исходный текст
Ответы Re: UPDATE with JDBC fail
Re: UPDATE with JDBC fail
Re: UPDATE with JDBC fail
Список pgsql-jdbc
Hi, my name is J.A. Silva
I'm a worker of Isotrol (Spain).
I'm developing a tool for modify values in a PostGreSQL database.
The tool only have to modify some tables with a random value.

The code that do this is ...
private void refrescaTablaDatos()
{
    String sql = "";
    String molino;
    ResultSet rs = null;
    int i = 0;

    try
    {
        // select the primary keys of the items to modify
        sql = "SELECT DISTINCT id FROM datos;";
        rs = this.con.executeSQL(sql);

        // modify one per one all the items ...
        while(rs.next())
        {
            molino = rs.getString(1);

            sql = "UPDATE datos SET valor = " +
                   (float)(100*Math.random()) +
                ", timestamp = now() WHERE id = " +
                molino + ";";

            this.con.executeSQL(sql);
            i = i + this.con.getFilasAfectadas();
        }
    }
    catch(Exception e)
    {
        e.toString();
    }
}

The function is very simple ... but it does not work.
The database doen not change its values.

The select query works perfectly but the update funtion does not do anything.

I hope that you can help me. I will be expecting your answer.

The PosrGre version that I use is 7.1. and the JDBC driver that I use is
the driver that you can get of Postgre's webpage.

My english level is not good, I hope that you can understand this mail.

Thanks for all and good bye

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Ryoji Sawa
Дата:
Сообщение: [Fwd: Q: database schema from JDBC driver and netbeans.]
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: UPDATE with JDBC fail