mORMot and Open Source friends
All files named "SynDBZEOS.pas"
Not logged in
Home Documentation Forum Download Blog Donate Timeline Tickets Wiki Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for SynDBZEOS.pas

2015-11-05
16:35
Deleted: {2029} rename SynDBZEOS.pas as SynDBZeos.pas (first step: deletion) check-in: [a5b3aab1ca] user: ab branch: trunk, size: 0
2015-11-02
10:21
{2018} included and fixed lasted mpv's patches for SynDB file: [80deed58f9] check-in: [bb7e33b0aa] user: ab branch: trunk, size: 48564
2015-10-27
18:40
SynDBZeos: PostgreSQL array binding for select statements file: [cfa52d5f4d] check-in: [a4c1803024] user: pavel.mash branch: trunk, size: 48566
2015-10-20
13:07
{2007} let SynDB statements fColumns[] internal array be sized with the exact known column count as proposed by mpv as [16e7e5c4b192] file: [9db15da191] check-in: [3749228e88] user: ab branch: trunk, size: 45836
2015-07-14
09:52
{1635} fixed exception during Commit should leave transaction state - see [ca035b8f0da] file: [014e7ef484] check-in: [8cdb6dc144] user: ab branch: trunk, size: 45785
2015-05-15
10:57
{1355} comments and spaces clean-up of almost all source code files of the framework - no functional change, just code formatting uniformization file: [0c3c748c2f] check-in: [ab1fd53635] user: ab branch: trunk, size: 45682
2015-04-29
09:02
{1267} added a reference to ZDbcOleDB in SynDBZEOS.pas, when it is expected to appear - thanks Daniel for the feedback! file: [16a998e8dc] check-in: [657689e44e] user: ab branch: trunk, size: 45709
2015-03-03
22:29
{1028} introducing TSynConnectionDefinition class used e.g. for JSON-defined runtime instantiation of a TSQLDBConnectionProperties or TSQLRest instances via DefinitionTo*() and CreateFrom*() methods - see also function TSQLRestCreateFrom() which is able to create a TSQLRest with external tables file: [2ab4bb914b] check-in: [78ce0600e1] user: ab branch: trunk, size: 45635
13:59
{1024} introducing TSQLDBConnectionProperties SaveTo/SaveToJSON/SaveToFile methods and TSQLDBConnectionPropertiesStorage.NewInstance*() methods to persist the database connection properties, and the associated class, as JSON file or variable - also included corresponding regression tests file: [2fe292c275] check-in: [ae854a5e71] user: ab branch: trunk, size: 45632
2015-02-22
13:20
{957} BREAKING CHANGE: introducing TTextWriter.AddDouble() and AddSingle() dedicated methods so that floating point values would be serialized as JSON with the expected precision file: [0b7175a240] check-in: [f69855c654] user: ab branch: trunk, size: 45553
2015-02-19
20:17
{939} missing some files as reported by [834757fc77972593] file: [35affbfaef] check-in: [e4c93de0ef] user: ab branch: trunk, size: 45541
2015-02-15
13:15
{902} ExeVerionRetrieve() replaced by the more explicit SetExecutableVersion() function - this commit also includes several fixes for the Linux platform file: [a179c496e3] check-in: [9b60596cae] user: ab branch: trunk, size: 45541
2015-01-02
12:08
{668} happy new year 2015! file: [86fd151ffe] check-in: [e08c81ec40] user: ab branch: trunk, size: 45543
2014-12-12
19:47
{640} ESQLDBException (and its descendants) will now append the current SQL statement to its error message, if TSQLDBConnectionProperties.LogSQLStatementOnException is defined, as requested by [ea07928ae9] file: [d0a47bc2bf] check-in: [9416d466bf] user: ab branch: trunk, size: 45543
2014-12-11
15:00
{634} defined mORMot units after ZDBC due to some name conflicts (e.g. UTF8ToString) in SynDBZeos file: [6f768d6449] check-in: [5c1f52fa4a] user: ab branch: trunk, size: 45530
2014-12-09
08:43
{622} ensure ZDBC library creates explicitly R/W connections file: [f8578e0a87] check-in: [917a35d331] user: ab branch: trunk, size: 45443
2014-12-08
08:10
{617} added ADO/Jet support for ZDBC, and also enhanced transaction support following the pattern discussed on our forum for ticket [78b02a387722b] file: [105fb16bbb] check-in: [927c4b1e66] user: ab branch: trunk, size: 45409
2014-11-29
08:30
{590} refresh contributor list file: [74cd84f98a] check-in: [c13710637e] user: ab branch: trunk, size: 43113
2014-11-26
20:34
{577} changed the default transaction isolation status for SynDBZeos to tiReadCommitted as proposed by alpinistbg file: [2ba10f8181] check-in: [9c460b3f91] user: ab branch: trunk, size: 43093
2014-11-23
16:55
{559} BREAKING CHANGE: new SynLog.pas and SynTests.pas units, extracted from SynCommons file: [b632ed25de] check-in: [881797779c] user: ab branch: trunk, size: 43084
2014-11-21
13:10
{552} added ForceBlobAsNull property to ISQLDBStatement (used e.g. by SynDBExplorer) file: [1f3da3687d] check-in: [c13d3ce6f2] user: ab branch: trunk, size: 43073
2014-11-15
20:39
{522} put back SQLSplitTableName(UpperCase(aTablename)) :/ file: [a149c34d05] check-in: [7ffd1a2b4f] user: ab branch: trunk, size: 43113
18:07
{520} added overloaded TSQLDBZEOSConnectionProperties.URI() to specify a custom ZDBC protocol name, if needed file: [0f317f5233] check-in: [627e9a9c52] user: ab branch: trunk, size: 43103
2014-11-03
12:21
{465} ensure MSSQL text columns will be handled as expected by TSQLDBZEOSStatement.ColumnsToJSON() file: [3d089fb0f0] check-in: [516e1f18f0] user: ab branch: trunk, size: 42207
12:19
{464} fixed typo about optional parameter DoNotFetchBlobs for TSQLDStatement.ColumnsToJSON() file: [d8dc873067] check-in: [1d14f45dad] user: ab branch: trunk, size: 41938
09:18
{463} enhanced blob process for TSQLDBZEOSStatement.ColumnsToJSON() file: [e385166532] check-in: [76c147e388] user: ab branch: trunk, size: 41940
09:03
{462} added procedure TSQLDBZEOSStatement.ColumnsToJSON() for a noticeable performance boost when exporting information into JSON: using directly IResultSet methods allows to bypass any memory allocation, especially with text columns - thanks Michael for the proposal! file: [8764bf5213] check-in: [1308251ec1] user: ab branch: trunk, size: 41691
2014-11-01
12:22
{453} let SQL statements be truncated when logged file: [1363a5f61b] check-in: [516e4c1fba] user: ab branch: trunk, size: 39320
2014-10-28
14:33
{426} disable table info cache for ZDBC+PostgreSQL see http://synopse.info/forum/viewtopic.php?pid=13264#p13264 file: [3a10f717a4] check-in: [ed5b4034df] user: User branch: trunk, size: 39334
14:11
{425} added sample MVCServerFirebird.dpr file: [897718656e] check-in: [23ea40f6cd] user: User branch: trunk, size: 38635
2014-10-07
16:47
{320} fixed TDateTime process in BATCH mode, for SynDBZeos file: [b5476c8339] check-in: [211d15b2b2] user: User branch: trunk, size: 38527
2014-09-15
13:24
fixed TSQLDBZEOSConnectionProperties.URI() when aLibraryLocation='' file: [ca4aa4902c] check-in: [60c0380334] user: User branch: trunk, size: 38509
2014-09-04
08:46
added the new TSQLDBConnectionProperties.ConnectionTimeOutMinutes property to allow automatic recreation of all connections after an idle period of time, to avoid potential broken connection issues as reported by [f024266c0839] file: [082e68eac7] check-in: [b77a46e29f] user: User branch: trunk, size: 38536
07:17
added TSQLDBZEOSStatement.UpdateCount method - feature request [9d538d1dc3c03] proposed by Joe file: [36f4f9a026] check-in: [9042ac607d] user: User branch: trunk, size: 38530
2014-08-26
15:00
added ESynException.CreateUTF8() constructor, more versatile than the default Exception.CreateFmt() version: this CreateUTF8() method is now used everywhere in the framework... in fact, we did a full review and refactoring of any exception raised in mORMot - big commit, indeed ;) file: [230f3c8ef9] check-in: [9b573b70f3] user: User branch: trunk, size: 38212
2014-08-20
08:22
ensure ExecutePrepared fails if BindArray() was used when the underlying provider does not support array binding file: [7af09ab227] check-in: [ad871ec39d] user: User branch: trunk, size: 38395
2014-08-19
14:34
added Array Binding support for SynDBZeos - with the ZDBC 7.2 branch (only for Oracle yet) file: [ed801fa3f5] check-in: [0b0f595b12] user: User branch: trunk, size: 37866
2014-08-15
14:26
documentation update mainly about the newly introduced TSQLDataBase.BackupBackground() method file: [aa695727c2] check-in: [5630b2574d] user: User branch: trunk, size: 31921
2014-08-10
13:56
fixed compilation issue file: [311aeca1f5] check-in: [0ac4a127de] user: User branch: trunk, size: 31673
2014-05-12
07:43
fixed typos and some compilation warnings file: [6e2ac8736f] check-in: [fd20a67fc6] user: User branch: trunk, size: 31673
2014-04-01
18:06
several code changes to follow up the prototype change of StrComp()-like functions from PUTF8Char into pointer parameters file: [f479d0271c] check-in: [bb92b8f376] user: User branch: trunk, size: 31668
2014-03-07
09:14
added MySQL benchmark and official support in documentation file: [9ac1fc2197] check-in: [3828725498] user: abouchez branch: trunk, size: 31668
2014-03-05
16:08
  • added IBM DB2 support to SynDB classes and mORMot ORM - tested with DB2 Express-C 10.5
  • now TODBCConnection.Connect() will recognize the DBMS from its driver name
 file: [0814ee0cee] check-in: [103fcd7e36] user: abouchez branch: trunk, size: 31660
2014-03-03
15:33
enhanced ORM for BATCH insert to generate custom SQL statements, depending on the database engine: either INSERT with multi VALUES (SQlite3, MySQL, PostgreSQL, NexusDB), EXECUTE BLOCK (Firebird) or INSERT ALL INTO (Oracle) - updated documentation and benchmark results file: [e4232e8c31] check-in: [6bbee294a0] user: abouchez branch: trunk, size: 31651
2014-01-24
16:10
  • moved TSQLDBFieldType from SynDB to SynCommons, and used by TSQLVar and all database-related process (i.e. in mORMot and SynDB units)
  • added TSynLog.DebuggerNotify() method
  • low-level vt_*() callbacks defined for TSQLVirtualTableModuleSQLite3 will now call SynSQLite3Log.DebuggerNotify() in case of any process error
  • several speed-up of some GetFieldSQLVar/SetFieldSQLVar methods, used by the ORM when sending/retrieving data to/from database content
  • added DateTimeToIso8601ExpandedPChar() function
 file: [02aa0ee072] check-in: [b8e0b698e1] user: abouchez branch: trunk, size: 31447
2014-01-01
13:31
The little mORMot wishes you an happy new year 2014! file: [d97c2ef4c8] check-in: [44147954e2] user: User branch: trunk, size: 31292
2013-12-29
18:53
minor comments enhancements about ZDBC physical drivers integration file: [f1c692ef69] check-in: [1f3e739597] user: User branch: trunk, size: 31292
14:30
SynDBZeos unit will now add all available physical ZDBC providers by default file: [03c51e6498] check-in: [488a6a5f4e] user: User branch: trunk, size: 31074
14:19
added optional server name parameter to class function TSQLDBZEOSConnectionProperties.URI() file: [084ee85b75] check-in: [2bf05d6a73] user: User branch: trunk, size: 30568
2013-12-27
14:07
let TSQLDBZEOSConnectionProperties.GetFields() to fall-back to default SynDB based implementation, using raw SQL if ZDBC metadata failed to return any column description (sounds as if there were some issues, e.g. with ZDBC) file: [d1206278b9] check-in: [22893f395c] user: User branch: trunk, size: 30119
13:54
enhanced the TSQLDBUniDACConnectionProperties.URI() method to handle an optional port number file: [2c38b84ab4] check-in: [5f418f2a75] user: User branch: trunk, size: 30115
13:24
with Zeos/ZDBC: do not override Database name if already set at URI parameter level (e.g. zdbc:mysql://192.168.2.60:3306/world?username=root;password=dev) file: [ba6ac8c380] check-in: [4482295578] user: User branch: trunk, size: 30099
2013-12-22
12:54
added server name in TSQLDBUniDACConnectionProperties.URI(), able to specify a server name for UniDAC connection file: [1cdfb01e93] check-in: [a6894b2bba] user: User branch: trunk, size: 29995
2013-12-12
17:06
small code rewriting to add the actual DB statement implementation class name in case of a runtime exception file: [e319374091] check-in: [80ae044b82] user: abouchez branch: trunk, size: 30078
2013-12-05
16:55
fix connection with Oracle without any TNSNAME.ORA defined and small speed improvements when binding currency content file: [b94960e6f1] check-in: [e861c15c3b] user: abouchez branch: trunk, size: 29969
2013-12-04
12:52
small optimization for ZEOS 7.2 branch with currency values file: [1a990bbcd0] check-in: [a82fd501d4] user: abouchez branch: trunk, size: 30224
2013-12-03
21:53
updated notes about older versions of Zeos -> you should better upgrade to latest 7.2 revision as soon as it is stabilized and published! :) file: [7d75a19826] check-in: [807863edf4] user: User branch: trunk, size: 30136
19:19
fixed ZEOS/ZDBC inline parameters, and enabled statement cache for SQLite3 with Zeos 7.2 branch file: [2d9ef133c3] check-in: [f7df8d8857] user: abouchez branch: trunk, size: 28678
2013-12-02
14:57
let DatabaseName='host:port/db' be interpreted as Zeos/ZDBC URI parameters file: [b64a263b59] check-in: [c7a1ced87c] user: abouchez branch: trunk, size: 28690
2013-12-01
12:58
first tests with Zeos/ZDBC 7.2 testing branch - some code fixes needed - but speed increase is noticeable - see this forum thread file: [cb9bf35a4a] check-in: [1318a0cbec] user: User branch: trunk, size: 28192
2013-11-30
13:38
enhanced Zeos/ZDBC support, thanks to EgonHugeist (Zeos core developper) feedback - thanks! file: [ec7bfbfcad] check-in: [6e58ad6282] user: User branch: trunk, size: 28108
2013-11-29
14:27
enhanced TSQLDBZEOSConnectionProperties.GetFields() to support database schema information file: [1897fe3ab5] check-in: [e02f768d51] user: abouchez branch: trunk, size: 25425
2013-11-20
20:40
added a note about quoted table names when using PostgreSQL with ZDBC/Zeos file: [c0c0745db3] check-in: [4b0ec45947] user: User branch: trunk, size: 25342
15:40
fix unexpected table name conversion to uppercase for Zeos/ZDBC file: [26ea96bb82] check-in: [d2bce50700] user: abouchez branch: trunk, size: 25021
15:04
changed BLOB process method for Zeos/ZDBC file: [c474461c2a] check-in: [0f4179731f] user: abouchez branch: trunk, size: 25032
2013-11-19
15:01
compatibility with Zeos 7.2 alpha + blob parameters speed increase file: [6a76d57e67] check-in: [c3394485b2] user: User branch: trunk, size: 24985
2013-11-10
20:57
enabled statement cache for PostgreSQL, since it sounds stable enough to be defined file: [5511571567] check-in: [3059c1ceef] user: User branch: trunk, size: 24970
13:15
enhanced PostgreSQL support via ZDBC, and fix error when using schema at index creation file: [a8780c2426] check-in: [bbe911d7d2] user: User branch: trunk, size: 24957
2013-10-26
15:07
ExecutePrepare method will log the SQL statement if sllSQL has been enabled in SynDBLog.Family.Level - feature request [59e349f58d] file: [210bd065b0] check-in: [4fdaf260a8] user: User branch: trunk, size: 24934
2013-10-25
13:19
fixed Unicode-encoded column names for ZEOS/ZDBC layer (for non-Unicode Delphi only) file: [4b20815e24] check-in: [405d06b156] user: abouchez branch: trunk, size: 24639
12:08
fixed compilation issue with Delphi XE2+ compilers (due to namespace styles) file: [bf9d0e2148] check-in: [cff6623d44] user: abouchez branch: trunk, size: 24530
08:05
fixed Zeos BLOB handling and e.g. postgresql - see ticket [2ab1220546] file: [61f5bfdb0c] check-in: [bc3f992bed] user: abouchez branch: trunk, size: 24152
2013-07-12
06:55
Let "AS" renamed columns be retrieved for Zeos/ZDBC access layer file: [4f93f348bc] check-in: [21cd17f204] user: abouchez branch: trunk, size: 24099
2013-07-01
12:14
added dPostgreSQL kind of database in TSQLDBDefinition enumerate, including associated SQL requests to retrieve metadata - not tested on production yet: your feedback is needed! :)

Linked to [07d810bc24] feature request about PostgreSQL support. file: [25c22a657a] check-in: [e13a2baa9b] user: abouchez branch: trunk, size: 24099

2013-05-06
12:23
  • new TSQLDBConnectionProperties/TSQLDBConnection.OnProcess event handlers
  • TSQLDBConnection.Connect will now trigger OnProcess(speReconnected) and update the new TSQLDBConnection.TotalConnectionCount property
 file: [e29480f86f] check-in: [4d80f1df05] user: abouchez branch: trunk, size: 24084
2013-05-03
09:05
  • TSQLDBConnection.Disconnect will now flush internal statement cache (this impacts all SynDB*.pas units)
  • TQuery.Execute() is now able to try to re-connect once in case of failure
 file: [34a124bef9] check-in: [04fbed8876] user: abouchez branch: trunk, size: 24001
2013-03-15
18:59
added class methods TSQLDBZEOSConnectionProperties.URI() and TSQLDBUniDACConnectionProperties.URI() file: [2448ae11d0] check-in: [704d4d8472] user: abouchez branch: trunk, size: 23958
2013-02-19
09:14
SynDBZEOS for Firebird will now use ZDBC prepared statements -> speeds up the process from x1.5 to x3 :D file: [5c10fcecc9] check-in: [9cc3701b27] user: abouchez branch: trunk, size: 22393
06:23
use SetTransactionIsolation() method of ZDBC as expected e.g. by their Sqlite3 driver to properly handle transactions -> major speed up! file: [0383aeebe7] check-in: [0256f1ac15] user: abouchez branch: trunk, size: 22298
2013-02-18
17:10
use "controls_cp=CP_UTF8" property instead of SynUnicode or any other low-level hack file: [55e47f1ee7] check-in: [1141f74f08] user: abouchez branch: trunk, size: 22069
2013-02-13
16:54
  • use ZEOS metadata to retrieve table names and field definitions from any supported database (not only our SynDB.TSQLDBDefinition list)
  • SynDBZEOS unit has been tested with Firebird embedded :)
 file: [17fbc14ee4] check-in: [0915f96737] user: abouchez branch: trunk, size: 22672
2013-02-12
17:00
huge enhancements of the SynDB layers, with ZEOS and UniDAC support file: [0a90096720] check-in: [ee4c1ea74a] user: abouchez branch: trunk, size: 19193
2013-02-11
17:15
SynDBZEOS direct access tested with Oracle 11g - directly call the ZDBC abstract layer of ZEOS, by-passing the TDataset components overhead file: [44b2a98dbf] check-in: [c605ec0b55] user: abouchez branch: trunk, size: 18343
17:11
Renamed SynDBDataset/SynDBZEOS.pas → SynDBZEOS.pas. SynDBZEOS.pas moved to repository root folder, since new version is to not tied to TDataSet / SynDBDataset.pas, but implements direct access to the ZDBC layer - tested with Oracle by now file: [3182828f46] check-in: [b24bebadca] user: abouchez branch: trunk, size: 17027
©2010-2022 Synopse Informatique