33,364 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
57
views
Spring Boot PostgreSQL Connection Failing on Render with UnknownHostException - jdbc:postgresql URL Format Issue
I'm deploying a Spring Boot application to Render with a PostgreSQL database (also hosted on Render). The application was working fine yesterday, but after updating my application.properties to change ...
1
vote
2
answers
254
views
PostgreSQL Connection Error via DBeaver: FATAL: invalid value for parameter "TimeZone": "Asia/Calcutta" [closed]
I have a PostgreSQL database server running on my VPS. I am currently working from my local machine using an SSH connection and would like to view the database tables and data graphically for better ...
0
votes
1
answer
107
views
Connect to SAS server from R via SAS JDBC - dbConnect Error
I am trying to connect to work SAS server from R, to extract datasets for further processing/analysis in R.
Due to corporate constraints, the only solution available is SAS JDBC type of connection, ...
3
votes
0
answers
77
views
Why don't my MySQL usernames match when I use them in JDBC? [duplicate]
I’m having trouble understanding how MySQL users actually work.
When I run:
SELECT USER(); MySql shows: root@localhost .
But my username when i log in is ade. so when I to set a connection using ...
0
votes
3
answers
88
views
How to connect to a Postgres accessible under a pathname via JDBC?
I have a Postgres on a server which is available under https://somethig.my.domain/postgres on port 5432.
I'm trying to connect via DataGrip which uses a JDBC driver. But I cannot figure out the ...
0
votes
1
answer
78
views
Oracle UCP stale connections cleanup / maxConnectionReuseTime
Environment
Oracle server v19c
Using jdbc driver and ucp from com.oracle.database.jdbc:ojdbc10-production:19.29.0.0
Tomcat10/Java17/SpringBoot3.5 application
UCP logging enabled with oracle.ucp.level ...
0
votes
1
answer
126
views
Connecting to Oracle database is fast with C# ADO.NET, but slow with Java JDBC
Here is the Java test code I wrote. It takes about 40 seconds to connect to the Oracle database using JDBC, but similar code in C# using the OracleConnection.Open method completes in less than 1 ...
1
vote
1
answer
77
views
Spark JDBC reading wrong character encoding from PostgreSQL with server_encoding = SQL_ASCII
I'm reading data from a PostgreSQL 8.4 database into PySpark using the JDBC connector.
The database's server_encoding is SQL_ASCII.
When I query the table directly in pgAdmin, names like SÉRGIO or ...
0
votes
1
answer
109
views
How to run a SQL script in Java NOT on startup?
I have a Spring application which is multi-tenant (uses JdbcTemplate for data access). There are several tables creates for each tenant, and I want to keep this SQL code in a separate init_tenant.sql ...
2
votes
2
answers
140
views
javax.sql.rowset.serial.SerialClob cannot be cast to oracle.sql.CLOB while using preparedStatement.setClob
I'm trying to insert a java.sql.Clob to an Oracle DB table with a clob column and it fails with the following exception
javax.sql.rowset.serial.SerialClob cannot be cast to oracle.sql.CLOB
at ...
0
votes
1
answer
120
views
SQL Server and Sybase driver conflicts
I need to extract data from a Sybase source and then use this data to extract values from an SQL Server source.
I am using these drivers:
// Database drivers
// https://mvnrepository.com/...
1
vote
1
answer
88
views
How to use FIXED_LIST instead of MULTICAST in griddb using jdbc driver
The GridDB server has been configured to use FIXED_LIST instead of MULTICAST and is functioning correctly. While the c_client and Java samples within GridDB operate as intended, the samples for JDBC ...
-1
votes
1
answer
120
views
Unable to connect to dremio cloud from JDBC
I am trying to connect to Dremio cloud using JDBC but i am getting following error:
java.sql.SQLException: Failure in connecting to Dremio: com.dremio.jdbc.shaded.com.dremio.exec.rpc....
1
vote
0
answers
36
views
What is the difference between 'tomcat-jdbc-pool' and 'tomcat-jdbc' maven dependencies? [duplicate]
In the Maven repository, there are two dependencies available:
tomcat-jdbc
tomcat-jdbc-pool
I understand that tomcat-jdbc-pool is the dependency used in Tomcat for connection pooling, as stated in ...
1
vote
3
answers
354
views
Virtual threads vs reactive database drivers
There is a typical task: consume data from Kafka (or REST/gRPC), process it, and persist it in the DB.
The database has always been our weak point. We usually have hundreds or thousands of messages to ...