Add package documentation


git-svn-id: http://root.cern.ch/svn/root/trunk@21442 27541ba8-7e3a-0410-8455-c3a389f83636

git-svn-id: http://root.cern.ch/svn/root/trunk@19826 27541ba8-7e3a-0410-8455-c3a389f83636

git-svn-id: http://root.cern.ch/svn/root/trunk@19825 27541ba8-7e3a-0410-8455-c3a389f83636

1. New virtual method TSQLStatement::SetMaxFieldSize(). It implemented for now only for Oracle and
   specifies maximum size in bytes, which should be used for field in read/write operation.

2. Improved implementation of TOracleStatement::GetBinary method. Now not only BLOB, but also
   CLOB, LONG, BFILE, CFILE Oracle datatypes are supported for reading. Fow now BFILE and CFILE
   not supported for writing.


git-svn-id: http://root.cern.ch/svn/root/trunk@19293 27541ba8-7e3a-0410-8455-c3a389f83636

- change method IsSupportStatement() to HasStatement()


git-svn-id: http://root.cern.ch/svn/root/trunk@18954 27541ba8-7e3a-0410-8455-c3a389f83636

directory. These rootmap files are generated automatically when the
associated LinkDef file(s) or the config/Makefile.depend is changed.
No more "make map" needed, rootmaps are always up-to-date!


git-svn-id: http://root.cern.ch/svn/root/trunk@18452 27541ba8-7e3a-0410-8455-c3a389f83636

and how to use the Oracle plugin.


git-svn-id: http://root.cern.ch/svn/root/trunk@17987 27541ba8-7e3a-0410-8455-c3a389f83636

git-svn-id: http://root.cern.ch/svn/root/trunk@17919 27541ba8-7e3a-0410-8455-c3a389f83636

git-svn-id: http://root.cern.ch/svn/root/trunk@17361 27541ba8-7e3a-0410-8455-c3a389f83636

git-svn-id: http://root.cern.ch/svn/root/trunk@17176 27541ba8-7e3a-0410-8455-c3a389f83636

After getting mail from Antonio Bulgheroni [antonio.bulgheroni@gmail.com],
I found out that MySQL and Oracle default ports number not used in ROOT.

Therefore, I made small fix to set default port number for MySQL = 3306 and Oracle = 1521.


git-svn-id: http://root.cern.ch/svn/root/trunk@16384 27541ba8-7e3a-0410-8455-c3a389f83636

TOracleServer::ServerInfo() is now implemented (thanks to Dennis Box)


git-svn-id: http://root.cern.ch/svn/root/trunk@16382 27541ba8-7e3a-0410-8455-c3a389f83636

1. Support of date/time/date&time/timestamp data introduced in TSQLStatement
   All such data now can be accessed without text conversion.
   The following methods can be used:

   SetTime()/GetTime() - only time (hour:min:sec),
   SetDate()/GetDate() - only date (year-month-day),
   SetDatime()/GetDatime() - date and time
   SetTimestamp()/GetTimestamp() - timestamp with seconds fraction
   For some of these methods TDatime type can be used as parameter / return value.
   Be aware, that TDatime supports only dates after 1995-01-01.
   There are also methods to get separately year, month, day, hour, minutes and seconds.

2. Support of binary data in TSQLStatement
    Most of modern data bases support just binary data, which is
    typically has SQL type name 'BLOB'. To access data in such
    columns, GetBinary()/SetBinary() methods should be used.
    Current implementation supposes, that complete content of the
    column must be retrieved at once. Therefore very big data of
    gigabytes size may cause a problem.


git-svn-id: http://root.cern.ch/svn/root/trunk@16204 27541ba8-7e3a-0410-8455-c3a389f83636

1. Support for MySQL version 3.2.x and 4.0 enabled again. For that old MySQL versions TSQLStatement is not supported.
2. Small fix in TSQLFile. With old MySQL versions it does not try to use TSQLStatement class.
3. Enabling/disabling error output for TSQLStatement class.
4. Fix in error handling in TMySQLServer::Statement() method. Previousely error code was not correctly stored.


git-svn-id: http://root.cern.ch/svn/root/trunk@15538 27541ba8-7e3a-0410-8455-c3a389f83636

1. Bug fix for Oracle plugin - new TOracleServer::Exec() method did not release memory correctly.
2. Small changes in TSQLServer class


git-svn-id: http://root.cern.ch/svn/root/trunk@15511 27541ba8-7e3a-0410-8455-c3a389f83636

1. New methods of TSQLServer class (also for Oracle, MySQL, ODBC):
     Exec() - execute query which does not produce any result
     GetTablesList() - return list of tables names in data-base independent form
     IsTableExists() - check if table of given name exists
     GetTableInfo() - returns instance of TSQLTableInfo with list of columns.
2. New methods of TSQLStatement class (also for Oracle, MySQL, ODBC):
     IsNull() - checks, if field value is NULL
     SetNull() - sets parameter value to NULL


New TSQLTableInfo contains information about table and table columns.
For MySQL additional information like engine type, creation and last update time is provided


New TSQLColumnInfo class contains information about single column from SQL table
Has following methods:
   GetTypeName() - field type name in string form as it is reported by correspondent
          database method. Some databases providing full type name like "numeric(20)",
          other showing only "NUMERIC". As a result, one cannot use this string directly
          to create new field of similar types in other table
   IsNullable() - says if field value can be NULL or not
   GetSQLType() - returns kind of sql type. Possible values:
      TSQLServer::kSQL_NONE        data type unknown
      TSQLServer::kSQL_CHAR        CHAR(n) - string with fixed length n
      TSQLServer::kSQL_VARCHAR     VARCHAR(n) - string with variable length upto n
      TSQLServer::kSQL_INTEGER     INTEGER, INT, TINYINT - any integer types
      TSQLServer::kSQL_FLOAT       FLOAT - float value
      TSQLServer::kSQL_DOUBLE      DOUBLE - double precision value
      TSQLServer::kSQL_NUMERIC     NUMERIC(n,s), NUMBER(n,s) - numeric values with length and precion
      TSQLServer::kSQL_BINARY      BLOB, VARBINARY  - binary data (vriable or fixed size)
      TSQLServer::kSQL_TIMESTAMP   TIMESTAMP - time and date stamp
   GetSize() - size of field in database. -1 if not known.
   GetLength() - length argument in type declaration like CHAR(len) or NUMERIC(len), -1 if not defined
   GetScale() - second argument in declarations like NUMERIC(len, s), -1 if not defined
   GetSigned() - is type signed(==1) or unsigned(==0), -1 if not defined


git-svn-id: http://root.cern.ch/svn/root/trunk@15305 27541ba8-7e3a-0410-8455-c3a389f83636

1. Error handling is introduced. Now TSQLServer/TSQLStatement returns error code - GetErrorCode()
   and message - GetErrorMsg() of last operation.
   If desired, error output can be suppressed for TSQLServer. Correspondent changes done in implementation
   for Oracle, MySQL, ODBC
2. New methods of TSQLServer class for transactions control: StartTransaction() / Commit() / Rollback().
   As desfault implmenetaion in TSQLServer class they corresopnd to SQL "START TRANSACTION", "COMMIT", "ROLLBACK" queries.
   For Oracle, MySQL and ODBC specific implmentaion were done while there special methods should be called.
3. Some other new methods of TSQLServer class:
     IsSupportStatement() - return kTRUE if plugin has TSQLStatement implementation
     GetMaxIdentifierLength() - return maximum allowed length of identifiers
4. Bugfix in TODBCRow class


git-svn-id: http://root.cern.ch/svn/root/trunk@15124 27541ba8-7e3a-0410-8455-c3a389f83636

handle change TUrl::GetFile() convention, leading slash is not part of
filename anymore (to be URL standards compliant).


git-svn-id: http://root.cern.ch/svn/root/trunk@15063 27541ba8-7e3a-0410-8455-c3a389f83636

git-svn-id: http://root.cern.ch/svn/root/trunk@14677 27541ba8-7e3a-0410-8455-c3a389f83636

Added TSQLStatment abstract class and TMySQLStatment and TOracleStatement
classes to support bulk DB operations. For more details see the description
in the TSQLStatement.cxx file.


git-svn-id: http://root.cern.ch/svn/root/trunk@14675 27541ba8-7e3a-0410-8455-c3a389f83636

Dictionary G__%.o: G__%.cxx rules now in main Makefile instead of Module.mk's
=> changes in Module.mk.

First Module.mk's included, then Makefile.precomp - we need ALLHDRS defined

Split $(PCHEXTRAOBJ) and $(PCHFILE) rules - fixes clash with make -j2

Define CINTCXXFLAGS:= - otherwise they will contain PCHCXXFLAGS via
their definition as a copy of CXXFLAGS.

MSVC: prevent LNK4206 linker warning (-Yl...)


git-svn-id: http://root.cern.ch/svn/root/trunk@14301 27541ba8-7e3a-0410-8455-c3a389f83636

Main performance improvement are these two lines.

   fStmt->setPrefetchRowCount(1000);
   fStmt->setPrefetchMemorySize(1000000);

It increases default buffers, which are about 8K and read much faster.
For my example it runs 3 times faster, for other application it can be 4-5 times.

Second patch is required for treatement of integers out of normal integer range (long long or unsigned int).
I replace string -> int -> string conversion by just copying string to buffer. For the floats it is not working,
while Oracle text format differs from C++ format.


git-svn-id: http://root.cern.ch/svn/root/trunk@14002 27541ba8-7e3a-0410-8455-c3a389f83636

git-svn-id: http://root.cern.ch/svn/root/trunk@13971 27541ba8-7e3a-0410-8455-c3a389f83636

handle in a consistent way the new rootcint options -cint (default),
-reflex and -gccxml. The type of dictionary to be used can be specified
like: ./configure --with-dicttype=reflex. Notice that this option is
there only for the developers working on the migration to the new
dictionary system.


git-svn-id: http://root.cern.ch/svn/root/trunk@13609 27541ba8-7e3a-0410-8455-c3a389f83636

in case we have gmake >= 3.80 we can use the new | (order) syntax where
all dependencies after the | are required to be there but not trigger
execution of the rule. This should greatly enhance the build experience
on Win32 and AIX (platforms that need the EXPLICITLINK option).


git-svn-id: http://root.cern.ch/svn/root/trunk@13584 27541ba8-7e3a-0410-8455-c3a389f83636

fix for compiling on VC++.


git-svn-id: http://root.cern.ch/svn/root/trunk@11939 27541ba8-7e3a-0410-8455-c3a389f83636

fixed verion of the Oracle plugin. Should now work as advertised via the
abstract TSQL interfaces.


git-svn-id: http://root.cern.ch/svn/root/trunk@11669 27541ba8-7e3a-0410-8455-c3a389f83636

git-svn-id: http://root.cern.ch/svn/root/trunk@11560 27541ba8-7e3a-0410-8455-c3a389f83636

git-svn-id: http://root.cern.ch/svn/root/trunk@11218 27541ba8-7e3a-0410-8455-c3a389f83636

1. implemented TOracleServer::GetColumns() using occi
MetaData instead of original SQL select statement. This
implementation works for any Oracle 10 databases without
constraints on user granted priveleges.

2. implemented TOracleServer::GetTables(). The TSQLServer::GetTables()
is MySQL oriented. In Oracle, table is accessed in "schema.table" format.
The implementation handles two cases: with and without schema name.
The return value conforms TSQL spec, i.e. a TSQLResult pointer.

3. fixed a critical bug in TOracleResult::Next().


git-svn-id: http://root.cern.ch/svn/root/trunk@11214 27541ba8-7e3a-0410-8455-c3a389f83636

This is the first version of the new oracle plugin.
To build this plugin one needs to install the following
Oracle InstantClient rpms:
   oracle-instantclient-basic-10.1.0.3-1
   oracle-instantclient-devel-10.1.0.3-1
And the following environment variables in your .[bash_]profile:
   export ORACLEINCDIR=/usr/include/oracle/10.1.0.3/client
   export ORACLELIBDIR=/usr/lib/oracle/10.1.0.3/client/lib
   export LD_LIBRARY_PATH=$ORACLELIBDIR:$LD_LIBRARY_PATH


git-svn-id: http://root.cern.ch/svn/root/trunk@11203 27541ba8-7e3a-0410-8455-c3a389f83636