Prepared Statements | SpigotMC | Page 1

tulip oracle Jan 19, 2022, 8:04 PM

#

When using prepared statements, should I be calling Connection#prepareStatement each time I want to use it, or should I create it once and save it to a variable?

wispy grail Jan 19, 2022, 8:05 PM

#

Create a new one. https://docs.oracle.com/javase/tutorial/jdbc/basics/prepared.html

Oracle creates separate ones in their CoffeesTable example.

tulip oracle Jan 19, 2022, 8:06 PM

#

Interesting

#

I know there is caching going on behind the scenes, but I wonder why they don’t save it as a variable

dreamy niche Jan 19, 2022, 8:07 PM

#

i mean

#

You know connections shouldnt persist as well

tulip oracle Jan 19, 2022, 8:07 PM

#

True

#Prepared Statements