From: | "Serg N Elin" <esn(at)sumail(dot)ru> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | JDBC polling data sources: what's i did wrong? |
Date: | 2003-03-24 15:59:13 |
Message-ID: | 000901c2f21e$510a85e0$436fa8c0@zoo |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Barry Lind | 2003-03-24 16:27:07 | Re: Follow-up OpenOffice and Postgres 7.3.2 |
Previous Message | Sangyoon Oh | 2003-03-24 15:30:01 | Call pl/sql function |