All Questions
Tagged with sql-server java
4,270
questions
0
votes
0
answers
34
views
Unable to Connect to Azure SQL Server Database Using JDBC Driver in Android App
I'm developing an Android app and trying to connect to an Azure SQL Server database using the JDBC driver. I'm encountering a java.lang.AssertionError related to SSL/TLS communication. Below is the ...
- 1
-3
votes
0
answers
47
views
Not able to get multiple tables with different data properly [closed]
I want to populate a Jasper Report with multiple tables for given range of employees to show their details fetched from a SP and populated in my table in each page.
But whenever multiple employees ...
0
votes
0
answers
23
views
Error with MSAL4J in RJDBC with ActiveDirectoryMSI
I am trying to establish a connection in Mac via the company portal with R. I am basically trying to copy a connection that actually works with DBeaver, using RJDBC.
It returns this error:
Failed to ...
- 359
0
votes
0
answers
35
views
Setting up liquibaseSchemaName for Liquibase with MS-SQL Server
I am using Liquibase with SQL Server (Microsoft SQL Server 2016) and Spring Boot. By default, Liquibase uses the dbo schema for the databasechangelog and databasechangeloglock tables. However, I want ...
- 294
-1
votes
0
answers
57
views
Out of memory error while writing huge file to Database using fileStream
I am trying to upload file upto 20 GB to Database Table, where FILE_DATA column is enabled by FileStream. But I can only upload upto 1GB. From 2GB onwards out of memory exception occurs
...
- 19
-2
votes
1
answer
53
views
Hibernate forces foreign key to be non-null
I want a Product to have an optional ProductType.
But during schema generation, Hibernate for some reason ignores my definition and creates a non-nullable column for a foreign-key.
We are using ...
- 638
1
vote
1
answer
50
views
Ordinal enum mapping with Hibernate 6.5
I'm upgrading Hibernate from 6.1.7 to 6.5.2, there are many enum columns in my entities marked with
@Enumerated(EnumType.ORDINAL). My codebase has to run against both Oracle and SQL Server.
The ...
- 513
0
votes
1
answer
60
views
JPA entity ID field with a SQL Server 2022 Sequence
I am trying to connect my Spring Boot service to a SQL Server 2022 database, but I am having issues with a sequence:
public class SomeEntity {
@Id
@SequenceGenerator(name = "some_seq"...
- 55
0
votes
1
answer
70
views
Incorrect Syntax near ',' in SQL query execution in Spring JPA but executes successfully in database
I am using Java 8 and have an update query with 3 columns concatenated to one in the where clause. the query works perfectly in the SQL Server, but when I execute from the code, it results in ...
- 127
0
votes
0
answers
29
views
format SQL SP result into json fomat in Spring Boot
I am getting data from SQL Stored Procedural and I want to manipulate on that data as array of json objects, In laravel it is simple and straight because the result is in the collection of object, but ...
- 794
0
votes
2
answers
78
views
SQL like query contains only a specific character
I'm trying to get records from SQL server starting with abc_ followed by at least one letter (a-z, A-Z) and then continue to the end with just letters and numbers (a-z, A-Z, 0-9). No special ...
- 1
-2
votes
0
answers
98
views
When we have multiple data sources and one went down or firewall issue how can we catch and up the spring boot app?
i have one spring boot application, which has three databases connections, one is oracle, two more with SQL server, to connect one of the sql server in local environment we need to open fire wall, ...
- 71
0
votes
0
answers
34
views
Executing a Long-Running Stored Procedure in Azure SQL Server with Spring Boot
I need to run a stored procedure on my Azure SQL Server that takes about 20 minutes to complete. Normally, I use Spring to perform this kind of operation:
public interface MyRepository extends ...
- 178
0
votes
1
answer
81
views
Fetching 30k+ Columns with JDBC Cursor - Arithmetic Overflow
I'm encountering an unusual issue while using a JDBC cursor to fetch data from SQL Server. My client needs to retrieve a very large number of columns (over 30,000) from a single table.
Problem: ...
- 102
1
vote
1
answer
121
views
How to avoid "SQLServerException: The query processor ran out of internal resources and could not produce a query plan."
I'm issuing the following query, via java.sql.Statement.executeQuery():
SELECT columns FROM Table1, Table2
WHERE ( ColX IN (...) OR ColX IN (...) OR ... OR ColX IN (...) )
AND Table1.Col1 = Table2....
- 51