On 11 August 2015 at 06:44, Mister Junk wrote:
> I'm using prepared statements to prevent SQL injection, but I have done some
> reading and it seems like using Prepared statements COULD improve
> performance. I understand the concept, but I do not know how to implement
> this.
They could, they c
> I have considered opening a single connection to the server and letting all
> threads execute statements through it, and use prepared statements (serviced
> by postgresql, not JDBC or DBCP). Or simply opening 50 connections and
> establishing prepared statements and then handing them off to t
I'm working on a project for school that requires a simple java server (a
ServerSocket creates Socket connections which I send JSON strings over)
which then communicates with a database. Obviously I have chosen
PostgreSQL.
I'm using Apache DBCP for connection pooling. The DataSource is handed of