Re: [GENERAL] Prepared Statements and Pooling

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 the

Re: [GENERAL] Prepared Statements and Pooling

On 11 August 2015 at 06:44, Mister Junk junkmail3568...@gmail.com 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

[GENERAL] Prepared Statements and Pooling

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