I’m trying to use MyBatis with a Snowflake database. My situation is similar to that of this poster: Configure mybatis to use an existing connection Essentially, I can get a java.sql.Connection Object, but I cannot get that by way of a DataSource, or other steps normally done by RDBMS databases like Ora…
Tag: jdbc
Using PostgreSQL COPY
I’m using JMeter for insert summary data file to PostgreSQL. I tried copy instead of COPY but I’m getting error at copy syntax. I found out COPY is for only server-side, so I us copy for client-side. Here is my query Here is the error: org.postgresql.util.PSQLException: ERROR: syntax error at or n…
Select count(*) query from JdbcTemplate returns different value than running the query from SQL terminal
I have this simple query : called from Spring Boot. There are no rows with the ID (150) passed in. When running queryForObject, variable count comes up as 1 , while when running the same query from SQL Developer it comes up as 0!! What’s going on here? What am I missing? Answer Possible causes a) you ar…
SQL Database using JDBC + parameterize SQL Query + Databricks
In Databricks am reading SQL table as How can I parameterize SourceSystem and RuleCode in Where clause Was referring to: https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases Answer if you import the spark implicits, you can create references to columns with the dollar $ interpolat…
Apache Flink – External Jar
i’m trying to create a Flink application using maven and an extra dependency : com.microsoft.sqlserver mssql-jdbc</…
Prepared statement with some where condition in case of any value
I have prepared statement like select * from books where author = ? and theme = ? and i cant figure out what to do, if user select option “any author” or “any theme”, what should i set to prepared …
Retrieving pictures from MySQL using Java
I have a question related to retrieving files from MySQL using JDBC. I managed to save a .png file from my desktop & retrieve it successfully, but I can’t read the file. It shows that the format …
JPA Batch inserts with non auto generated id
im triying to batch insert a few Million Entitys. The Batch insert kind of works, but my programm executes a few JDBC Statements in the background which i dont want. } my Repository: my Entity: my JPA Settings: The Batch Insert Does work, but if i try to Upload 100 Entitys i have 33 JDBC Statements which are …
JDBC, Prepared Statement getInt() returns 0
In my DB every question has a valid questionID (primary Key) and categoryID (foreign Key to category table). The problem is: in the Result Set for every question both IDs are 0 instead of what’s written in the DB. All other arguments are filled out correctly. Edit 1 Here is the original code (in the pos…
Conditional UPDATE MariaDB (MySQL)
Code: UPDATE COMPANY SET id=’21’ WHERE id=’20’; Error: SQLException: Duplicate entry ’21’ for key ‘PRIMARY’ I want to UPDATE the primary key field in this case it’s called ‘id’ to another value …