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.
