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
>