All Questions
Tagged with java sql-server
20 questions
0
votes
0
answers
38
views
Metabase error when connecting to SQL Server 2016, happens on RHEL9 but not on RHEL7, why?
We are testing an upgraded instance of Metabase, and the upgraded components include
RHEL (from v7 to v9) operating system,
Java (from 11 to 21), and
Metabase software (from v0.32.x to v0.50.x as the ...
- 57
1
vote
1
answer
5k
views
Can Microsoft JDBC Driver 4.0 connect to SQL Server 2019 and perform DML without issue?
The SQL version compatibility BOL article advises that the minimum compatible JDBC driver version for SQL Server 2019 is 7.4.
Can an older JDBC driver still connect to SQL Server 2019? Or can only the ...
- 1,464
-2
votes
1
answer
49
views
Should I use the LIKE predicate or fetch all rows and process them on the client?
I am optimizing my application, while this task, I find one query which is fetching data from database using like .
and database rows are around 10000.
So is this a good way to use like in query or I ...
0
votes
0
answers
760
views
SQLServer JDBC Driver]Object has been closed
I had few queries in code which were running in loop. They all were wrapped inside a code function. There were frequent deadlock with the queries. Because I do not understand the logic too well, I was ...
- 101
-1
votes
2
answers
628
views
executing SQL query with temp tables using 1.6jdk
I created a batch to run a query that has temp tables as the below example
IF OBJECT_ID ('tempdb..#TEMP1') IS NOT NULL
DROP TABLE #TEMP1
select *
into #TEMP1
from cutomer
IF OBJECT_ID ('tempdb..#...
1
vote
0
answers
634
views
Encrypt through Java and Decrypt through SQL Server AES 256
Am trying to insert some value through JAVA Application with AES Algorithm and need to decrypt the data from the SQL Procedure and need to process a data.
Which is the best practice to do so?
- 21
1
vote
1
answer
2k
views
sql server query execution plan via jdbc driver
is there a way to fetch the XML generated by the "Actual Execution Plan" in SQL server 2012 - 2014, but via JDBC driver for Java -- sqljdbc_6.0.8112.100_enu? (preferable forward compatible with 2016)
...
-1
votes
2
answers
6k
views
After inserting the character ñ in a table the character will be converted like ñ
when we are inserting the character ñ from application in a table the character will be converted like ñ.
I have verified general log and binlog the charecter is showing correctly ñ but when ...
2
votes
2
answers
152
views
What does "+date+" mean in this context?
select LTRIM(RTRIM(convert(char(10), max(date), 101))) as str
from inventory
where date < '" + date + "'"
I happen to see this a lot in my Java code. Can someone please re-phrase the query ...
- 177
1
vote
4
answers
2k
views
Load testing: The performance of a query is decreasing as the number of parallel executions is increasing
I'm seeing a slow down when doing load testing on my app.
I have a query that takes about 350ms to run, but what I run it in parallel 8 times (not to mention 32 times), it goes up to 2.5 seconds.
I ...
- 119
1
vote
1
answer
4k
views
Exception while inserting records in SQL Server (Error message id : 586)
I am getting an exception when doing a batch insert operation using a prepared statement from Java.
java.sql.BatchUpdateException: The prepared statement handle 5 is not
valid in this context. ...
- 111
1
vote
2
answers
1k
views
Parameterized query is taking more than 30 min to execute in SQL Server Database using SQL Developer, non-parameterized taking 60sec
I am a java developer. I don't have a deeper knowledge on the database part (may be I should have). I am firing several complex queries from java to a SQL Server database & it is returning data ...
- 121
0
votes
1
answer
669
views
Retrieving data from stored procedure's cursor
I want to use the ResultSet in java program to get data from Stored procedure's cursor. Is that possible with SQL Server?
My code:
CREATE PROCEDURE dbo.SampleProcedure AS
DECLARE @FirstName ...
- 115
0
votes
1
answer
1k
views
Real time or close to real time with MySQL or MSSQL
I work at a startup that is working with different databases among which are MySQL (v4/5) and MSSQL (2014 and older). Different clients we cater to run different dbs. Currently we have a Java program ...
- 23
2
votes
2
answers
17k
views
Are there any special characters that are never allowed in SQL?
I am a Java programmer. We always make database-related things configurable so that they can be easily modified by the DB team as per their requirements.
I want to make some queries as configurable, ...
- 121