33,238 questions
Score of 0
0 answers
194 views
Why python app keeps getting DisconnectNonTransientConnectionException every two weeks? [closed]
DB2 connection failed: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][4.33.31] Exception java.net.ConnectException: Error opening socket to server URL on port ...
- reputation score 17
Score of -2
1 answer
112 views
Using AWS Secrets Manager JDBC Library with DataNucleus
In our application we want to replace the default PostgreSQL JDBC driver with the AWS Secrets Manager JDBC driver to handle RDS database credentials rotation. According to the AWS documentation we ...
- reputation score 587
Score of 0
1 answer
125 views
How to intercept PreparedStatement and reconstruct SQL with parameters using Byte Buddy for GBase 8c JDBC driver?
I need something similar to log4jdbc to log SQL statements initiated by the application along with their execution times via the JDBC driver side.
However, instead of using log4jdbc's proxy-based ...
- reputation score 19
Score of 2
1 answer
138 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 55
Score of 1
1 answer
179 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
235 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
Score of 0
1 answer
109 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
Score of 2
1 answer
137 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
114 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 49444
Score of -2
4 answers
208 views
What Java and JDBC topics should I focus on for a database-centric role? [closed]
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 15
Score of 1
3 answers
225 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
152 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 3095
Score of 0
1 answer
84 views
Best practice to set up user_id session variables using jOOQ
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 2391
Score of 0
3 answers
215 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
Score of 1
3 answers
211 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
