Tag: prepared-statement

Try-with-resources – Does it automatically close the connection? Java

connection hikaricp java prepared-statement

I’ve been working on a SQL utility and I am trying to set the parameters inside a prepared statement in multiple functions. To lessen the code, I have a function that returns a prepared statement where all the params are set. My question is: Does the connection reference in the configureStatement() get …

Should I close the prepared statement passed as parameter?

java jdbc prepared-statement sonarqube

I am aware that we should not reuse prepared statement or use try-with-resource in java. But what should I do with prepared statement passed as parameter? Should I close it too? For example: Answer The way I see it is as follows: In your code somemethod is not the owner of those prepared statements that were …

Java PreparedStatement preserve table name casing

h2 java jdbc prepared-statement wildfly

I have this Java snippet, running inside a WildFly server backed by MariaDB: which gives me the following exception: So, apparentally, it decided to uppercase the table name, which I don’t want. How can I turn it off? Answer That is not possible, SQL dialects are – usually – case insensitive…

Java: Insert multiple rows into MySQL with PreparedStatement

batch-insert java jdbc mysql prepared-statement

I want to insert multiple rows into a MySQL table at once using Java. The number of rows is dynamic. In the past I was doing… I’d like to optimize this to use the MySQL-supported syntax: but with a PreparedStatement I don’t know of any way to do this since I don’t know beforehand how m…

PreparedStatement setNull(..)

java jdbc prepared-statement

Java PreparedStatement provides a possibility to explicitely set a Null value. This possibility is: Are the semantics of this call the same as when using a specific setType with a null parameter? ? Answer This guide says: 6.1.5 Sending JDBC NULL as an IN parameter The setNull method allows a programmer to sen…

Using Prepared Statements to set Table Name

java prepared-statement sql

I’m trying to use prepared statements to set a table name to select data from, but I keep getting an error when I execute the query. The error and sample code is displayed below. Any thoughts on what might be causing this? Answer A table name can’t be used as a parameter. It must be hard coded. So…