For specific questions on Microsoft's JDBC driver for their SQL Server product.
For specific questions on Microsoft's JDBC driver for their SQL Server product.
Microsoft JDBC Driver for SQL Server
Related tags: 
sql-serversqljdbc
Questions tagged [mssql-jdbc]
603 questions
0
votes
1 answer
Long Running Query on MSSQL
In my team, we need to connect to Oracle, Sybase and MSSQL very frequently... We use Oracle's SQLDeveloper 3.3.2 Version to connect all 3 (using third party libs). This tool often has a problem that select queries never ends... Even if we get the…
Arpit Jain
- 13
- 3
0
votes
0 answers
Sqljdbc jar in classpath
Can anybody guide me how to run a maven project jar along with sqljdbc jar in the classpath from the command prompt??
Im currently running the following command from command prompt :
java -cp streaming-etl-0.1.2-SNAPSHOT.jar:sqljdbc4.jar…
Girish kumar
- 735
- 6
- 8
0
votes
1 answer
JPA Hibernate + MS SQL java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
I have a field in MyRecord.java class:
@Column(name="BILLABLEDATE", nullable = true)
@Temporal(TemporalType.TIMESTAMP )
private Date billableDate;
The value saved against the column(datetime) is:
2017-03-31 12:20:44.360
While…
Zubair
- 5,833
- 3
- 27
- 49
0
votes
1 answer
SQL server JDBC driver close statement takes too long
We are using SQL Server 2014. From the Java application using the Microsoft SQL server JDBC driver (latest one released in Jan'17) to connect to the SQL Server DB.
From the monitoring tool (App Dynamics), we find the statement close sometimes takes…
Nivedita Dixit
- 181
- 1
- 3
- 12
0
votes
2 answers
Connection Pool for Tomcat in Eclipse for MS Sql Server
Ok I'm trying to set up a Connection Pool in a Vaadin webapp, and I hear that it's better to make Tomcat do the connection pooling. So I've
been going through some Youtube videos and a lot of tutorials and I'm too bad at this to get it to work. I…
arsarc
- 443
- 1
- 9
- 22
0
votes
1 answer
Load file into Azure DB with MSSQLConnection
I just want to load some files into a Azure DB.
I am using the "Microsoft SQL Server" DB Type for the connection.
The problem is that when I insert like more than 10.000 rows, I have sometimes (90% of the time) an error:
Exception in component…
Gaston G
- 396
- 3
- 19
0
votes
2 answers
Why is Pentaho Report Designer adding parameter named "ce" to Database Connection of the report?
I am forced to use Pentaho Report Designer 5.4 and have following problem: Every time i try to make changes to Database Connection of the report, inside Options section designer adds parameter "ce" without any value - even if i previously deleted it…
Tornike Shavishvili
- 1,244
- 4
- 16
- 35
0
votes
1 answer
Space in parameters for Azure SQL Data Warehouse connection string
I am upgrading my JDBC connection string right now on my Azure SQL Data Warehouse to the new specifications, specifically, adding the following to it: Application Name=MyApp.
Here's my issue. I connect to my server using the following…
theGreenCabbage
- 5,197
- 19
- 79
- 169
0
votes
1 answer
Android App error connecting to Azure SQL DB via ms jdbc
I am new to Android app development and I'm trying to connect to an Azure SQL DB with the native MS JDBC driver (sqljdbc4.jar) and I keep on getting the following error:
"Error connection: The driver could not establish a secure connection to SQL…
capt vimes
- 1
- 1
0
votes
4 answers
Getting different resultset based on data type
I have a table tbl_item in which item_id is varchar. when i use the queries below 1 get different results.
select * from tbl_item where item_id between 1 and 100 order by item_id
select * from tbl_item where item_id between '1' and '100' order by…
Aamit
- 1
- 1
0
votes
1 answer
Cannot get auto generated ID from MSSQL with JDBC
public String getKey() {
Connection con = null;
Statement stmt = null;
String generatedKey = null;
try {
con = dataSrc.getConnection();
stmt = con.createStatement();
// ask to return generated key
…
user6309529
- 153
- 1
- 3
- 16
0
votes
4 answers
Liquibase generated changelog XML - ERROR cvc-complex-type.2.3 when used to migrate SQL Server
I've seen this similar topic before, but without a resolution.
http://forum.liquibase.org/topic/liquibase-validation-can-we-turn-it-off
The problem is a validation error that ONLY happens using "migrate" on SQL Server. The same file can be used to…
adrock
- 1
- 1
- 3
0
votes
1 answer
Getting database disk size data mssql
I am quite new to mssql and I would like to know is there any query that I can used in order to collect the disk size assigned to the sql server and the percentage of disk size already used by the server?
Kennedy Kan
- 273
- 1
- 7
- 20
0
votes
1 answer
Dynamic pivot in SQL Server database
I'm writing a query where there is pivot table that has to generated. Right now below is my code.
select *
from
(select [case owner], [time taken(minutes)] from StatusTable) as pivotdata
pivot(
sum([time taken(minutes)])
for [CASE OWNER] in
("XXX",…
Rakesh
- 564
- 1
- 8
- 25
0
votes
1 answer
I wanted to insert data into Microsoft sql table but encountered incorrect syntax near ' '
I have been trying to insert data into Microsoft SQL table but it says incorrect syntax near ''. What could have gone wrong?
This is my data:
insert into Course_Relation
('DBA','Diploma_in_Business_Administration', 'SB'…
Tragend
- 17
- 1
- 3