JDBC polling data sources: what's i did wrong?

Поиск
Список
Период
Сортировка
От Serg N Elin
Тема JDBC polling data sources: what's i did wrong?
Дата
Msg-id 000901c2f21e$510a85e0$436fa8c0@zoo
обсуждение исходный текст
Ответы Re: JDBC polling data sources: what's i did wrong?
Re: JDBC polling data sources: what's i did wrong?
Список pgsql-jdbc
Hi there,

here is a simple application which i wrote for testing purposes:

...

 Jdbc3PoolingDataSource source = new Jdbc3PoolingDataSource();
 source.setServerName("localhost");
 source.setDatabaseName("cruz");
 source.setUser("cruz");
 source.setPassword(null);
 source.setMaxConnections(5);

      Connection conn = source.getConnection();

      PreparedStatement st = conn.prepareStatement(
          "INSERT INTO test (from_addr, "
          + " to_addr, subject, body, received, message_id,in_reply_to)
values (?,?,?,?,?,?,?)"
          );
      st.setString(1, "test");
      st.setString(2, "test");
      st.setString(3, "test");
      st.setString(4, "test");
      st.setDate(5, new java.sql.Date(new Date().getTime()));
      st.setString(6,"test");
       st.setString(7,"test");

      int count = st.executeUpdate();

      st.close();

      conn.close();
    }
    catch (SQLException ex) {
      ex.printStackTrace();
    }
then code executed there are no any data that you can seen in example in the
table/// So the qestion is what's i'm doing wrong?

jdk 1.4.1_01, PostgreSQL 7.3.2, JDBC driver 7.3 build 108.


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

Предыдущее
От: Sangyoon Oh
Дата:
Сообщение: Call pl/sql function
Следующее
От: "Shawn Green"
Дата:
Сообщение: updateRow bug fix (possible) and build questions