I have a simple Java 8 project to update a SQL Server DB table starting by a list of DTO I created. The DTO obviously reflect the column of the table I want to update, suppose it’s similar to the follows: public class TableToUpdate { private int id; private String name; // getter and setter… Read More Should JDBC executeBatch() return an array with a length of the original batch even if there were no updates?

I have been working with a JDBC for the past couple of weeks and I have come upon a problem that I figure will have subjective answers. Let’s suppose we want to create a method that dynamically constructs a SQL statement that is to be executed based upon what a user inputs into some GUI.… Read More Is there a better way to dynamically implement SQL statements in java?

I have the written the following code which works fine and shows me the nickname: $stmt2 = $pdo->query("SELECT nick FROM users WHERE ID=12"); $nn = $stmt2->fetch(); echo $nn["0"]; now I tried to do it as a prepared statement, so I can use different ID numbers. But it does not work, it display nothing. $stmt3 =… Read More PDO query works but prepared statement does not

Hello I have the problem that I just can’t get the following code to run. I’ve tried and changed all of them but I always get an error, maybe you have an idea where the error is? public class TestCommand implements ServerCommand{ @Override public void performcommand(SlashCommandInteractionEvent event, Member m, MessageChannelUnion channel, VoiceChannel ec, VoiceChannel pub,… Read More Java SQL Prepared Statement Update not working

This JDBC query does not return anything despite it working on my SQLite Database Browser, no matter what I tried. The snippet is pretty self-explanatory of the results I’m looking for. public void getCountryIdLocationIdDepartmentIdParEmploye(Employe employe) { String query = "SELECT countries.country_id AS idc, locations.location_id AS idl, departments.department_id AS idd FROM countries INNER JOIN locations ON… Read More Why can't I get results from my Inner Join JDBC Query?

Using PG14, Hikari pool, Kotlin 1.6 I get the following error when calling, for example, a SET query: org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1" val input = "yes" connection.prepareStatement("SET log_connections TO ?") .apply { setString(1, input) }.use { it.execute() } Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1" Position: 22 at… Read More Prepared statement – with SET of run-time configuration parameters – not working

Recently I ran across the following peculiar behavior, that can be explained by the following code sample: import sqlite3, platform insert = (10, "today") db = sqlite3.connect(":memory:") db.execute("CREATE TABLE t (number, string)") db.execute("INSERT INTO t (string, number) VALUES ($2, $1)", insert) select = db.execute("SELECT number, string FROM t").fetchone() print(f"python version: {platform.python_version()}") print(f"sqlite version: {sqlite3.sqlite_version}, module:… Read More Why does Python's sqlite3 module not respect the order of positional parameters?

One day I was googling to understand when a prepared statment should be used. As I searched online many claimed that you should use always prepared statments. Now the question I have is… does this also count for LIMIT? I mean it is possible (I tried) but is it really that rational? Same question on… Read More Should you use prepared statments on LIMIT

So I’m using prepared statements in PHP to send a SQL command where there 5 different matching columns. The goal is that there should be an option where if only one column is selected the command should be able to run. And the options should also work if you choose all of the 5 different… Read More SQL Prepared statements select all result with =