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 по дате отправления: