33,288 questions
-4
votes
0
answers
128
views
Maven Project src/main/java is missing [closed]
Maven Web Project (maven-archetype-webapp 1.5) does not create src/main/java in Eclipse 2026-03
I am using Eclipse IDE for Enterprise Java and Web Developers 2026-03 (4.39.0).
I created a Maven Web ...
- reputation score 1
0
votes
1
answer
126
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 23
1
vote
1
answer
164
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 11
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
2
votes
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
0
votes
1
answer
88
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
171
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
1
vote
3
answers
188
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
6
votes
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 3051
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
0
votes
2
answers
140
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
1
vote
3
answers
170
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 3051
6
votes
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
