libzdb-general

libzdb-general@tildeslash.com

1 participants
152 discussions

[Announce] libzdb 2.0
by Jan-Henrik Haukeland 12 Feb '07

12 Feb '07

Version 2.0 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.0.tar.gz MD5 checksum: dd68ec3ea782da704ea7d33c28b04107 libzdb-2.0.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a feature and bug fix release which has been tested on the following platforms: Darwin 8.8.1 [ppc/x86] Linux FC [x86] Changes in this release: Version 2.0 ----------- * Exceptions handling added to the library. This change how clients should use the library. Methods in the library that can throw an SQL Exception should now be called from inside a try-catch block. Bug fixes: * Fixed a PostgreSQL prepared statement bug. If parts of a statement was defined after its last parameter, preparation failed. About exceptions handling: Exceptions handling ------------------- The library implements an elegant solution for providing thread-safe exceptions handling to clients. Use of exceptions are recommend since it provides better error reporting and frees programmers from the tedious return-code idiom for dealing with errors. The API documents every method that can throw an exception. Methods in the library that can throw an exception should be called from inside a try-catch block. The implementation is concise and does not add much overhead to the library. However, handling of errors will be slower compared to just testing return values. A raised exception must do a jump up the stack frame to its nearest installed exception handler. The difference in time should be negligible though and in microseconds if not nano. Exception handling is included by default when building the library, but may optionally be turned off at configure time. To disable this feature use the configure switch --disable-exceptions What does this means in form of code changes? For example, instead of writing: if (!PreparedStatement_setString(p, 1, x)) { [handle error] } if (!PreparedStatement_setString(p, 2, y)) { [handle error] } if (!PreparedStatement_setInt(p, 3, z)) { [handle error] } You should now write: TRY PreparedStatement_setString(p, 1, x); PreparedStatement_setString(p, 2, y); PreparedStatement_setInt(p, 3, z); PreparedStatement_execute(p); CATCH(SQLException) log("SQL error: %s\n", Connection_getLastError(con); END_TRY; See also http://www.tildeslash.com/libzdb/api-docs/Exception_8h.html for details. We hope this is a welcome feature and that it will make it even easier to program against the library. If you absolutely do not want this feature, remember that it is possible to disable it at configure time.

1 0

Bug in mysql backend.
by José Antonio Sánchez 07 Feb '07

07 Feb '07

I was using libzdb to save data to a sqlite database. Now I've decided to try MySQL but I've found that it saves integer data as wrong values. I've attached a test program. It creates the same table in a sqlite database and mysql database, then it adds a row to each of them. When I make a query in sqlite I get the right value but in MySQL all the integer values are replaced by 1. I'm using Ubuntu Edgy (6.10) with MySQL 5.0.24a (the official Ubuntu version) and 3.3.5 (official too). Running the test, I get the following in mysql: mysql> select * from Operations; +---------+-----------+--------+------+--------+------+------+------+------+------+------------------------+ | transId | timestamp | isUndo | seq | opName | arg1 | arg2 | arg3 | arg4 | arg5 | saveBlob | +---------+-----------+--------+------+--------+------+------+------+------+------+------------------------+ | trans1 | timestamp | 1 | 1 | 1 | arg1 | arg2 | NULL | NULL | NULL | Very Large Binary Blob | +---------+-----------+--------+------+--------+------+------+------+------+------+------------------------+ 1 row in set (0.00 sec) -- Saludos. José Antonio Sánchez

2 1

[Announce] libzdb 1.1.3
by Jan-Henrik Haukeland 07 Feb '07

07 Feb '07

Version 1.1.3 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-1.1.3.tar.gz MD5 checksum: 1449af48017ecc79c623ccb115a45f8b libzdb-1.1.3.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a bug fix release which has been tested on the following platforms: Darwin 8.8.1 [ppc/x86] Linux FC [x86] Changes in this release: * This release fixes a MySQL prepared statement bug. If a prepared statement was used with two or more number parameters, the numbers was saved with a bogus value in the database. Thanks to José Antonio Sánchez for the report.

1 0

[Announce] libzdb 1.1.2
by Jan-Henrik Haukeland 02 Jan '07

02 Jan '07

Version 1.1.2 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-1.1.2.tar.gz MD5 checksum: 65323503f2a44123e12197db877b8972 libzdb-1.1.2.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a minute feature release which has been tested on the following platforms: Linux FC [x86] Darwin 8.7.1 [ppc/x86] Changes in this release: * ResultSet_next() can be given a NULL value, upon which FALSE is returned * Minor internal changes

1 0

[Announce] libzdb 1.1
by Jan-Henrik Haukeland 04 Nov '06

04 Nov '06

Version 1.1 of Zild Database Library is available: Download from: http://www.tildeslash.com/libzdb/dist/libzdb-1.1.tar.gz MD5 checksum: 632a0f8ca709e98b2b702426ed277c9d Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a feature release which has been tested on the following platforms: Linux 2.6 [x86] Darwin 8.8.1 [ppc/x86] This release introduce among others the following changes: * Added PostgreSQL support to the library * From this release, the caller is responsible for freeing the URL_T object used in ConnectionPool_new(), via the URL_free() method. * Removed the viral clausal from the exceptions license

1 0

Database lock problem.
by José Antonio Sánchez 30 Oct '06

30 Oct '06

Hello, I'm having a problem with libzdb. I have a connection pool to sqlite and I get a connection to perform a select query. Now, while processing the result set I want to update certain tables from the database. The problem is: If I get a new connection from the pool I get a "database file is locked" so I'm gessing that a connection locks the database file while it's active. The other solution may be to use the same conection to execute the update, but that messes the result set to when it tries to get next element I get a Segmentation Fault. Is there a way to open a "Read only" connection so it doesn't lock the entire database? If not, is there a way to make a copy of a result set to execute another query? -- Saludos. José Antonio Sánchez

2 2

[Announce] libzdb 1.1 beta
by Jan-Henrik Haukeland 30 Oct '06

30 Oct '06

Version 1.1-beta of Zild Database Library is available: Download from: http://www.tildeslash.com/libzdb/dist/libzdb-1.1- beta.tar.gz MD5 checksum: 0f21dd6c7a7fd454d69998bd7b24b943 libzdb-1.1-beta.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a feature release which has been tested on the following platforms: Linux 2.6 [x86] Darwin 8.8.1 [ppc/x86] This release introduce among others the following new features: * Added PostgreSQL support to the library * Removed the viral clausal from the exceptions license

1 1

patch to allow building on debian/ubuntu
by Paul J Stevens 23 Oct '06

23 Oct '06

Hi there, This simple patch will allow building libzdb on debian/ubuntu machines: regards, -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 2

[Announce] libzdb 1.0.4
by Jan-Henrik Haukeland 25 Aug '06

25 Aug '06

Version 1.0.4 of Zild Database Library is available: Download from: http://www.tildeslash.com/libzdb/dist/libzdb-1.0.4.tar.gz MD5 checksum: ac61dde8fde854dca394dd56a7fd55a7 libzdb-1.0.4.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a feature and bugfix release which has been tested on the following platforms: Linux FC [x86] Darwin 8.7.1 [ppc/x86] This release introduce among others the following new features: * Using new versions of auto-tools so shared library extension is set correct * Simplified and removed section 4 of the license exception * Include bootstrap script for recreating configure Ps. Support for Postgres is in the pipeline

1 0

[Announce] libzdb 1.0.3
by Jan-Henrik Haukeland 16 Mar '06

16 Mar '06

Version 1.0.3 of Zild Database Library is available: Download from: http://www.tildeslash.com/libzdb/dist/libzdb-1.0.3.tar.gz MD5 checksum: 0f87108b4a27a2bc6fc0cb013e104d0b libzdb-1.0.3.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a feature and bugfix release which has been tested on the following platforms: Linux FC [x86] Darwin 8.5.0 [ppc] This release introduce among others the following new features: * Clear any previous resultset when calling Connection_execute(). This allow MySQL implementations to issue a Connection_executeQuery() followed by Connection_execute() without having to close the Connection first. * Changed declaration of AbortHandler() so clients are not required to provide this function.

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

libzdb-general