Stack Overflow
Stack Overflow

Questions tagged [mssql-jdbc]

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:

603 questions
0
votes
0 answers

How to add sqljdbc_auth.dll to eclipse class path

I have an error my program doesn't found the sqljdbc_auth.dll. How to add it to the class path ? Could any one give a little more details please ?
Amine Soumiaa
  • 683
  • 5
  • 13
0
votes
0 answers

SQL Server Bulk insert error - file not found

I'm trying to import the CSV file values using bulk insert but I'm getting an error in my code. Can anyone help me with this? The following is the code I wrote: SET NOCOUNT ON BULK INSERT JBLOADER.dbo.FBNK_TELLER FROM…
Karthick88it
  • 601
  • 2
  • 12
  • 28
0
votes
2 answers

MSSQL SELECT Statement Error in WHERE clause

I'm running simple java code to get results from DB. But it always gives index 1 is out of range. How can I set variable in to WHERE clause public String getTransNumberFromDB(String cli) throws Exception { System.out.println(clid); String…
dmaprasad
  • 301
  • 2
  • 7
  • 17
0
votes
1 answer

Android: Async dobackground() not working properly while connecting to database

I am trying to connect to mssql server database using jtds in AsyncTask. At line, con = DriverManager.getConnection(connString); when it comes on this line, after 3 or 4 secs AsyncTask.java file on Execute function and after that application…
Hamza Zaidi
  • 401
  • 7
  • 15
0
votes
0 answers

SQL server agent (SQLEXPRESS) unable to start service

Could not start service for server agent, tried as local service, Checked TCP-IP port and it is enabled, I got connection refused while at net.sorceforge.jtds.jdbc.connection, the project is working on other environment, Driver manager could not…
Goso
  • 1
  • 1
0
votes
2 answers

Error when I set parameters to PreparedStatement

I have MSSQL procedure: my_proc I get data from java String sql = "exec my_proc '2016-01-01','2016-01-20','2016-01-01'"; stmt = connection.prepareStatement(sql); rs = stmt.executeQuery(); and get all data fine! but if I use String msisdn, String…
user5620472
  • 2,722
  • 8
  • 44
  • 97
0
votes
1 answer

Issue in Debuging Maven Java Application in Netbeans

I am working on a Netbeans Maven Java Application in Netbeans. I am working on Hibernate I got these errors. I used hibernate.cfg.xml as Hibernate configuration and defined sqljdbc4 driver of sql server in hibernate.cfg.xml file. My question is, Is…
Mehar Abdullah
  • 13
  • 4
0
votes
1 answer

DATEDIFF not working in JAVA

Am running a query from JAVA , the query contains DATEDIFF function in which the parameter is a keyword,we can give yy,mm,day,etc.. so am getting these keyword from user as parameter and setting it in query, but the issue is it wont execute, it…
Anoop LL
  • 1,548
  • 2
  • 21
  • 32
0
votes
3 answers

How to get difference betwen two dates in SQL Server

SELECT DATEDIFF(minute, CONVERT(VARCHAR, CURRENT_TIMESTAMP, 102), CONVERT(VARCHAR, t.xxxxxx, 102)) AS daydifference FROM (SELECT MAX(autoid), xxxxxx FROM Xtable WHERE uid = 3) t; I am getting error at last "t". No column name…
gsr
  • 11
  • 3
0
votes
1 answer

Paged query on entity with calculated field

I have a paged query on a view where one of the fields is anottated with @Formula (Using ajahe ebean query). When running the query on a page > 0 I get an error: PersistenceException: Query threw SQLException:No column name was specified for column…
L.S
  • 192
  • 1
  • 6
0
votes
1 answer

SQLServerException: Arithmetic overflow error converting numeric to data type numeric

I have the stored procedure with the following signature: CREATE PROCEDURE my_proc @param1 varchar(4), @param2 varchar(4), @param3 bit, @param4 decimal(14,4), @param5 varchar(10) …
gstackoverflow
  • 36,709
  • 117
  • 359
  • 710
0
votes
1 answer

How to generate unique numbers in a SQL Server database

I want to maintain all columns in all tables in a database by unique id and ID should be in increasing order. When I will add a column in any table of database, the column should uniquely identified by its id in whole database.
NecessaryDevil
  • 105
  • 1
  • 10
0
votes
2 answers

get the string after check 2nd comma separated string not in 1st comma separated string

I have a table named BTSQMTAsk and it has two tasks in it. each task will have a column CompletedID, is a comma separated column. i need to return the completedID of a task not in the 2nd task(remember both are comma separated values). please help…
sison kk
  • 79
  • 12
0
votes
1 answer

Microsoft JDBC Driver is not working after upgrade from Java 1.7 to Java 1.8

After upgrading from Java 1.7 to Java 1.8, I am getting the below error when having sqljdbc4.jar (version 4.0) in my build path. How can I resolve this problem?
String
  • 3,660
  • 10
  • 43
  • 66
0
votes
1 answer

How do I resolve mssql resetting connections

I keep getting this error randomly when I test an application with mssql and don't have an idea of what I can do to correct the issue. Exception [EclipseLink-4002] (Eclipse Persistence Services -…
Bwire
  • 1,181
  • 1
  • 14
  • 25
1 2 3
…
40 41