FreeTDS Development Group

[Craig Spannring <cts AT internetcds.com>]

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.