jdbctemplate « postgresql « Java Database Q&A





1. Use NamedParameterJdbcTemplate to update array field    stackoverflow.com

I have a double precision array field dblArrayFld in a table myTable and I'd like to update it using Spring's NamedParameterJdbcTemplate (I'm using Postgres). I'm running code like this:

SqlParameterSource params = (new ...

2. JdbcTemplate and inet data type    stackoverflow.com

One of my table has the column type as inet. And when I try to perform insert operation using String as the type for inet column, it's saying "column "ip" is ...

3. how to copy a data from file to PostgreSQL using JDBC?    stackoverflow.com

I want to copy data from file to PostgreSQL DB using JDBC. I was using JDBC statement object to copy the file into DB. It is very slow. I came to ...

4. How can I log progress of multiple sql queries in a single JdbcTemplate execute() and PostgreSQL    stackoverflow.com

I have a SQL script with many statements which I execute using JdbcTemplate.execute(). Some queries are slow and I'd like to write progress of the whole script to the logs. As it ...