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

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

port of MySQL plugin to win32. Name of plugin had to be changed to
libRMySQL since libMySQL clashes with libmysql on windows.


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

1. Workaround for Oracle ODBC driver for Linux. Number of fetched rows is
not set,
   therefore one should calculate this number ourself.
2. TODBCServer::GetDrivers() and TODBCServer::GetDataSources() static
methods are implemented.
   They provide information about available configured ODBC drivers and data
sources respectively.
   Also PrintDrivers() and PrintDataSources() methods are implemented.
3. TODBCServer::ServerInfo() method is implemented. It nows returns server
name and version like:
     "Oracle 10.01.0030" or "MySQL 4.1.11"
   TMySQLServer::ServerInfo() modified to return info in form: "MySQL
4.1.11"
4. TODBCServer::GetTablesList() modified in respect of Oracle ODBC driver
functionality -
    wildcarding is now works correctly.


git-svn-id: http://root.cern.ch/svn/root/trunk@16517 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

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. Lightweight support of DATE, TIME, DATETIME and TIMESTAMP SQL types for mysql plugin.
Now stmt->GetString() and stmt->GetInt() calls return meaningfull infotmation for that types.
In the future I will add methods like stmt->GetDate() for all SQL plugins.

2. Fix error with reading of unsigned data types from MySQL.
I was ignoring this flag, therefore methods like GetUInt(), GetULong() were not working
properly.

3. Support of TEXT/BLOB types in TMySQLStatement.
There are several small changes, which allows to read BLOB/TEXT data with TSQLStatement methods.
I also modify TMySQLServer::GetTableInfo() method to provide correct metainformation about
BLOB/TEXT columns.


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

I have used "errno" name for variable, which is used in <errno.h> include.
Problem appears in MaxOS. In fix I just rename "errno" to "sqlerrno".


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

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

Following an error report from Diego Faso about MySQLServer::TableInfo.
Here a patch for the problem - I just exclude usage of TSQLStatement class.


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

Now it possible to specify arguments for connection string like:

TSQLServer::Connect("mysql://host.domain/test?timeout=10&multi_statements")


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

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

Fix coding conventions violations


git-svn-id: http://root.cern.ch/svn/root/trunk@15625 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. 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@14763 27541ba8-7e3a-0410-8455-c3a389f83636

ODBC driver that allows generic access to many DB's. This version should
also compile on Win32 for access to MS DB's (Access, SQLServer). For this
driver to compile one needs either to install unixiODBC (unixodbc.org)
or iODBC (iodbc.org). [One Mac OS X it compiles fine with the system
installed iODBC libraries - Fons].


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

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

git-svn-id: http://root.cern.ch/svn/root/trunk@14679 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

Several changes in the Module.mk to run rootcint with the option gccxml.


git-svn-id: http://root.cern.ch/svn/root/trunk@13881 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

      * New Debian and RedHat rpm packaging scripts.
      * Added a description to `build/package/debian/README.Debian' on
        how to add a new package.   It's not that complicated so it
        should be a simple thing to add a new package, even for some
        with little or no experience with RPMs or DEBs.
      * When searching for the Oracle client libraries, I added the
        directories `/usr/lib/oracle/*/client/lib' and
        `/usr/include/oracle/*/client' - as these are the paths that the
        RPMs install into.
      * I added the packages `root-plugin-krb5' and
        `root-plugin-oracle'.
      * The library `libXMLIO' is in `libroot'.
      * The package `root-plugin-xml' contains the XML parser.
      * I fixed an cosmetic error in `build/misc/root.m4'.  The
        definition of `ROOT_PATH' should be quoted, otherwise aclocal
        will complain.
      * In the top-level `Makefile' I pass an additional argument to
        `makecintdlls' - namely `$(ROOTCINTTMP)'.  In `makecintdlls' I
        use that argument to make the various dictionaries for
        `lib...Dict.so'.   Originally, the script used plain `rootcint'.
        However, as `rootcint' may not be in the path yet, or the one in
        the path may be old, this failed.  Hence, I use what we know is
        there - namely the newly build `rootcint_tmp'.  BTW, what are
        these shared libraries, and where do they belong?  I guess they
        are specific to ROOT, and not used by plain `CINT'.  For now, I
        put them in `libroot'.
      *  Made the two `virtual' packages `root-db-client' - provided the
        DB plugins, and `root-fitter' provided by `root-plugin-minuit'
        and `root-plugin-fumili'.  Note, the virtual package
        `root-file-server' provided by `root-rootd' and `root-xrootd'
        already existed in the previous patch.
      * Note, I added the directory `build/package/debian/po' which is
        for translations of DebConf templates.  DebConf is Debians very
        advanced package configuration interface.   It presents the user
        with a set of questions in some sort of `GUI' based on how much
        the user would like to change.  These `dialogs' can be
        translated quite easily.  As an example, I translated the
        questions used by the `ttf-root-installer' package into Danish.
        I'm sure someone can translate them into German, French,
        Italien, Spanish, and so on.


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

version<50000 and version>=40103 (a mess).


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

must be
#if MYSQL_VERSION_ID < 50001
and not
#if MYSQL_VERSION_ID < 40003


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

 TMySQLServer::ShutDown appears to need a modification to adapt to API changes in MySQL.


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

and library and dependent library information from the LinkDefs and the
library and libdep macros.


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

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

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

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

compatible.


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

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

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

generated for the dictionary files (G__*). This caused dictionaries including
modified headers not to be rebuild.


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

which included commits to RCS files with non-trunk default branches.


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