Skip to Content.
Sympa Menu

freetds - Re: Is anyone working on JDBC driver for MS-SQLServer?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Craig Spannring <cts AT internetcds.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Cc: nisha_shoukath AT avenir.net
  • Subject: Re: Is anyone working on JDBC driver for MS-SQLServer?
  • Date: Tue, 20 Oct 1998 09:42:58 -0700 (PDT)



Nisha Shoukath writes:
> Is there anuy one working on a Java Driver for MS SQL Server ? If so,
> please contact.

Yes, I working on one. You may get it from

ftp://freetds.internetcds.com:/pub/freetds_jdbc


Here's the readme file-


This is a sneak peek of a free type 4 JDBC driver for SQLServer and
Sybase. Currently it has only been tested on for SQLServer 6.5. (I
don't have a copy of Sybase.) The driver is not complete yet, but I
plan to have the full JDBC spec implemented in the next month or so.
methods that aren't implemented will throw a SQLException with the
message "Not implemented".

You may get a copy of the current source at

ftp://freetds.internetcds.com:/pub/freetds_jdbc

You can get more information about the FreeTDS project at

http://sunsite.unc.edu/freetds/

You may send bug reports to

freetds-jdbc-bugs AT internetcds.com


The name to use in the Class.forName() is
"com.internetcds.jdbc.tds.Driver"
and it accepts URLs of the form
"jdbc:freetds://servername/database"
or
"jdbc:freetds://servername:portnumber/database".

Right now it defaults to port 1433. If you attempt to use this with
Sybase you will need to specify the proper port.




Summary of status (as of October 20, 1998)-
* I haven't done much with Callable statements. Since it is
derived from the PreparedStatement class some portions will
work.

* The Connection class is mostly implemented. Code dealing with
catalogs, and the warning chain is not implemented.

* The DatabaseMetaData class still has ~60 methods not implemented.

* The Driver class is fully functional.

* The PreparedStatement class does not have all the data types
implemented yet. The warning chain code is not implemented.

* The ResultSet does not have all the getXXX() methods implemented
yet. getObject() is implemented for all SQLServer datatypes.
cursors are not implemented. The warning chain is not implemented
yet.

* The ResultSetMetaData class currently implements only-
getColumnCount()
getColumnDisplaySize()
getColumnLabel()
getColumnName()
getColumnType()
getColumnTypeName()
isCurrency()

* The Statement class is mostly implemented. It is missing
cursor support and the warning chain code.

Query timeouts and the cancel() method are working.

Transactions are implemented, but I have not made a thorough code
review yet.






Archive powered by MHonArc 2.6.24.

Top of Page