33,288 questions
Best practices
2
votes
4
replies
159
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
132 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
169 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
97
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
87
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
124 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
89 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
172
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
190 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
136 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 3069
Best practices
1
vote
2
replies
51
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
145 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 4296
Score of 1
3 answers
171 views
java.lang.UnsatisfiedLinkError: The specified procedure could not be found when trying to use thick (Oracle Instant Client) JDBC connection
Our DBAs want to enable Transparent Application Failover (TAF) in our Oracle databases and we were told to enable this we needed to change from 'thin' JDBC connections to OCI in our Java applications. ...
- reputation score 125
Advice
0
votes
3
replies
69
views
Statement execution after thread interruption
Will Statement execution be canceled if the thread that is executing it is interrupt()ed (execute() has not yet returned)? For example, after calling swingWorker.cancel(true).
It may be anything:
...
- reputation score 3069
Score of 6
1 answer
153 views
How do I confirm that JdbcTemplate is fetching the records into the result set in batches of 1000 when setFetchSize(1000) is set on the statement?
How do I confirm that JdbcTemplate is fetching the records into the result set in batches of 1000 when setFetchSize(1000) is set on the statement?
I am using PostgreSQL JDBC driver here.
Below is my ...
- reputation score 446