Questions tagged [jdbc]
Java Database Connectivity (JDBC) is a Java standard that provides the interface for connecting from Java to relational databases.
184 questions
0
votes
0
answers
58
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
165
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
78
views
ORA-02292: integrity constraint (CITY_COUNTRY_FK) violated - child record found
I am trying to make my all table columns in lowercase but the following error appears:
SQL> UPDATE COUNTRY SET country_code = LOWER(country_code);
UPDATE COUNTRY SET country_code = LOWER(...
- 17
0
votes
0
answers
100
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 ...
0
votes
0
answers
70
views
SQL via JDBC fails on MSSQL Server with BEGIN TRAN
Running this SQL via JDBC on MSSQL works as expected:
UPDATE costcenter
SET updatetimestamp = Getdate(),
[de] = 'CostCenterName',
[en] = 'CostCenterName_en'
WHERE [customerid] = '...
1
vote
0
answers
240
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 ...
0
votes
0
answers
136
views
JDBC using DataSource, DB2 and Kerberos
I am trying to set up a JDBC using DataSource interface, DB2 database and Kerberos for authentication.
I am using IBMs documentation which refers in Kerberos security with no user ID or password link ...
- 1
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
1
vote
0
answers
343
views
is it possible to set specific timezone for session in mariadb connector/j
I 'm trying to use timezone setting with mariadb connector/J version 3.x.
In the documentation,in Timezone consideration, it says:
'a timezone': connector will set connection variable to value. ...
- 11
0
votes
0
answers
109
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.
...
- 159
1
vote
1
answer
619
views
Can JDBC Oracle file stream blob inserts be speeded up?
I have these four different ways by which I am inserting some file data into an Oracle database using JDBC and PreparedStatements.
Approach A
ps.setBytes(1, fileDataInByteArray);
Approach B
Blob ...
- 11
0
votes
1
answer
500
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
2
answers
2k
views
Java PostgreSQL library seems to convert dates to local time zone automatically
PostgreSQL 14.6
Ubuntu 22.04
I am using postgresql-42.5.4.jar which I downloaded from pgJDBC. I use this library to get data from a database and display it on a website running locally. The web server ...
- 283
0
votes
1
answer
90
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
0
votes
1
answer
5k
views
Unable to connect with JDBC after MySQL upgrade from 5.7 to MySQL 8.0
We use java application client to transfer database table data to a third party server. With MySQL 5.7 it was working fine. After upgrade to MySQL 8, it started to show errors. First thing we did was ...
- 23