Questions tagged [jtds]
Open source JDBC driver for MS SQL Server and Sybase ASE
jtds
433
questions
61
votes
5
answers
230k
views
Create a jTDS connection string
my sql server instance name is MYPC\SQLEXPRESS and I'm trying to create a jTDS connection string to connect to the database 'Blog'. Can anyone please help me accomplish that?
I'm trying to do like ...
- 70.8k
49
votes
0
answers
56k
views
List of JDBC drivers for SQL Server 2008 (comparison) [closed]
I am in the process of evaluating a whole whack of JDBC drivers, specifically to use with SQL Server 2008 with Windows authentication. I gathered a list of ones that I found and have listed them below....
- 3,721
34
votes
6
answers
44k
views
differences between ms sql microsoft's jdbc drivers and jTDS's driver
What are the differences between each driver? I mean, besides one of them being open-source
What are the pros / cons of each one?
Which one would you recommend?
here's jTDS own opinion on the ...
- 62.2k
31
votes
4
answers
25k
views
Is it possible to run multiple DDL statements inside a transaction (within SQL Server)?
I'm wondering if it is possible to run multiple DDL statements inside a transaction. I'm specially interested on SQL Server, even though answers with other databases (Oracle, PostgreSQL at least) ...
- 11.6k
22
votes
2
answers
20k
views
Unsupported version error using JTDS with Scala
I'm trying to use the Java JTDS driver to connect to my database in Scala . However, whenever I try to use it I get an error that the version(of java?) is wrong.
java.lang....
- 4,935
21
votes
3
answers
15k
views
AbstractMethodError with jTDS JDBC Driver on Tomcat 8
I am deploying a web app (WAR) to a Tomcat 8 web container.
The WAR includes in the '/WEB-INF/lib' directory the following jTDS JDBC driver:
<dependency org="net.sourceforge.jtds" name="jtds" rev=...
- 26.9k
16
votes
3
answers
19k
views
Configure HikariCP in Spring Boot with JTDS
I want to add a connection pool to my existing web application, which has been made using Spring Boot 1.5.1.
The datasource configuration is made in application.properties as follows:
spring....
- 1,785
16
votes
1
answer
12k
views
Why is JTDS faster than Microsoft JDBC driver?
we're comparing JTDS and Microsoft SQL Server for a Java EE application running on JBoss and we're finding that JTDS is from 30% to 50% faster, benchmarking the application in a high concurrence ...
- 4,142
14
votes
5
answers
71k
views
A ResourcePool could not acquire a resource from its primary factory or source
I'm trying to connect to a database in Java, using jdbcTemplate and I'm gettin the error below. I have Googled for a long time and all solutions I found didn't solve my problem. I tried several ...
- 3,159
14
votes
6
answers
26k
views
The driver could not establish a secure connection to SQL Server by using SSL
I'm having problems connecting to SQL databases. Whenever I try to connect to a SQL server I get the following error;
Caused by: org.hibernate.exception.JDBCConnectionException: Error calling Driver#...
- 530
13
votes
5
answers
58k
views
What is the jTDS JDBC Connect URL to MS SQL Server 2005 Express
I'm trying to connect to a MS SQL Server 2005 Express database that is running on the local host from a java program.
I have tried the same connect URL (below) that I used on another system (same ...
- 54.3k
13
votes
3
answers
10k
views
Java SQL Result to InputStream
I need a Java function that returns the results of a SQL SELECT query as an InputStream parameter for another system that sends the result over a network.
However, the InputStream must be of a String ...
- 2,291
12
votes
3
answers
48k
views
jTDS connection string: connect to a MS SQL Server instance with a backslash
I am using the jTDS driver in a Java application. The database administrator told me that the SQL Server instance name is
MSSQL-DB09v1\v1
How should I write the connection URL?
I have been using ...
- 14.5k
11
votes
3
answers
8k
views
What are the advantages or disadvantages of switching to JTDS driver from Microsoft jdbc driver? [closed]
I have here a situation. I have a almost release ready (release in 2 month) application that runs queries on the microsoft Sql-Server database.We use the standard Microsoft jdbc driver implementation ...
- 8,123
10
votes
8
answers
5k
views
Stored proc running 30% slower through Java versus running directly on database
I'm using Java 1.6, JTDS 1.2.2 (also just tried 1.2.4 to no avail) and SQL Server 2005 to create a CallableStatement to run a stored procedure (with no parameters). I am seeing the Java wrapper ...
- 3,722
9
votes
4
answers
25k
views
JTDS driver not working for Sql Server 2008R2 and Denali Native SSPI library not loaded. Check the java.library.path system property
I am trying to connect Sql Server Data Base using windows authentication from my application using JTDS driver but i got following error
SSO Failed: Native SSPI library not
loaded. Check the java....
- 896
9
votes
9
answers
29k
views
Authenticating to a SQL Server instance as a Windows User via JDBC
I'm having to support multiple database types for my tenant-enabled web application. Among others, I have successfully supported Microsoft's SQL Server, by using the net.sourceforge.jtds.jdbc.Driver ...
- 14.2k
9
votes
2
answers
3k
views
Wrong data type returned for date in jtds.jar
I have a table on MS SQL Server with a column having data type as date. I am using jtds.jar for JDBC connection with DB. I am taking DatabaseMetaData from Connection. While checking columns from ...
- 103
8
votes
6
answers
108k
views
java : non-static variable cannot be referenced from a static context Error
The following code is generating an error on the variable con2 saying "non-static variable con2 cannot be referenced from a static context Error." I Googled for a resolution and they are suggesting ...
- 13.7k
8
votes
1
answer
4k
views
is JTDS driver outdated?
I'm now trying to decide which driver to use to create a DataSource from my JavaEE application to MS SqlServer.
A couple of years ago I had good experience with JTDS, and SO answers suggest that JTDS ...
- 17.4k
7
votes
2
answers
18k
views
Java Hibernate with SQL Server 2012 not working?
I have a Java Hibernate project configuration which worked with SQL Server 2008 R2, now with a new OS 8.1 (from 7) and SQL Server 2012 (express), I'm unable to connect to SQL server.
Relevant ...
- 8,289
7
votes
2
answers
20k
views
JDBC (JTDS) SQL Server Connection Closed after SSL Authentication
I am using the jTDS JDBC SQLServer library to connect to a SQL Server 2008 database. It always worked without SSL but once we enabled it, I haven't been able to get it to connect. I've traced the Java ...
- 133
7
votes
3
answers
33k
views
Java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver On Android
Today I am doing Connectivity of SqlServer using JTDS driver. But when I run program
I found Below error
Java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
Caused by: java.lang....
- 1,016
7
votes
1
answer
24k
views
Cannot load JDBC driver class 'net.sourceforge.jtds.jdbc.Driver' when compiling Grails project
This is my first post so be gentle! :)
I've set up a grails project (fairly new at grails too) and am attempting to connect it to a SQL 2008 database, I've added the jtds-1.3.0.jar to the lib folder ...
- 884
7
votes
3
answers
41k
views
ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
I have java code which connects to a MS-SQL database and procures some data.
Before running the code I set the class path in the Unix Server and it used to work fine.
But for some reason the same ...
- 2,271
7
votes
2
answers
4k
views
How can I support the SQL GO statement in a Java / jtds application?
I'm working on a Java based OSS app SqlHawk which as one of its features is to run upgrade sql scripts against a server.
Microsoft have made it a convention to split a script into batches with the GO ...
- 11.6k
7
votes
1
answer
4k
views
jTDS + stored procedures + prepareSQL = nesting level error?
Situation
I have a (Tomcat) Java web application using jTDS to connect to a MSSQL 2008 database. This Java application executes 99% of its MSSQL stored procedures using user input.
Problem
The jTDS ...
- 835
6
votes
3
answers
24k
views
connecting to local MS SQL Server
I have a local MS SQL Server and I am trying to connect to it using JTDS in java. Here is the connection string:
Class.forName("net.sourceforge.jtds.jdbc.Driver");
Connection conn = DriverManager....
- 2,299
6
votes
4
answers
8k
views
Configuration of JTDS for use with HikariCP + Spring + MS SQL Server
I kept googling for configuration of JTDS (1.3.1) for use with HikariCP (2.4.3), Spring (4.1.2), and MS SQL Server (2008), but unable to find a complete and working example.
Here is what I have:
<...
- 14.5k
6
votes
2
answers
5k
views
jTDS JDBC Driver: getNString() throws error
I am using the jtDS JDBC driver and when I call ResultSet.getNString(index); I get the following exception:
run:
Exception in thread "main" java.lang.AbstractMethodError: net.sourceforge.jtds.jdbc....
- 6,913
6
votes
2
answers
8k
views
Sql Developer connector to Sql Server 2012 - error "Vendor code 207"
I am trying to connect from Sql Develper 4.0.3.16 to Sql Server 2012, with jTDS connector jtds-1.3.1.jar.
OS: Ubuntu 14.04
Java:
~$ java -version
java version "1.7.0_72"
Java(TM) SE Runtime ...
- 12.1k
6
votes
3
answers
3k
views
Connecting to MSSQL(jtds) with Play and Slick
I have a project that's been finished for about a month that I made using Play 2.1.1, slick, and MySQL. Now I need to move this over to MSSQL and I'm having some issues.
My application compiles fine, ...
- 1,419
6
votes
2
answers
3k
views
SQL Server JBDC Driver comparison
Currently we use jtds for connecting to our SQL Server databases. I've always taken it for granted that we use it due to performance and reliability reasons, however, it's usage pre-dates my ...
- 17.7k
6
votes
1
answer
1k
views
using the datetimeoffset datatype with jTDS
jTDS currently doesn't support the datetimeoffset datatype introduced in SQL Server 2008.
Can anybody suggest if there is a way to use the datetimeoffset type with jTDS?
- 61
6
votes
1
answer
9k
views
Issues getting JTDS driver to accept sendStringParametersAsUnicode=false?
Been using net.sourceforge.jtds.jdbc.Driver as my driver from MSSQL for all my applications. I had trouble with performance in a prepared statement, and learned that sendStringParametersAsUnicode=...
- 702
6
votes
1
answer
426
views
Issue with Chinese characters in Linux environment with SQL Server 2005
I am trying to get Chinese characters from a SQL Server 2005 database server with my web application hosted with Jboss server on a Linux box (RHEL). The issue is that the Chinese characters never get ...
prashanth
5
votes
1
answer
8k
views
Java connection to Sql server with jtds error
I use this code to make a connection with Sql server and i get that error
when i use Class.forName(driver) it connect correctly but i prefer to use DataSourse.
static final BasicDataSource dataSource ...
- 63
5
votes
1
answer
2k
views
is it possible to get the query plan out using jdbc on sql server?
I am using the JTDS driver and I'd like to make sure my java client is receiving the same query plan as when I execute the SQL in Mgmt studio, is there a way to get the query plan (ideally in xml ...
- 3,722
5
votes
2
answers
19k
views
SQLException: Invalid parameter index 1 only with PreparedStatement
I have got a webapp(JSP/Servlet) with Tomcat8 + SQL Server2012
JDBC Driver Type 4: JTDS old version 1.2.5 (http://jtds.sourceforge.net/)
I change this kind of query, adding Prepared Statement (...
- 479
5
votes
1
answer
2k
views
jtds ignores setFetchSize. How can I limit the fetch size?
I am trying to limit the fetch size of my select query.
Unfortunately the JTDS MS SQL driver still reads all rows.
I do not want a limit or offset select.
I just want to save my memory such that I ...
- 9,118
5
votes
2
answers
14k
views
Connection URl for SQLExpress database using Hibernate
I am using jtds drivers to connect to SQL Server on local using Hibernate
I can conect to server using server name: COMP6\SQLEXPRESS
Below is my connection properties in hibernate.cfg
<property ...
- 14.9k
5
votes
2
answers
9k
views
Database connection unexpectedly closed with Glassfish, jTDS and SQL Server 2008
I have a Java EE application running on Glassfish and connecting to MSSQL Server 2008 through jTDS. For some unknown reason, the database connection becomes unexpectedly closed during requests. The ...
- 7,282
5
votes
4
answers
7k
views
jTDS socket hanging with C3P0 connection check (SQL Server 2008 R2)
Here is the environment:
Java 5
Web application running in Tomcat 6.0.18 on Windows (not sure the version)
Database: SQL Server 2008 R2
JDBC Driver: jTDS 1.2.5
Connection pool provider: C3P0 0.9.1.2
...
- 8,565
5
votes
2
answers
23k
views
SQL server "Lock request time out period exceeded" .. again
I'm having a problem trying to extend the lock timeout in a sql server SP. No matter what I try it keeps throwing "Lock request time out period exceeded".
I'm using java + jtds 1.2.2, c3p0 0.9.1 and ...
- 83
5
votes
1
answer
3k
views
How to obtain renewable kerberos tickets using java GSS+JAAS
I am using jTDS to connect to SQLServer. Internally jTDS uses GSS to obtain a kerberos' service ticket and establish a secure context. Since my app is long lived and my connections are kept alive the ...
- 1,858
5
votes
0
answers
10k
views
Cannot load JDBC driver class 'net.sourceforge.jtds.jdbc.Driver' [closed]
I have some problems with jtds.
I'm using Hibernate, Tomcat 5.5 on Linux Red Hat Server, SQL Server 2005 with WIndows Server
I save the library into Web-iNF/lib and i'm using the version jtds-1.2.2
...
- 61
4
votes
1
answer
4k
views
FATAL EXCEPTION: main java.lang.VerifyError: net.sourceforge.jtds.jdbc.TdsCore
In my Android project I'm using jtds.jdbc for connecting to SQL Server database. While trying to connect I wrote wrong connection string which threw an error saying: "Network error IOException: ...
- 898
4
votes
3
answers
9k
views
JTDS and JBOSS JDBC Connection Pool Problem, any solution? Maybe a custom ValidConnectionChecker?
I'm facing a weird production problem. Environment is the following:
JBOSS 4.0.2
SQL Server 2005
Driver JTDS 1.2.5
From time to time the following szenario occurs.
A SQL command fails to Excute ...
- 599
4
votes
2
answers
18k
views
java.sql.SQLException: Login failed for user 'admin'
Disclaimer: I have never used SQL server before.
I am trying to connect to SQL server Express using java code.
public class Test1 {
public static void main(String[] args) throws SQLException, ...
- 1,812
4
votes
3
answers
12k
views
Using JDBC when server name contains a backslash (localhost\TESTDATA)
thanks for taking the time to read this. I'm completely stumped by what is probably a simple thing. I am trying to make a connection to my SQL database, the following tends to work:
String url = "...
- 640