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
0 votes
0 answers
40 views
Connect to Create a New Unity Catalog using a onprem postgres database connect
Have datbricks on azure platform with admin acces. I have serverless sql warehouse where i have imported some csv data into a catalog. Now i need to access postgres data on onprem linux box. Need to ...
1 vote
1 answer
130 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
60 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
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 ...
0 votes
0 answers
57 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
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 ...
0 votes
0 answers
124 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
310 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
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
1 vote
1 answer
553 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
467 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
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