Stack Overflow
Stack Overflow

Questions tagged [jtds]

Open source JDBC driver for MS SQL Server and Sybase ASE

jTDS

jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000, 2005, 2008 and 2012) and Sybase Adaptive Server Enterprise (10, 11, 12 and 15).

jTDS is based on FreeTDS and is currently the fastest production-ready JDBC driver for SQL Server and Sybase ASE. jTDS is 100% JDBC 3.0 compatible, supporting forward-only and scrollable/updateable ResultSets, concurrent (completely independent) Statements and implementing all the DatabaseMetaData and ResultSetMetaData methods.

References

433 questions
62
votes
5 answers

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…
Omu
  • 69,856
  • 92
  • 277
  • 407
49
votes
0 answers

List of JDBC drivers for SQL Server 2008 (comparison)

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. My question is, are there any other JDBC…
Ayyoudy
  • 3,641
  • 11
  • 47
  • 65
33
votes
6 answers

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 subject: http://jtds.sourceforge.net/
opensas
  • 60,462
  • 79
  • 252
  • 386
31
votes
4 answers

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) could also be interesting. I've been doing some…
Touko
  • 11,359
  • 16
  • 75
  • 105
22
votes
2 answers

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.UnsupportedClassVersionError: net/sourceforge/jtds/jdbcx/JtdsDataSource :…
stan
  • 4,885
  • 5
  • 49
  • 72
21
votes
3 answers

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: (file is: jtds-1.3.1.jar). This is how…
Marcus Junius Brutus
  • 26,087
  • 41
  • 189
  • 331
16
votes
1 answer

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 scenario and keeping exactly the same HW/SW but…
massimogentilini
  • 4,102
  • 5
  • 29
  • 32
16
votes
3 answers

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…
joninx
  • 1,775
  • 6
  • 31
  • 59
14
votes
6 answers

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#connect at…
Mees Kluivers
  • 520
  • 2
  • 6
  • 26
14
votes
5 answers

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 different DBs (both SQLServer and MySQL) and none…
iomartin
  • 3,149
  • 9
  • 31
  • 47
13
votes
5 answers

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 jave code) that was running MS SQL Server 2000. But…
Ron Tuffin
  • 53,859
  • 24
  • 66
  • 78
12
votes
3 answers

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 something like…
curious1
  • 14,155
  • 37
  • 130
  • 231
12
votes
3 answers

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 with custom delimiters (i.e. often, but not…
Cameron S
  • 2,251
  • 16
  • 18
11
votes
3 answers

What are the advantages or disadvantages of switching to JTDS driver from Microsoft jdbc driver?

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 for sql-server. Works great,no problems. Now…
Roman
  • 7,933
  • 17
  • 56
  • 72
10
votes
8 answers

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 running the same stored procedure 30% slower than…
James B
  • 3,692
  • 1
  • 25
  • 34
1
2 3
…
28 29