33,274 questions
Score of 3
1 answer
104 views
MySQL Connector/J 9.5 returns no rows from PreparedStatement (Statement works)
After upgrading MySQL Connector/J from 9.4.0 to 9.5.0, connections to OceanBase (MySQL mode) work, but PreparedStatement queries return zero rows. The same SQL works with a plain Statement, and the ...
- reputation score 43
Score of -1
0 answers
58 views
Using DbSchema Salesforce JDBC drivers with DataGrip
How can I use the DbSchema open source JDBC drivers with the JetBrains DataGrip DB IDE?
I cannot work out how to add the collection of JAR files in the downloadable zip to DataGrip and then how to get ...
- reputation score 137
Advice
0
votes
0
replies
44
views
How oracle key value and secret key management work with application?
Refer to oracle doc https://docs.oracle.com/en/database/oracle/key-vault/21.14/okvag/okv_intro.html#GUID-54B0FC10-8176-4A3B-9B81-841D60A18A69
How could application and database direct retrive secret ...
- reputation score 11
Best practices
2
votes
7
replies
259
views
How would you read the data from the Excel file and store it into a database using Java?
You have an Excel (.xls/.xlsx) file containing 1000 employee records. How would you read the data from the Excel file and store it into a database using Java?
<dependency>
<groupId>org....
- reputation score 1
Score of 1
1 answer
138 views
Delete Query working in SQLYog, but not in Java [closed]
@Override
public String getDeleteQuery() {
return "DELETE FROM prod_evidencija WHERE idProdavac = ? AND idProdavnica = ? AND datum = ?";
}
@Override
public void ...
- reputation score 33
Score of 2
1 answer
190 views
Spring Boot 4.0.6 and Spring Batch 6 - the Spring Batch tables are not being created
I am using Spring Boot 4.0.6 with Spring Batch and MySQL with Docker; however, the Spring Batch tables (e.g. BATCH_JOB_EXECUTION, etc.) in the spring_batch schema are not being created automatically.
...
- reputation score 21
Advice
0
votes
1
replies
101
views
Client does not support Authentication Protocol
Im running the Java file in vs code I'm getting exception like java.sql.SQLException: Client does not support authentication protocol requested by server, consider upgrading MySQL client. Im using ...
- reputation score 1
Best practices
0
votes
3
replies
90
views
What's the best approach to filtering based on max and min of a related table's values are within a specified range?
Sorry if my title is hard to parse and makes no sense, English isn't my first language, and putting my requirement into words is little difficult.
I have two tables, one called requests and one called ...
- reputation score 11
Score of 2
1 answer
126 views
Is it possible to run an Oracle package to create a table via JDBC
I am trying to move a database creation process from SQL plus to JDBC. I need to run a bunch of processes attached to Oracle packages.
BEGIN
ddl.column('table_name', 'column_name', 'type')
END
I ...
- reputation score 321
Score of 0
1 answer
99 views
How can I apply a streaming parameter from Java into an Oracle BLOB?
I want to search an Oracle table by a Blob using streaming. This example runs well in DB2, SQL Server, PostgreSQL, and MySQL, but it fails with an error in Oracle. I have the following table:
create ...
- reputation score 49436
Advice
1
vote
5
replies
179
views
Oracle, PL/SQL and Java
I’m a PL/SQL developer with strong Oracle experience, interviewing for a role in a Java-based team. They’re happy with my database skills but want me to learn few Java skills before the next round.
...
- reputation score 19
Score of 1
3 answers
197 views
Slow performance with SQL Server MERGE using Spring JdbcTemplate batchUpdate for ~14k records
I am experiencing significant performance issues when performing an "upsert" operation on a SQL Server table using Spring Boot's JdbcTemplate.batchUpdate in my Java 17, springboot 3.2.5 ...
- reputation score 38
Score of 6
2 answers
139 views
Cross-vendor BYTEA / BLOB fetch
PSQLException gets thrown when calling resultSet.getBlob(String) (with NumberFormatException as the cause). The column is of type BYTEA since there are no Blobs in Postgres.
Bad value for type long : ...
- reputation score 3089
Best practices
1
vote
2
replies
60
views
jOOQ: Best practice to set up user_id session variables
I'm using PostgreSQL RLS which relies on session variables (current_setting) to find out current tenant/user and filter data accordingly. What is the best way to set these values when using jooq to ...
- reputation score 2381
Score of 0
2 answers
151 views
Impossible to connect to a Microsoft Access database in LibreOffice 25.2 with UCanAccess and jdbcDriverOOo 1.6.2
I need to edit the content of a MDB file under Debian Linux 12 with LibreOffice 25.2.
I tried to use the solution mentioned in the documentation (relying on UCanAccess) without success: I added the ...
- reputation score 4319
