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

Serg,

You didn't call commit().  So the changes are not saved.

--Barry

Serg N Elin wrote:
> 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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>