33,505 questions
0
votes
0
answers
9
views
Issue Adding GridDB JDBC Driver to SQL Workbench/J – Driver Class Not Detected
I'm trying to connect to the GridDB using SQL Workbench/J, but I'm running into issues when adding the JDBC driver.
I downloaded the file gridstore-jdbc-5.7.0-javadoc.jar and added it as a driver in ...
- 1
1
vote
0
answers
35
views
ClickHouse JDBC Bridge: "Connection was closed" errors with long-running SQL Server queries
I'm experiencing persistent timeout issues when connecting ClickHouse (v25.2.2.39) to SQL Server through the ClickHouse JDBC Bridge (v2.1.0).
Simple queries work fine: SELECT * FROM jdbc('DWH', '...
- 11
1
vote
2
answers
43
views
BadSqlGrammarException while testing service layer that used JDBC
I am writing a test code which is giving me BadSqlGrammarException error. I am using JDBC template.
error is "org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [...
- 11
0
votes
0
answers
26
views
Trino dynamic catalog management: "Could not store catalog properties" when creating catalog inside container
I'm running a Trino container using Docker and trying to use dynamic catalog management via the CREATE CATALOG SQL command.
Here's how I set up my container using Python with the Docker SDK:
# Remove ...
- 11
1
vote
1
answer
40
views
Accessing a Paradox table whose name consists of numbers
I have installed the driver https://github.com/leonhad/paradoxdriver.
Next, I specified the path to the table, but an error appears when creating the query, because the table name consists entirely of ...
- 25
0
votes
0
answers
50
views
How to connect to a Paradox database with an absolute path in Java
I have installed the driver https://github.com/leonhad/paradoxdriver. What should I write in the line java.sql.Connection conn = DriverManager.getConnection("jdbc:paradox:./db"); if the ...
- 25
2
votes
1
answer
128
views
FATAL: invalid value for parameter "TimeZone": "Asia/Saigon"
During backend development for a Java application, I set up a PostgreSQL database connection using JDBC in DatabaseConnection.java. I then ran a simple backend app to test the connection through ...
- 55
0
votes
1
answer
31
views
Debezium convert types
I have a MySQL column which should store a boolean value. My Django driver models this with a TINYINT value. I want to replicate this data in a PostgreSQL but there this column is a BOOLEAN.
The ...
- 178
0
votes
0
answers
44
views
Way to do a "batch select" (with multiple where... in...) using JDBC in SQL Server?
I am working with SQL Server in Java code.
I have a semi-large (16,000 items) ArrayList of objects, and I would like to do a SELECT on the table for all these objects. (The goal is to get surplus ...
- 29
0
votes
0
answers
43
views
Invalid connection parameter(s) exception while connecting Pyspark code with AWS Athena using jdbc driver 3.x
I am trying to fetch the data from AWS Athena using pyspark dataframes. While trying to connect with AWS Athena using JDBC driver, getting error as :
java.sql.SQLException: Could not connect: Invalid ...
- 939
2
votes
1
answer
89
views
Informix db connection pool issue
I am using an Informix database and connection pool, and it's not releasing ideal connections.
AtomikosDataSourceBean ds = new AtomikosDataSourceBean();
ds.setUniqueResourceName("XADS-"+...
- 85
0
votes
1
answer
41
views
Postgres LISTEN/NOTIFY in Quarkus - transaction for each notification [closed]
I'm trying to learn Quarkus by creating a simple MQ above Postgres. I'm sticking to JDBC to keep things as performant as possible, and I've set up a trivial messages table along with triggers that ...
0
votes
1
answer
60
views
Flink Scheduled JDBC Source
I have the following definition of the JDBC source in Apache Flink.
val jdbcSource = JdbcSource.builder<LoggedInEvent>()
.setDBUrl("jdbc:postgresql://db:5432/postgres")
....
- 4,349
0
votes
0
answers
28
views
How to pass principal and key tab file programmatically when connecting SQL through Kerberos authentication java
I am trying to connect MSSQL via JDBC with Kerberos authentication, and I was successful when I configured it using JVM arguments.
-Djava.security.krb5.conf=$SECURITY_KRB5_CONF -Djava.security.auth....
- 275
0
votes
0
answers
49
views
Use SQL Server temporary tables on a JDBC connection from Apache tomcat connection pool?
The fundamental requirement of SQL Server temporary tables is that the exist as long as the connection that created them is still open and is not reset with sp_reset_connection.
If I create a temp ...
- 1,892