libzdb-general

libzdb-general@tildeslash.com

2 participants
147 discussions

Start a nNew thread

svn repository
by Jan-Henrik Haukeland 21 Mar '08

21 Mar '08

FYI: libzdb svn repository is available here http://code.google.com/p/libzdb/source/checkout

2 5

how to deal with longjmp warnings
by Paul J Stevens 12 Mar '08

12 Mar '08

Hi there, I'm busy adding try/catch macros around all my queries, but now my compiler starts to complain: warning: variable 'xyz' might be clobbered by 'longjmp' or 'vfork' Any suggestion on how best to deal with these? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 2

[Announce] libzdb 2.1
by Jan-Henrik Haukeland 04 Mar '08

04 Mar '08

Version 2.1 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.1.tar.gz MD5 checksum: 5abec56051f105cacb6dcec237a1d989 Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a feature release which has been tested on the following platforms: Darwin 9.1.0 [ppc/x86] Linux Ubuntu [x86] Changes in this release: Version 2.1 ----------- * API: Connection_ping is promoted to a public method. Clients can use this method to test if a Connection is alive. * API: Connection_clear() is exposed as a public method. Normally it is not necessary to call this method, but in some situations, if you use PreparedStatement_executeQuery it is necessary to call this function to close a prepared statement explicit. Basically, if you see this SQLite error, "SQL statements in progress", call this function to close any previous opened statements before proceeding. * Upon returning a Connection, the Connection Pool previously tried to commit a Connection if it was in a non-committed state, while now it rollback instead, which is assumed to be more correct. * Improved retry when SQLite report database lock, which should reduce the chance to meet the infamous SQLite "database is locked" error * Removed section 3 from "Tildeslash License Exception" so libzdb is licensed clear and permissive. * Internal optimizing changes

3 12

postgres wont do preparedstatements
by Paul J Stevens 25 Feb '08

25 Feb '08

Jan-Henrik, So I converted dbmail to use libzdb, and use prepared statements. But I can't seem to get prepared statements to work for postgresql. Sqlite and mysql work as expected by postgres keeps throwing exceptions. My test code reads: //URL_T url = \ URL_new("postgresql://localhost:5432/dbmail?user=dbmail&password=dbmail"); URL_T url = URL_new("postgresql://dbmail:dbmail@localhost/dbmail"); ConnectionPool_T pool = ConnectionPool_new(url); Connection_T con = ConnectionPool_getConnection(pool); PreparedStatement_T p = Connection_prepareStatement(con, "SELECT * FROM dbmail_users WHERE userid=?"); THis keeps throwing exception at: Uncaught exception SQLException raised in Connection_prepareStatement at src/db/Connection.c:294 On the postgres side all I see is: 2008-02-23 09:46:48 CET DEBUG: parse 1804289383: SELECT * FROM dbmail_users WHERE userid=$1 2008-02-23 09:46:48 CET DEBUG: StartTransactionCommand 2008-02-23 09:46:48 CET DEBUG: StartTransaction 2008-02-23 09:46:48 CET DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 2270118/1/0, nestlvl: 1, children: <> 2008-02-23 09:46:48 CET DEBUG: CommitTransactionCommand 2008-02-23 09:46:48 CET DEBUG: CommitTransaction 2008-02-23 09:46:48 CET DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 2270118/1/1, nestlvl: 1, children: <> 2008-02-23 09:46:48 CET LOG: unexpected EOF on client connection Any ideas? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 8

[Announce] libzdb 2.0.1
by Jan-Henrik Haukeland 10 Jun '07

10 Jun '07

Version 2.0.1 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.0.1.tar.gz MD5 checksum: ce379f198aa3a1ab1a6e4699ebccd683 libzdb-2.0.1.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a minor feature 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.1 ----------- * ConnectionPool_version() is now a class method * Minor internal changes Future plans include adding date/time handling to ResultSet and PreparedStatements.

1 0

[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

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