1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
|
<html>
<head>
<title>jTDS JDBC Driver</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Keywords" content="jTDS, open source, free JDBC driver, free driver, free, JDBC, JDBC 2.0, JDBC 3.0, driver, type 4, pure Java, SQL Server, Sybase, SQL Server 6.5, SQL Server 7.0, SQL Server 2000, SQL Server 2005, SourceForge">
<link rel="stylesheet" href="style.css" type="text/css">
</head>
<body>
<table class="mainTable" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3" class="logoWrapper">
<table cellpadding="0" cellspacing="0" class="logo">
<tr>
<td class="logo"><img src="images/logo.gif" alt="The jTDS Project" class="logo"></td>
<td class="logo"><img src="images/logoBg.gif" class="logoBg"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td width="9" height="9"><img src="images/maintl.gif" width="9" height="9"></td>
<td height="9" background="images/maint.gif"><img src="images/spacer.gif"></td>
<td width="9" height="9"><img src="images/maintr.gif" width="9" height="9"></td>
</tr>
<tr>
<td width="9" background="images/mainl.gif"><img src="images/spacer.gif"></td>
<td class="content">
<p class="links">
<span class="selected">Home</span>
| <a href="faq.html">FAQ</a>
| <a href="doc.html">Documentation</a>
| <a href="links.html">Links</a>
| <a href="license.html">License</a>
| <a href="http://sourceforge.net/projects/jtds">Project Info</a>
| <a href="http://sourceforge.net/project/showfiles.php?group_id=33291">Download</a>
| <a href="http://sourceforge.net/news/?group_id=33291">News</a>
| <a href="http://sourceforge.net/tracker/?group_id=33291&atid=407762">Bugs</a>
| <a href="http://sourceforge.net/forum/?group_id=33291">Forums</a>
</p>
<!--
==================================
Content starts here
==================================
-->
<p class="title">Overview</p>
<p>jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for
Microsoft SQL Server (6.5, 7, 2000, 2005 and 2008) and Sybase (10, 11,
12, 15). jTDS is based on <a href="http://www.freetds.org">FreeTDS</a>
and is currently the fastest production-ready JDBC driver for SQL Server
and Sybase. jTDS is 100% JDBC 3.0 compatible, supporting forward-only
and scrollable/updateable <code>ResultSet</code>s, concurrent
(completely independent) <code>Statement</code>s and implementing all
the <code>DatabaseMetaData</code> and <code>ResultSetMetaData</code>
methods. Check out the <a href="features.html">feature matrix</a> for
more details.</p>
<p>Quite a few of the commercial JDBC drivers out there are based on jTDS
(or FreeTDS), even if they no longer acknowledge this. jTDS has been
tested with virtually all JDBC-based database management tools and is
the driver of choice for most of these (recommended for
<a href="http://www.minq.se/products/dbvis/drivers.html#sqlserver">DbVisualizer</a>
and <a href="http://squirrel-sql.sourceforge.net">SQuirreL SQL</a>,
distributed with <a href="http://www.aquafold.com">Aqua Data Studio</a>
and <a href="http://www.datadino.com">DataDino</a>). jTDS is also
becoming a common choice for enterprise-level applications: it passes
both the <a
href="http://java.sun.com/products/jdbc/download.html#testsuite131">
J2EE 1.3 certification</a> and <a href="http://www.hibernate.org">Hibernate</a>
test suites, and is recommended for <a
href="http://www.jboss.org/wiki/Wiki.jsp?page=SQLServer">JBoss</a>, <a
href="http://www.hibernate.org/80.html">Hibernate</a>, <a
href="http://www.atlassian.com/software/jira/docs/latest/standalone-dbconfig.html#sqlserver2000">Atlassian
JIRA</a> and <a
href="http://confluence.atlassian.com/display/DOC/Requirements">Confluence</a>
and <a href="http://www.compiere.org/">Compiere</a>.</p>
<p class="title">Getting Started</p>
<p>Being a type 4 driver, jTDS does not need any special installation.
Just drop the jar file into your application's classpath and you're
done. All you need to know is the name of the <code>Driver</code> and
<code>DataSource</code> implementations and the URL format and you're
all set. You can get these and a lot more information from the
<a href="faq.html">Frequently Asked Questions</a> page. For
features needing native libraries such as XA support or Single-Sign-On
consult the specific README files.</p>
<p class="title">Why use jTDS?</p>
<p>jTDS is free software. jTDS is released under the terms of the <a
href="http://www.opensource.org/licenses/lgpl-license.php"
alt="GNU Lesser General Public License">GNU LGPL</a>, giving you not
only the posibility to debug and tweak it to your own liking but also
to use it in and distribute it with your free or commercial
applications.</p>
<p>The other "free" choices, the JDBC-ODBC bridge and
Microsoft's own JDBC driver are not actually free. If you encounter an
issue with any of them you won't be able to fix it yourself and
response times from both Microsoft and Sun are anything but short.
Also, both of them lack functionality (the Microsoft driver implements
JDBC 2.0, while the bridge is just a JDBC 1.0 implementation) and have
serious stability problems: the bridge crashes the JVM if the ODBC
driver has any problem and Microsoft just has no intention of really
supporting Java/JDBC.</p>
<p>jTDS is also the most performant JDBC driver for both SQL Server and
Sybase. We have an older <a href="benchTest.html">benchmark result</a>
but we strongly encourage you to download any benchmark published by
commercial JDBC driver vendors and see for yourself. Here are a couple
of benchmarks you could use: <a
href="http://www.jnetdirect.com/downloads.php?op=performsuite">JNetDirect's
JDBC Performance Benchmark</a> and <a
href="http://www.inetsoftware.de/English/Produkte/JDBC2/BenchTest2_1.zip">i-net
Software's BenchTest 2.1 for MS SQL Server</a>.</p>
<p>Anyway, just give it a spin. Get the latest one from
<a href="http://sourceforge.net/project/showfiles.php?group_id=33291">here</a>
and see whether you like it or not.</p>
<p class="title">Support</p>
<p>Following a number of requests we have decided to offer commercial
technical support for interested parties. For the moment you can get
official technical support from individual developers of jTDS; contact
any of us and we'll be happy to provide you with our tech support terms
and conditions. Of course, we will keep offering support on our
SourceForge forums just as we did until now; we are only trying to
encourage adoption of jTDS, not make a fortune out of it.</p>
<!--
==================================
Content ends here
==================================
-->
</td>
<td width="9" background="images/mainr.gif"><img src="images/spacer.gif"></td>
</tr>
<tr>
<td width="9" height="9"><img src="images/mainbl.gif" width="9" height="9"></td>
<td height="9" background="images/mainb.gif"><img src="images/spacer.gif"></td>
<td width="9" height="9"><img src="images/mainbr.gif" width="9" height="9"></td>
</tr>
<tr>
<td colspan="3">
<table border="0" cellspacing="0" width="100%" class="outer">
<tr>
<td class="copyright" width="150">
Project hosted by<br><br>
<A href="http://sourceforge.net/projects/jtds" target="_top"><IMG src="http://sourceforge.net/sflogo.php?group_id=33291&type=2" border="0" alt="SourceForge Logo" class="otherLogo"></A><br>
</td>
<td class="copyright" width="500">WebRing member<br><br>
<script language=javascript src="http://ss.webring.com/navbar?f=j;y=alin_sinpalean;u=10063174"></script>
<noscript><center><table bgcolor=gray cellspacing=0 border=2 bordercolor=red>
<tr><td><table cellpadding=2 cellspacing=0 border=0><tr><td align=center>
<font face=arial size=-1>This site is a member of WebRing.
To browse visit <a href="http://ss.webring.com/navbar?f=l;y=alin_sinpalean;u=10063174">
here</a>.</font></td></tr></table></td></tr></table></center></noscript>
</td>
<td class="copyright" width="150">
Web Design<br><br>
<a href="http://anca13.go.ro" class="outer">Anca Sinpalean</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
|
