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

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.

Responses

Browse pgsql-jdbc by date

  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