readme.txt

SUN的JDBC包有很多BUG拉

JTurbo 2.0 (version 2.2)
Last Modified:  06-Jan-2001
owner: Ashna Inc.

<Please email us your valuable feedback at [e-mail]>

Table Of Contents
-----------------
	1.   Installation
      2.   Bug Fixes
	3.   Known Bugs
	4.   Getting Started
	5.   Escape Clauses
	6.   Copyright and Support


1 Installation
----------------
unzip JTurbo4-20.zip in any directory. set the classpath:
Assuming you unzipped the zip file into D:\ you will see new folder JTurbo under d: drive.

on winnt: set classpath=D:\JTurbo4-20;%classpath% or set classpath=D:\JTurbo4-20\JTurbo.jar;%classpath%
on unix: modify your classpath to append JTurbo4-20 directory.

2 Bug Fixes
------------
 version beta 1:
 --------------
 1 Fixed the bug with Callable Statement's registerOutParameter call.
 2 Fixed the bug with returning large values from the database(text).
 3 Fixed ResultSet.isLast() and ResultSet.isFirst() returning wrong values
 4 Fixed Concurrency Types and Scrollability Types on PreparedStatement
 5 now the driver returns scale and precision values correctly from database.
 6 Support for various character sets added to the driver.
 7 Support for various languages added to the driver
 8 Support for retrieving unicode strings from database added on ResultSet.
 
 version beta 2:
 --------------
 1 Fixed bug with nullable columns on ResultSetMetaData.
 2 Now the driver can be used for storing 8k in varchar fields.
 3 Added queryTimeout feature to the driver.
 4 moveToInsertRow() and moveToCurrentRow() calls does not throw exceptions.

 version 1.0:
 -----------
 1 Fixed the bug with multithreading in the Driver
 2 Fixed the bug with preparedStatement while storing image fields.
 3 Fixed problem with executing SELECT statements with INNER JOINS on SQL Server 6.5
 4 Supports setCursorName() method on java.sql.Statement class.
 5 Fixed problem with getUserName() on java.sql.DatabaseMetaData
 6 Fixed problem with setting and retreiving NULL values from preparedStatement();
 7 implemented setObject(int, obj) for setting binary, varbinary and image fields.

 version 1.1:
 -----------
 1 Fixed the problem with storing large text in SQL Server 70 version.
 2 Fixed the problem with setAutoCommit().
 3 Now all the databasemetaData calls work as expected.

 version 1.2:
 -----------
 1 Fixed the bug with wasNull() method in ResultSet with always returning true
 2 Fixed bug with registerOutParameter for StoredProcs with varchar as out param.

 version 1.3 and 1.4:
 -------------------
 Performance and Scalability Upgrades

 version 1.5:
 -----------
 1 Added support for SQL queries using COMPUTE.
 2 Fixed bug with getString() on resultSet converting boolean to String.
 3 Added support for setCharacterStream() on preparedStatement
 4 Fixed bug with support for Applets. Now JTurbo 2.0 can be used on 
   browsers using Plug-In
 5 Fixed bug with PreparedStatement.clearBatch()
 6 Fixed a bug with setQueryTimeout resulting in corrupting the connection.

version 1.6:
-----------
 1 Fixed bug with SetCharacterStream() being not able to save correct unicode values.
 2 Initial support for SQL Server 2000.
 3 Fixed Intermittent ArrayIndexOutOfBounds exception
 4 Added support for java.sql.Types.NULL types in PrepareStatement.

version 2.1:
-----------
 1 Fixed bug with SQLWarning getting into infinite loop.
 2 Fixed bug with StackOverFlow exception when executing some Stored Procedures
 3 Fixed bug with CallableStatement not being able to execute regular queries other than stored procedures
 4 Fixed bug with PreparedStatement not being able to call Stored Procedures

3 Known bugs
------------
 1 ResultSet.rowUpdated(), ResultSet.rowInserted() and ResultSet.rowDeleted() 
   always return false.
 2 Clob, Blob and Arrays are not yet supported. 
 3 sql_variant, bigint and table datatypes are not supported yet.

4   Getting Started
--------------------

4.a Software Requirements

	Java Versions: 1.2x and above
	JDBC Version:  2.0
	SQL Server Version:
	- Microsoft SQL Server 2000(Initial support)
	- Microsoft SQL Server 7.0
	- Microsoft SQL Server 6.5


4.b Using Driver Name

The class name of the JTurbo driver is
	com.ashna.jturbo.driver.Driver


4.c Specifying  URL Syntax

	jdbc:JTurbo://<hostname>:<portnumber>/<database>
	jdbc:JTurbo://<hostname>/<database>
	jdbc:JTurbo://<hostname>/<database>/[flag1=value1]/[flag2=value2]/...		

e.g.	jdbc:JTurbo://mach1:1433/testdb
	jdbc:JTurbo://localHost/testdb
	jdbc:JTurbo://localhost/testdb/sp=true/charset=cp850
        jdbc:JTurbo://hostname/testdb/sp=false/user=John/password=Doe
        jdbc:JTurbo://hostname/testdb/sp=false/user=John/password=Doe/sql70=true
        jdbc:JTurbo://hostname/testdb/sp=false/user=John/password=Doe/language=us_english


Note: If URL includes user and password, then there is no need for passing these parameters again with getConnection() call. URL parameters take higer priority in case of contention.

If URL contains sql70=true flag, then there is no need to specify the charset flag.


5.  JTurbo Escape Clauses
-------------------------

5.a  Stored Procedures

	{call myProc([,?])}
	{? = call myProc([,?])}

5.b  Functions

	{fn now()}
	{fn curdate()}      

6.   Copyright and Support
--------------------------
	Copyright by Ashna Inc.
	[e-mail]
	
***To report a problem with the Driver email us the following:
	1. Complete JAVA STACK TRACE
	2. Your application Environment Information including all the software and OS Versions
	3. Code Snippet where the problem occurs.
	4. Table schema and Stored procs if applicable.
	
7. For further information and documentation
--------------------------------------------
 goto http://www.jturbo.com