[root] Log of /trunk/sql/oracle/inc/TOracleServer.h

Revision 29321 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Fri Jul 3 10:42:10 2009 UTC (5 years, 6 months ago) by brun
File length: 2567 byte(s)
Diff to previous 23123

From Sergei Linev:
1. New static methods to set/get time formatting in TOracleServer
2. Move float format constant for TBufferSQL2 to TSQLServer
3. Use that format in several other appropriate places like TODBCStatement, TOracleRow and so on.
4. Replace sprintf to snprintf calls in several places.

Revision 23102 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Wed Apr 9 22:18:41 2008 UTC (6 years, 9 months ago) by pcanal
Original Path: trunk/oracle/inc/TOracleServer.h
File length: 2340 byte(s)
Diff to previous 20882

Oracle #define CONST, but Reflex also uses it (as an enum), so we need to #undef to allow the compilation of the oracle plugin reflex dictionary

Revision 20882 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Mon Nov 19 11:31:26 2007 UTC (7 years, 2 months ago) by rdm
Original Path: trunk/oracle/inc/TOracleServer.h
File length: 2307 byte(s)
Diff to previous 19826

Set property svn:eol-style LF on all source and Makefiles. This should avoid
problems with Win32 line endings ending up in the repository. All MS tools
support LF eols fine.

Revision 15305 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Fri Jun 2 14:02:03 2006 UTC (8 years, 7 months ago) by brun
Original Path: trunk/oracle/inc/TOracleServer.h
File length: 2304 byte(s)
Diff to previous 15124

From Sergey Linev:
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

Revision 15124 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Mon May 22 08:55:30 2006 UTC (8 years, 8 months ago) by brun
Original Path: trunk/oracle/inc/TOracleServer.h
File length: 2158 byte(s)
Diff to previous 14675

From Sergei Linev:
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

Revision 14675 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Wed Apr 12 20:53:45 2006 UTC (8 years, 9 months ago) by rdm
Original Path: trunk/oracle/inc/TOracleServer.h
File length: 1884 byte(s)
Diff to previous 11203

From Sergei Linev:
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.

Revision 11203 - (view) (download) (as text) (annotate) - [select for diffs]
Added Mon Feb 28 19:11:00 2005 UTC (9 years, 10 months ago) by rdm
Original Path: trunk/oracle/inc/TOracleServer.h
File length: 1900 byte(s)

From Yan Liu and Shaowen Wang:
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

This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.

Links to HEAD:	(view) (download) (as text) (annotate)
Sticky Revision: