Questions tagged [jdbc]
Java Database Connectivity (JDBC) is a Java standard that provides the interface for connecting from Java to relational databases.
185 questions
0 votes
0 answers
38 views
AzureSQL - JDBC - Threads hung over socket read
I have a Java application with an ETL process running with Azure SQL DB and some times the processing just freezes but the app still runs. I did some thread dump analysis and found that during this ...
- 91
1 vote
1 answer
129 views
Can I use MSSQL's Failover Partner parameter without configuring database mirroring?
I have 2 MSSQL databases that are not part of the same cluster but they are synchronized manually (without database mirroring configured) I want my client applications to try connecting to the first ...
- 113
0 votes
0 answers
82 views
Not possible to connect to remote Oracle XE with public IP
I have a problem with my database, I cannot access to it via public IP (remote). I have developed a java stocks program, which uses JDBC to connect to DB. My database is Oracle Database Express ...
1 vote
0 answers
228 views
Writing large dataset from spark dataframe
We have a azure databricks job that retrieves some large dataset with pyspark. The dataframe has about 11 billion rows. We are currently writing this out to a postgresql DB (also in azure). Currently ...
1 vote
3 answers
1k views
MySQL Temporary Tables and Connection Pools
This is more of a "please confirm/correct my understanding" question. Background I connect to MySQL using JDBC, the connection pool has around 250 connections, most of which seem ...
- 127
0 votes
0 answers
99 views
Why, MariaDB user allowed host IP address also allows a virtual machine on the host with NAT network adapter
The MariaDB user specifies an allowed IP address in the Host column of the mysql.user table. So, it only allows logging in from the host with the specified IP address. And MySQL has the same design. ...
- 149
0 votes
1 answer
466 views
Execute Permission Denied on Stored Procedure using Microsoft JDBC Driver and Windows Authentication
I have a Microsoft SQL Server database that I use Stored Procedures to read/write data to through a Integration Engine in this case InterSystem IRIS. Originally I was using a local server user to do ...
- 1
0 votes
1 answer
73 views
Oracle CACHE and STORAGE IN ROW behaviour
We have a Java Spring boot application that writes 20 million plus rows in a table with 2 blob columns in a batched manner into an Oracle 21c DB. We are using JDBC batch insert for fast inserts. ...
- 101