Exception: No primary keys?

Поиск
Список
Период
Сортировка
От Han
Тема Exception: No primary keys?
Дата
Msg-id 20021202084258.99E794758E6@postgresql.org
обсуждение исходный текст
Ответы Re: Exception: No primary keys?  (Dave Cramer <Dave@micro-automation.net>)
Список pgsql-jdbc
pgsql-jdbc

    A simplest test failed when I use postgresql and pgsql-jdbc driver which were build from postgresql7.3b5 source
code.
    The test code is:
..
     14         try{
     15             Class.forName(strDrv);
     16             conn = DriverManager.getConnection(strUrl, "postgl", "");
     17             stmt = conn.createStatement();
     18             rs = stmt.executeQuery(strSql);
     19             while (rs.next())
     20             {
     21                 System.out.println(rs.getString(1));
     22             }
     23             //rs.beforeFirst();
     24             while (rs.previous())
     25             {
     26                 System.out.println(rs.getString(1));
     27             }
     28             rs.moveToInsertRow();
     29             rs.updateInt("a", 100);
     30             rs.insertRow();
     31         } catch(Exception e){
     32             System.out.println(e.toString());
     33         }

       The table "test" has only two columns(a int, b varchar) and no primary keys.
    The error message is: No primary keys.
    It's all right with line 28,29 and 30 commented out.
    It will also succedd when the table "test" has a primary key.
    Can you tell me why?
    My environment is:
    redhat 7.3
    j2sdk1.4.1_01
    ant1.5.1

    Thanks and regards,
        


        Han
        zhouhanok@vip.sina.com
          2002-12-02




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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: md5 passwords in 7.2.3 ?
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Exception: No primary keys?