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