- libzdb-general - tildeslash.com

Abwesenheitsnotiz: Abwesenheitsnotiz: Abwesenheitsnotiz: Abwesenheitsnotiz: [PATCH] Change of include declaration in headers to get library working on Fedora and Debian
by jonas.schnelli＠include7.ch 19 Jul '11

19 Jul '11

Sehr geehrte Damen und Herren Ich bin vom Dienstag 19. Juli bis Mittwoch 10. August abwesend. Dieses E-Mail wird NICHT automatisch weitergeleitet. Dieses E-Mail wird verzögert gelesen und beantwortet. In dringenden Fällen bitte ich Sie, auf unsere Hauptnummer 044 500 16 70 anzurufen oder meine Vertretung Philippe Wüger (philippe.wueger AT include7 PUNKT ch) zu kontaktieren. Besten Dank. Freundliche Grüsse Jonas Schnelli

1 0

Abwesenheitsnotiz: Abwesenheitsnotiz: Abwesenheitsnotiz: [PATCH] Change of include declaration in headers to get library working on Fedora and Debian
by jonas.schnelli＠include7.ch 19 Jul '11

19 Jul '11

Sehr geehrte Damen und Herren Ich bin vom Dienstag 19. Juli bis Mittwoch 10. August abwesend. Dieses E-Mail wird NICHT automatisch weitergeleitet. Dieses E-Mail wird verzögert gelesen und beantwortet. In dringenden Fällen bitte ich Sie, auf unsere Hauptnummer 044 500 16 70 anzurufen oder meine Vertretung Philippe Wüger (philippe.wueger AT include7 PUNKT ch) zu kontaktieren. Besten Dank. Freundliche Grüsse Jonas Schnelli

1 0

Abwesenheitsnotiz: Abwesenheitsnotiz: [PATCH] Change of include declaration in headers to get library working on Fedora and Debian
by jonas.schnelli＠include7.ch 19 Jul '11

19 Jul '11

Sehr geehrte Damen und Herren Ich bin vom Dienstag 19. Juli bis Mittwoch 10. August abwesend. Dieses E-Mail wird NICHT automatisch weitergeleitet. Dieses E-Mail wird verzögert gelesen und beantwortet. In dringenden Fällen bitte ich Sie, auf unsere Hauptnummer 044 500 16 70 anzurufen oder meine Vertretung Philippe Wüger (philippe.wueger AT include7 PUNKT ch) zu kontaktieren. Besten Dank. Freundliche Grüsse Jonas Schnelli

1 0

Abwesenheitsnotiz: [PATCH] Change of include declaration in headers to get library working on Fedora and Debian
by jonas.schnelli＠include7.ch 19 Jul '11

19 Jul '11

Sehr geehrte Damen und Herren Ich bin vom Dienstag 19. Juli bis Mittwoch 10. August abwesend. Dieses E-Mail wird NICHT automatisch weitergeleitet. Dieses E-Mail wird verzögert gelesen und beantwortet. In dringenden Fällen bitte ich Sie, auf unsere Hauptnummer 044 500 16 70 anzurufen oder meine Vertretung Philippe Wüger (philippe.wueger AT include7 PUNKT ch) zu kontaktieren. Besten Dank. Freundliche Grüsse Jonas Schnelli

1 0

[PATCH] Change of include declaration in headers to get library working on Fedora and Debian
by Michel Verbraak 19 Jul '11

19 Jul '11

We created the following patch because we could not use the header files without this patch. Regards -- Michel Verbraak

1 0

url escaping sqlite
by Jonas Schnelli 03 May '11

03 May '11

Hi Guys I've just started using libzdb for a iOS (iPad) project. We use it because one software component has to be written in C (so, ... no use of CoreData or Object-C wrapper!). I've encountered a problem SQLiteConnection.c. As far as i see it's not possible to have url escaped Path for sqlite (because the path for iOS Simulator has multiple " " (whitespaces)). I've changed line 80 to: const char *path = URL_unescape(URL_getPath(url)); Patch: *** vendor/libzdb-2.8.1/src/db/sqlite/SQLiteConnection.c 2011-02-15 01:13:35.000000000 +0100 --- vendor/libzdb-2.8.1/src/db/sqlite/SQLiteConnection_modified.c 2011-05-03 11:35:25.000000000 +0200 *************** *** 76,82 **** static sqlite3 *doConnect(URL_T url, char **error) { sqlite3 *db; ! const char *path = URL_getPath(url); if (! path) { *error = Str_dup("no database specified in URL"); return NULL; --- 76,86 ---- static sqlite3 *doConnect(URL_T url, char **error) { sqlite3 *db; ! ! const char *path = URL_unescape(URL_getPath(url)); ! ! ! if (! path) { *error = Str_dup("no database specified in URL"); return NULL; ################################# Maybe theres another solution. If not, maybe the patch will find his way to the main trunk. -- Jonas °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° include7 AG Jonas Schnelli Grüngasse 10 CH-8004 Zürich Switzerland Office: +41 44 500 16 70 Skype: jonas.schnelli Mail: jonas.schnelli(a)include7.ch Web: www.include7.ch V-Card: www.include7.ch/js.vcf °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°° ACHTUNG Bitte senden sie uns keine sensitiven Daten in unverschlüsselten E-Mails. Verwenden Sie hierzu folgenden Link: https://include7.ch/contact/secureform °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°

2 1

[Announce] libzdb 2.8.1
by Jan-Henrik Haukeland 24 Feb '11

24 Feb '11

Version 2.8.1 of libzdb is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.8.1.tar.gz MD5 checksum: 6b27930096a499eaea4ce5c65bb35e03 This is a bug fix release which fixes a transaction related memory leak in the Oracle driver. There are no other changes.

1 0

[Announce] libzdb 2.8
by Jan-Henrik Haukeland 15 Feb '11

15 Feb '11

Hello everyone Version 2.8 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.8.tar.gz MD5 checksum: 9f9a096e04d1f37ad2829ea6c7d43d0b This is a small feature and bug fix release which has been tested on the following platforms: * Linux 2.6 (x86 and x64) * Mac OS X Snow Leopard (Darwin 10.6.x i386/x86_64) * Mac OS X Leopard (Darwin 10.5.x ppc) * FreeBSD 6.x, 7.x and 8.x (x86 and x64) * Solaris 10 and Solaris Express (sparc and x86) * OpenBSD 4.x (x86 and x64) Changes in this release: ------------------------ Improvements * Allow spaces in URL property values * PostgreSQL: Allow sending application name to the server for logging. Thanks to Chris Mayo. The application name will show up in PostgreSQL logs for connections and operations made through libzdb. To use, add the application-name property to the URL: postgresql://localhost/test??application-name=My Application&.. Bug fixes * ResultSet_getBlob: Ensure that returned blob size is 0 if blob is SQL null. * Oracle: Fixed ResultSet memory leak.

1 0

Request PostgreSQL application_name support
by Chris Mayo 04 Jan '11

04 Jan '11

PostgreSQL 9.0 adds the feature for connections to set an application name that shows up in logs and the system view pg_stat_activity. http://www.postgresql.org/docs/9.0/static/runtime-config-logging.html#RUNTI… All previous versions of PostgreSQL back to 7.4 were patched in minor releases in December 2009 so that they ignore this parameter e.g. http://www.postgresql.org/docs/9.0/static/release-7-4-27.html But I think it would cause problems for servers that hadn't been updated. Patch attached that works for me (both with and without setting application_name). But it is just a quick copy and paste job! Chris

2 3

master/slave
by Zbierski Christophe 04 Jan '11

04 Jan '11

Hello and Happy New Year. I use zdb to connect to two mysql databases (one master and one slave). I implement this management master/slave around zdb, but I think it would be preferable to implement this function directly into the library. Does this type of development is planned in the future, or I can propose a change on this point. Thank you Christophe Zbierski Ce message et les pièces jointes sont confidentiels et réservés à l'usage exclusif de ses destinataires. Il peut également être protégé par le secret professionnel. Si vous recevez ce message par erreur, merci d'en avertir immédiatement l'expéditeur et de le détruire. L'intégrité du message ne pouvant être assurée sur Internet, la responsabilité du groupe Atos Origin ne pourra être recherchée quant au contenu de ce message. Bien que les meilleurs efforts soient faits pour maintenir cette transmission exempte de tout virus, l'expéditeur ne donne aucune garantie à cet égard et sa responsabilité ne saurait être recherchée pour tout dommage résultant d'un virus transmis. This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos Origin group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted.

2 1

Dynamic loading of database driver
by Matthieu Verbert 08 Nov '10

08 Nov '10

Hi all, I implemented the feature noted in $subject on top of libzdb 2.7 (trunk@380). My initial goal was to produce a nicer package which would not require to install client libraries for database system I don't use. I made the feature optional (disabled by default in configure, new option '--enable-libdl'), and it is lightly tested (test/select still works after the 2 below patches are applied, both with the libdl enabled or not). The only extra-requirement is that the patch uses GCC non-standard "__attribute__ ((constructor))" to not have to modify any user. I didn't even try to implement driver unloading, although it is certainly possible too. Let me know what you think of it. Thanks, Matthieu >From 234b8f8145872ee6dc02d66e4aa6cd39c5a603b4 Mon Sep 17 00:00:00 2001 From: Matthieu Verbert <matthieu.verbert(a)aitb.org> Date: Sat, 6 Nov 2010 13:02:04 +0100 Subject: [PATCH 1/2] Update autotools to support multiple libs and libdl Create separate variables for each database 'driver', and add them only where they need to be used (Oracle untested). configure's behaviour is unchanged if libdl is not enabled, else multiple libraries will be created. Note that the test program breaks at link time if this option is enabled. --- Makefile.am | 76 +++++++++++++++++++++++++++++++++++++++--------- configure.ac | 90 ++++++++++++++++++++++++++++++++++++---------------------- 2 files changed, 117 insertions(+), 49 deletions(-) diff --git a/Makefile.am b/Makefile.am index 31d92cd..2061c3d 100644 --- a/Makefile.am +++ b/Makefile.am @@ -14,7 +14,7 @@ RE2C = @RE2C@ RE2CFLAGS = -b FILTERH = ./tools/bin/filterh -AM_CPPFLAGS = $(CPPFLAGS) $(DBCPPFLAGS) +AM_CPPFLAGS = INCLUDES = -Isrc -Isrc/util -Isrc/net -Isrc/db -Isrc/exceptions lib_LTLIBRARIES = libzdb.la @@ -23,29 +23,75 @@ libzdb_la_SOURCES = src/util/Util.c src/util/Str.c src/util/Mem.c \ src/db/Connection.c src/db/ResultSet.c \ src/db/PreparedStatement.c src/util/StringBuffer.c \ src/exceptions/assert.c src/exceptions/Exception.c - if ! WITH_ZILD libzdb_la_SOURCES += src/net/URL.c endif + +libzdb_la_LDFLAGS = +noinst_LTLIBRARIES = +libzdb_la_LIBADD = + +if WITH_LIBDL +libzdb_la_LDFLAGS += -ldl +endif + if WITH_MYSQL -libzdb_la_SOURCES += src/db/mysql/MysqlConnection.c \ - src/db/mysql/MysqlResultSet.c \ - src/db/mysql/MysqlPreparedStatement.c +if WITH_LIBDL +lib_LTLIBRARIES += libzdb-mysql.la +else +noinst_LTLIBRARIES += libzdb-mysql.la +libzdb_la_LIBADD += libzdb-mysql.la endif + +libzdb_mysql_la_SOURCES = src/db/mysql/MysqlConnection.c \ + src/db/mysql/MysqlResultSet.c \ + src/db/mysql/MysqlPreparedStatement.c +libzdb_mysql_la_CPPFLAGS = $(DB_MYSQL_CPPFLAGS) +libzdb_mysql_la_LDFLAGS = $(DB_MYSQL_LDFLAGS) +endif # WITH_MYSQL + if WITH_POSTGRESQL -libzdb_la_SOURCES += src/db/postgresql/PostgresqlConnection.c \ - src/db/postgresql/PostgresqlResultSet.c \ - src/db/postgresql/PostgresqlPreparedStatement.c +if WITH_LIBDL +lib_LTLIBRARIES += libzdb-postgresql.la +else +noinst_LTLIBRARIES += libzdb-postgresql.la +libzdb_la_LIBADD += libzdb-postgresql.la endif +libzdb_postgresql_la_SOURCES = src/db/postgresql/PostgresqlConnection.c \ + src/db/postgresql/PostgresqlResultSet.c \ + src/db/postgresql/PostgresqlPreparedStatement.c +libzdb_postgresql_la_CPPFLAGS = $(DB_POSTGRESQL_CPPFLAGS) +libzdb_postgresql_la_LDFLAGS = $(DB_POSTGRESQL_LDFLAGS) +endif # WITH_POSTGRESQL + if WITH_SQLITE -libzdb_la_SOURCES += src/db/sqlite/SQLiteConnection.c \ - src/db/sqlite/SQLiteResultSet.c \ - src/db/sqlite/SQLitePreparedStatement.c +if WITH_LIBDL +lib_LTLIBRARIES += libzdb-sqlite.la +else +noinst_LTLIBRARIES += libzdb-sqlite.la +libzdb_la_LIBADD += libzdb-sqlite.la endif + +libzdb_sqlite_la_SOURCES = src/db/sqlite/SQLiteConnection.c \ + src/db/sqlite/SQLiteResultSet.c \ + src/db/sqlite/SQLitePreparedStatement.c +libzdb_sqlite_la_CPPFLAGS = $(DB_SQLITE_CPPFLAGS) +libzdb_sqlite_la_LDFLAGS = $(DB_SQLITE_LDFLAGS) +endif # WITH_SQLITE + if WITH_ORACLE -libzdb_la_SOURCES += src/db/oracle/OracleConnection.c \ - src/db/oracle/OracleResultSet.c \ - src/db/oracle/OraclePreparedStatement.c +if WITH_LIBDL +lib_LTLIBRARIES += libzdb-oracle.la +else +noinst_LTLIBRARIES += libzdb-oracle.la +libzdb_la_LIBADD += libzdb-oracle.la +endif + +libzdb_oracle_la_SOURCES = src/db/oracle/OracleConnection.c \ + src/db/oracle/OracleResultSet.c \ + src/db/oracle/OraclePreparedStatement.c +libzdb_oracle_la_CPPFLAGS = $(DB_ORACLE_CPPFLAGS) +libzdb_oracle_la_LDFLAGS = $(DB_ORACLE_LDFLAGS) endif @@ -55,7 +101,7 @@ API_INTERFACES = src/zdb.h src/db/ConnectionPool.h src/db/Connection.h \ nobase_nodist_include_HEADERS = $(patsubst %, $(LIBRARY_NAME)/%, $(notdir $(API_INTERFACES))) -libzdb_la_LDFLAGS = $(DBLDFLAGS) -version-info 7:1:0 +AM_LDFLAGS = -version-info 7:1:0 BUILT_SOURCES = $(nobase_nodist_include_HEADERS) diff --git a/configure.ac b/configure.ac index f771cda..ac51435 100644 --- a/configure.ac +++ b/configure.ac @@ -109,6 +109,18 @@ AC_ARG_ENABLE(profiling, ] ) +AC_ARG_ENABLE(libdl, + AS_HELP_STRING([--enable-libdl], + [Use libdl to dynamic load database drivers]), + [AC_CHECK_LIB([dl], [dlopen], [libdl="yes"], [libdl="no"])], + [libdl="no"] +) +if test "xyes" = "x$libdl"; then + AC_DEFINE([HAVE_LIBDL], 1, [Define to 1 to enable libdl]) +fi + +AM_CONDITIONAL([WITH_LIBDL], test "xyes" = "x$libdl") + AC_ARG_ENABLE([openssl], AS_HELP_STRING([--enable-openssl(=<path>)], [Link libzdb with openssl. If database libraries were linked static, @@ -205,6 +217,7 @@ AC_ARG_WITH([mysql], if test "xyes" = "x$mysql"; then svd_CPPFLAGS=$CPPFLAGS svd_LDFLAGS=$LDFLAGS + svd_LIBS=$LIBS CPPFLAGS="`$MYSQLCONFIG --include` $CPPFLAGS" LDFLAGS="`$MYSQLCONFIG --libs` $LDFLAGS" AC_CHECK_HEADERS([mysql.h]) @@ -226,13 +239,15 @@ if test "xyes" = "x$mysql"; then fi ], [mysql="no"], [-lz]) if test "xyes" = "x$mysql"; then - DBCPPFLAGS="$DBCPPFLAGS `$MYSQLCONFIG --include`" - DBLDFLAGS="$DBLDFLAGS `$MYSQLCONFIG --libs`" + DB_MYSQL_CPPFLAGS="`$MYSQLCONFIG --include`" + DB_MYSQL_LDFLAGS="`$MYSQLCONFIG --libs` -lz" AC_DEFINE([HAVE_LIBMYSQLCLIENT], 1, [Define to 1 to enable mysql]) - else - CPPFLAGS=$svd_CPPFLAGS - LDFLAGS=$svd_LDFLAGS + AC_SUBST(DB_MYSQL_LDFLAGS) + AC_SUBST(DB_MYSQL_CPPFLAGS) fi + CPPFLAGS=$svd_CPPFLAGS + LDFLAGS=$svd_LDFLAGS + LIBS=$svd_LIBS fi AM_CONDITIONAL([WITH_MYSQL], test "xyes" = "x$mysql") @@ -273,13 +288,14 @@ if test "xyes" = "x$postgresql"; then LDFLAGS="-L`$PGCONFIG --libdir` $LDFLAGS" AC_CHECK_HEADERS([libpq-fe.h], [], [postgresql="no"]) if test "xyes" = "x$postgresql"; then - DBCPPFLAGS="$DBCPPFLAGS -I`$PGCONFIG --includedir`" - DBLDFLAGS="$DBLDFLAGS -L`$PGCONFIG --libdir` -lpq" + DB_POSTGRESQL_CPPFLAGS="-I`$PGCONFIG --includedir`" + DB_POSTGRESQL_LDFLAGS="-L`$PGCONFIG --libdir` -lpq" AC_DEFINE([HAVE_LIBPQ], 1, [Define to 1 to enable postgresql]) - else - CPPFLAGS=$svd_CPPFLAGS - LDFLAGS=$svd_LDFLAGS + AC_SUBST(DB_POSTGRESQL_LDFLAGS) + AC_SUBST(DB_POSTGRESQL_CPPFLAGS) fi + CPPFLAGS=$svd_CPPFLAGS + LDFLAGS=$svd_LDFLAGS fi AM_CONDITIONAL([WITH_POSTGRESQL], test "xyes" = "x$postgresql") @@ -294,51 +310,52 @@ AC_ARG_WITH([sqlite], sqlite="no" else AC_MSG_RESULT([yes]) - svd_LDFLAGS=$LDFLAGS - svd_CPPFLAGS=$CPPFLAGS - LDFLAGS="-L$with_sqlite/lib $LDFLAGS" - CPPFLAGS="-I$with_sqlite/include $CPPFLAGS" - AC_CHECK_HEADERS([sqlite3.h], [ - sqlite="yes" - if test -r "$with_sqlite/lib/libsqlite3.a"; then - DBCPPFLAGS="$DBCPPFLAGS -I$with_sqlite/include" - DBLDFLAGS="$DBLDFLAGS -L$with_sqlite/lib/ -lsqlite3" - else - sqlite="no" - fi - ], [sqlite="no"]) - LDFLAGS=$svd_LDFLAGS - CPPFLAGS=$svd_CPPFLAGS fi ], [ - AC_MSG_RESULT([yes]) - AC_CHECK_LIB([sqlite3], [sqlite3_open], [], [sqlite="no"]) + AC_MSG_RESULT([yes]) ]) + if test "xyes" = "x$sqlite"; then - AC_DEFINE([HAVE_LIBSQLITE3]) + svd_LDFLAGS=$LDFLAGS + svd_CPPFLAGS=$CPPFLAGS + svd_LIBS=$LIBS + CPPFLAGS="-I$with_sqlite/include $CPPFLAGS" + LDFLAGS="-L$with_sqlite/lib $LDFLAGS" + AC_CHECK_HEADERS([sqlite3.h], [sqlite="yes"], [sqlite="no"]) + AC_CHECK_LIB([sqlite3], [sqlite3_open], [], [sqlite="no"]) + if test "xyes" = "x$sqlite"; then + DB_SQLITE_CPPFLAGS="-I$with_sqlite/include" + DB_SQLITE_LDFLAGS="-L$with_sqlite/lib/ -lsqlite3" + AC_SUBST(DB_SQLITE_CPPFLAGS) + AC_SUBST(DB_SQLITE_LDFLAGS) + fi + LDFLAGS=$svd_LDFLAGS + CPPFLAGS=$svd_CPPFLAGS + LIBS=$svd_LIBS fi + AM_CONDITIONAL([WITH_SQLITE], test "xyes" = "x$sqlite") oracle="yes" AC_MSG_CHECKING(for oracle) AX_LIB_ORACLE_OCI if test -n "$ORACLE_OCI_CFLAGS" -a -n "$ORACLE_OCI_LDFLAGS"; then - DBCPPFLAGS="$DBCPPFLAGS $ORACLE_OCI_CFLAGS" - DBLDFLAGS="$DBLDFLAGS $ORACLE_OCI_LDFLAGS" + DB_ORACLE_CPPFLAGS="$ORACLE_OCI_CFLAGS" + DB_ORACLE_LDFLAGS="$ORACLE_OCI_LDFLAGS" AC_DEFINE([HAVE_ORACLE], 1, [Define to 1 to enable oracle]) + AC_SUBST(DB_ORACLE_CPPFLAGS) + AC_SUBST(DB_ORACLE_LDFLAGS) else oracle="no" fi AM_CONDITIONAL([WITH_ORACLE], test "xyes" = "x$oracle") # Test if any database system was found -if test "xno" = "x$postgresql" -a "xno" = "x$mysql" -a "xno" = "x$sqlite" -a "xno" = "x$oracle"; then - AC_MSG_ERROR([No available database found or selected. Try configure --help]) +if test "xno" = "x$postgresql" -a "xno" = "x$mysql" -a "xno" = "x$sqlite" -a "xno" = "x$oracle" -a "xno" = "x$libdl" ; then + AC_MSG_ERROR([No available database found or selected, and dynamic loading disabled. Try configure --help]) fi -AC_SUBST(DBLDFLAGS) -AC_SUBST(DBCPPFLAGS) # --------------------------------------------------------------------------- # Header files @@ -413,6 +430,11 @@ echo "| Profiling: DISABLED |" else echo "| Profiling: ENABLED |" fi +if test "xno" = "x$libdl"; then +echo "| Dynamically load drivers: DISABLED |" +else +echo "| Dynamically load drivers: ENABLED |" +fi if test "xfalse" = "x$zild_protect"; then echo "| Zild: DISABLED |" else -- 1.7.2.3 >From 462d869e0a7f563eab4129241fb5884480e6da2d Mon Sep 17 00:00:00 2001 From: Matthieu Verbert <matthieu.verbert(a)aitb.org> Date: Sat, 6 Nov 2010 21:11:33 +0100 Subject: [PATCH 2/2] Register 'driver' on library load Add new function ConnectionDelegate_register to add a new 'driver' dynamically. It is auto-loaded, so no need to modify any user. Oracle is not compile-tested, but the conversion is trivial. --- src/db/Connection.c | 65 +++++++++++++++-------------- src/db/ConnectionDelegate.h | 2 + src/db/mysql/MysqlConnection.c | 6 ++- src/db/oracle/OracleConnection.c | 6 ++- src/db/postgresql/PostgresqlConnection.c | 6 ++- src/db/sqlite/SQLiteConnection.c | 6 ++- 6 files changed, 56 insertions(+), 35 deletions(-) diff --git a/src/db/Connection.c b/src/db/Connection.c index cc27cf4..dcfd1e7 100644 --- a/src/db/Connection.c +++ b/src/db/Connection.c @@ -18,7 +18,9 @@ #include <stdio.h> #include <stdarg.h> +#include <dlfcn.h> +#include "StringBuffer.h" #include "URL.h" #include "Vector.h" #include "ResultSet.h" @@ -38,34 +40,11 @@ /* ----------------------------------------------------------- Definitions */ -#ifdef HAVE_LIBMYSQLCLIENT -extern const struct Cop_T mysqlcops; -#endif -#ifdef HAVE_LIBPQ -extern const struct Cop_T postgresqlcops; -#endif -#ifdef HAVE_LIBSQLITE3 -extern const struct Cop_T sqlite3cops; -#endif -#ifdef HAVE_ORACLE -extern const struct Cop_T oraclesqlcops; -#endif +static Vector_T cops; -static const struct Cop_T *cops[] = { -#ifdef HAVE_LIBMYSQLCLIENT - &mysqlcops, -#endif -#ifdef HAVE_LIBPQ - &postgresqlcops, -#endif -#ifdef HAVE_LIBSQLITE3 - &sqlite3cops, -#endif -#ifdef HAVE_ORACLE - &oraclesqlcops, -#endif - NULL -}; +static void __attribute__ ((constructor (200))) init_cops() { + cops = Vector_new(1); +} #define T Connection_T struct T { @@ -87,10 +66,28 @@ struct T { static Cop_T getOp(const char *protocol) { - for (int i = 0; cops[i]; i++) - if (Str_startsWith(protocol, cops[i]->name)) - return (Cop_T)cops[i]; - return NULL; + int e = 0; + do { + for (int i = 0; i < Vector_size(cops); i++) { + Cop_T op = (Cop_T) Vector_get(cops, i); + if (Str_startsWith(protocol, op->name)) + return op; + } + if (e > 0) + break; + { + StringBuffer_T fn = StringBuffer_new("libzdb-"); + StringBuffer_append(fn, protocol); + StringBuffer_append(fn, ".so"); + void * lib = dlopen(StringBuffer_toString(fn), RTLD_LAZY); + StringBuffer_free(&fn); + if (lib) + e++; + else + break; + } + } while (true); + return NULL; } @@ -343,3 +340,9 @@ int Connection_isSupported(const char *url) { return (url ? (getOp(url) != NULL) : false); } + + +void ConnectionDelegate_register(Cop_T op) { + Vector_push(cops, op); +} + diff --git a/src/db/ConnectionDelegate.h b/src/db/ConnectionDelegate.h index 88c959c..8ff485e 100644 --- a/src/db/ConnectionDelegate.h +++ b/src/db/ConnectionDelegate.h @@ -46,5 +46,7 @@ typedef struct Cop_T { const char *(*getLastError)(T C); } *Cop_T; +void ConnectionDelegate_register(Cop_T op); + #undef T #endif diff --git a/src/db/mysql/MysqlConnection.c b/src/db/mysql/MysqlConnection.c index 0f0e848..3159132 100644 --- a/src/db/mysql/MysqlConnection.c +++ b/src/db/mysql/MysqlConnection.c @@ -45,7 +45,7 @@ #define MYSQL_OK 0 -const struct Cop_T mysqlcops = { +static const struct Cop_T mysqlcops = { "mysql", MysqlConnection_new, MysqlConnection_free, @@ -63,6 +63,10 @@ const struct Cop_T mysqlcops = { MysqlConnection_getLastError }; +static void __attribute__ ((constructor (300))) register_mysql() { + ConnectionDelegate_register(&mysqlcops); +} + #define T ConnectionDelegate_T struct T { URL_T url; diff --git a/src/db/oracle/OracleConnection.c b/src/db/oracle/OracleConnection.c index 4d210ff..2267499 100644 --- a/src/db/oracle/OracleConnection.c +++ b/src/db/oracle/OracleConnection.c @@ -44,7 +44,7 @@ /* ----------------------------------------------------------- Definitions */ -const struct Cop_T oraclesqlcops = { +static const struct Cop_T oraclesqlcops = { "oracle", OracleConnection_new, OracleConnection_free, @@ -62,6 +62,10 @@ const struct Cop_T oraclesqlcops = { OracleConnection_getLastError }; +static void __attribute__ ((constructor (300))) register_oracle() { + ConnectionDelegate_register(&oraclesqlcops); +} + #define ERB_SIZE 152 #define ORACLE_TRANSACTION_PERIOD 10 diff --git a/src/db/postgresql/PostgresqlConnection.c b/src/db/postgresql/PostgresqlConnection.c index e477c73..0bdd854 100644 --- a/src/db/postgresql/PostgresqlConnection.c +++ b/src/db/postgresql/PostgresqlConnection.c @@ -41,7 +41,7 @@ /* ----------------------------------------------------------- Definitions */ -const struct Cop_T postgresqlcops = { +static const struct Cop_T postgresqlcops = { "postgresql", PostgresqlConnection_new, PostgresqlConnection_free, @@ -59,6 +59,10 @@ const struct Cop_T postgresqlcops = { PostgresqlConnection_getLastError }; +static void __attribute__ ((constructor (300))) register_postgresql() { + ConnectionDelegate_register(&postgresqlcops); +} + #define T ConnectionDelegate_T struct T { URL_T url; diff --git a/src/db/sqlite/SQLiteConnection.c b/src/db/sqlite/SQLiteConnection.c index ab102ae..175bb9b 100644 --- a/src/db/sqlite/SQLiteConnection.c +++ b/src/db/sqlite/SQLiteConnection.c @@ -39,7 +39,7 @@ /* ----------------------------------------------------------- Definitions */ -const struct Cop_T sqlite3cops = { +static const struct Cop_T sqlite3cops = { "sqlite", SQLiteConnection_new, SQLiteConnection_free, @@ -57,6 +57,10 @@ const struct Cop_T sqlite3cops = { SQLiteConnection_getLastError }; +static void __attribute__ ((constructor (300))) register_sqlite() { + ConnectionDelegate_register(&sqlite3cops); +} + #define T ConnectionDelegate_T struct T { URL_T url; -- 1.7.2.3

2 2

[Announce] libzdb 2.7
by Jan-Henrik Haukeland 14 Oct '10

14 Oct '10

"Good news, everyone!" Version 2.7 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.7.tar.gz MD5 checksum: 8c7241e482c88076739df96dc578143d 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: * Linux 2.6 (x86 and x64) * Mac OS X Snow Leopard (Darwin 10.6.x i386/x86_64) * Mac OS X Leopard (Darwin 10.5.x ppc) * FreeBSD 6.x, 7.x and 8.x (x86 and x64) * Solaris 10 and Solaris Express (sparc and x86) * OpenBSD 4.x (x86 and x64) Release notes: -------------- This release brings tentative Oracle support to libzdb thanks to Volodymyr Tarasenko. If you already have Oracle installed on your system, then simply running configure should pick it up. Otherwise if you want to build libzdb with Oracle support, but don't have Oracle installed (like me) it is a bit more work. Here's what I did; download Instant Client (basic and sdk) from http://www.oracle.com/ Create a oci directory someplace and copy header files and libs into this directory. Then use this configure statement; ./configure --with-oci-include=/<path>/oci/include --with-oci-lib=/<path>/oci/lib The Oracle implementation is not quite yet production ready which emerge from the change log below, though for most practical purposes it should work - according to Volodymyr. If you want to help out testing and improving it, please do. The SQLite implementation has been further improved by adding a configure option to make SQLite release unused memory. This is very useful as SQLite does not care so much about releasing memory and its memory usage can grow considerably if left unchecked. Changes in this release: ------------------------ * Added tentative support for Oracle. Thanks to Volodymyr Tarasenko, and Sergey Pavlov for implementing this. This implementation does not support BLOB, though CLOB is supported. It will also not run all zdb unit tests, but should be useful for most purposes. It is released with the hope that others may still find it useful and help iron out any remaining issues. * Added new convenience zdb.h meta include file which can be used to include all required API interfaces * Internal optimizing changes and improvements - we simply adore refactoring * SQLite: Clear connection on rollback to prevent SQLite from issue an SQLITE_BUSY error if there are pending selects in progress. * SQLite: added a "heap_limit" URL property. Makes SQLite auto-release unused memory if memory usage goes above the specified limit [KB]. Require that SQLite is compiled with the SQLITE_ENABLE_MEMORY_MANAGEMENT option to take effect. Bug fixes: * SQLite: Ensure that the database file is specified in connection URL. Thanks to Bogdan Nicula. * PostgreSQL: Implemented Connection_setQueryTimeout()

3 4

Re: Configure/compile issues on Solaris SPARC
by Lou Picciano 11 Aug '10

11 Aug '10

Martin, Thanks for your response. the reason why postgresql library was not found by ldd on your system is, that the loader path is not set to it. You need to fix the loader path either using solaris' "crle" utility or setting LD_LIBRARY_PATH env. variable. We are well aware of the crle tool. It does offer some powerful utility for environment-wide runtime linking; but this is definitely not what we want to do. The preferred approach is to link the correct libraries - often different versions for different purposes - against specific binaries. We could fiddle with the runtime environment of each binary in any number of ways, but this is just 'bad practice'; to create one-off solutions to the runtime environment for each executable. This is a management nightmare! Regarding mysql version - the error is reported because mysql.h file contains invalid version. (I don't think it does, if your test is >= 4.1): # grep MYSQL_VERSION_ID /usr/local/mysql/include/mysql/mysql.h #if defined(EMBEDDED_LIBRARY) || defined(EMBEDDED_LIBRARY_COMPATIBLE) || MYSQL_VERSION_ID >= 50100 1.) attach config.log so we can check it 2.) provide output of "grep MYSQL_VERSION_ID /path/to/your/mysql.h" I just ran the whole process against against a freshly-downloaded source tree to provide you an empirical test. (FWIW, an # configure distclean left our previous source tree in an unconfigure-able state). I even added the LD_LIBRARY_PATH variable, in case you're testing for it in config. (Didn't see any evidence you were). ./configure \ CPPFLAGS='-I/usr/local/postgres/9b4/include/' \ LDFLAGS='-L/usr/local/postgres/9b4/lib/' \ LD_LIBRARY_PATH='/usr/local/postgres/9b4/lib/' \ PGCONFIG='/usr/local/postgres/9b4/bin/pg_config' \ --enable-optimized \ --enable-protected \ --enable-openssl=/usr/local/ssl \ --enable-sqliteunlock \ --with-mysql=/usr/local/mysql/bin/mysql_config \ --with-postgresql=/usr/local/postgres/9b4/bin/pg_config \ --with-sqlite=/usr/local Here's the result of configure: +------------------------------------------------------------+ | The Zild Database Library is configured as follows: | | | | Optimized: ENABLED | | Protected: ENABLED | | Profiling: DISABLED | | Zild: DISABLED | | Sqlite3 unlock notification API: ENABLED | | Unit Tests Build: DISABLED | | Openssl: ENABLED | |------------------------------------------------------------| | SQLite3: ENABLED | | MySQL: DISABLED | | PostgreSQL: ENABLED | +------------------------------------------------------------+ Here is the output of ldd: # ldd /usr/local/lib/libzdb.so libpq.so.5 => (file not found) libsqlite3.so.0 => /usr/local/lib/libsqlite3.so.0 (...etc) (this build does not link at all to any mysql client... As I've mentioned, I've been able to get a mysqlclient linked in by modifying the configure script) And the config.log is attached. Thanks for your ideas. Lou ----- Original Message ----- From: "Martin Pala" <martinp(a)tildeslash.com> To: "This is the libzdb general mailing list" <libzdb-general(a)tildeslash.com> Sent: Wednesday, August 11, 2010 3:28:44 PM Subject: Re: Configure/compile issues on Solaris SPARC Lou, the reason why postgresql library was not found by ldd on your system is, that the loader path is not set to it. You need to fix the loader path either using solaris' "crle" utility or setting LD_LIBRARY_PATH env. variable. Regarding mysql version - the error is reported because mysql.h file contains invalid version. Please: 1.) attach config.log so we can check it 2.) provide output of "grep MYSQL_VERSION_ID /path/to/your/mysql.h" On Aug 11, 2010, at 9:18 PM, Lou Picciano wrote: Paul, > let me guess. There is an older mysql.h somewhere other than /usr/local/mysql/include/ Indeed there is. In fact, there may be a few, as would be normal on these systems; different versions of not only MySQL, but of any number of tools, used in different ways for different objectives, or to test different variables. This is very common in our testing of multiple versions of OpenSSL, for example, and works flawlessly... But what's relevant in this case, I should think, is that the specific version of MySQL to which we point, using configure, --with-mysql=/usr/local/mysql/bin/mysql_config \ ...is indeed >= 4.1, as indicated by this note: # /usr/local/mysql/bin/mysql_config --version 5.0.51 In further testing, we were able to achieve the MySQL integration by 'manhandling' the configure script - shouldn't have to do this! - but cannot get the correct version of PostgreSQL recognized: # ldd /usr/local/lib/libzdb.so libpq.so.4 => /usr/lib/libpq.so.4 -- OR, Depending on configuration: ---- libpq.so.5 => (file not found) libsqlite3.so.0 => /usr/local/lib/libsqlite3.so.0 libmysqlclient.so.15 => /usr/local/mysql/lib/mysql/libmysqlclient.so.15 even though we're pointing to an instance of PostgreSQL in an entirely different location. --with-postgresql=/usr/local/postgres/9b4/bin/pg_config Are you maintaining the libzdb package, too? What do you think the answer is? Lou ----- Original Message ----- From: "Paul J Stevens" < paul(a)nfg.nl > To: "This is the libzdb general mailing list" < libzdb-general(a)tildeslash.com > Sent: Wednesday, August 11, 2010 2:26:39 PM Subject: Re: Configure/compile issues on Solaris SPARC Me again :-) Lou, let me guess. There is an older mysql.h somewhere other than /usr/local/mysql/include/ On 08/11/2010 06:57 PM, Lou Picciano wrote: > > # nm /usr/local/mysql/lib/mysql/libmysqlclient.so | grep mysql_init > 000300f0 T mysql_init > > ) > > Some pertinent output from configure: > > ... -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl -- To unsubscribe: http://www.tildeslash.com/mailman/listinfo/libzdb-general -- To unsubscribe: http://www.tildeslash.com/mailman/listinfo/libzdb-general -- To unsubscribe: http://www.tildeslash.com/mailman/listinfo/libzdb-general

2 1

Re: Configure/compile issues on Solaris SPARC
by Lou Picciano 11 Aug '10

11 Aug '10

Paul, > let me guess. There is an older mysql.h somewhere other than /usr/local/mysql/include/ Indeed there is. In fact, there may be a few, as would be normal on these systems; different versions of not only MySQL, but of any number of tools, used in different ways for different objectives, or to test different variables. This is very common in our testing of multiple versions of OpenSSL, for example, and works flawlessly... But what's relevant in this case, I should think, is that the specific version of MySQL to which we point, using configure, --with-mysql=/usr/local/mysql/bin/mysql_config \ ...is indeed >= 4.1, as indicated by this note: # /usr/local/mysql/bin/mysql_config --version 5.0.51 In further testing, we were able to achieve the MySQL integration by 'manhandling' the configure script - shouldn't have to do this! - but cannot get the correct version of PostgreSQL recognized: # ldd /usr/local/lib/libzdb.so libpq.so.4 => /usr/lib/libpq.so.4 -- OR, Depending on configuration: ---- libpq.so.5 => (file not found) libsqlite3.so.0 => /usr/local/lib/libsqlite3.so.0 libmysqlclient.so.15 => /usr/local/mysql/lib/mysql/libmysqlclient.so.15 even though we're pointing to an instance of PostgreSQL in an entirely different location. --with-postgresql=/usr/local/postgres/9b4/bin/pg_config Are you maintaining the libzdb package, too? What do you think the answer is? Lou ----- Original Message ----- From: "Paul J Stevens" <paul(a)nfg.nl> To: "This is the libzdb general mailing list" <libzdb-general(a)tildeslash.com> Sent: Wednesday, August 11, 2010 2:26:39 PM Subject: Re: Configure/compile issues on Solaris SPARC Me again :-) Lou, let me guess. There is an older mysql.h somewhere other than /usr/local/mysql/include/ On 08/11/2010 06:57 PM, Lou Picciano wrote: > > # nm /usr/local/mysql/lib/mysql/libmysqlclient.so | grep mysql_init > 000300f0 T mysql_init > > ) > > Some pertinent output from configure: > > ... -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl -- To unsubscribe: http://www.tildeslash.com/mailman/listinfo/libzdb-general

2 1

Configure/compile issues on Solaris SPARC
by Lou Picciano 11 Aug '10

11 Aug '10

Hello Listers! A question about building libzdb - against latest betas of PostgreSQL and MySQL... FWIW, PostgreSQL is by far our focus at the moment. We have been specifying the pg_config location with the --with-postgresql option. configure does find pg_config # ./configure \ LDFLAGS='-L/usr/local/postgres/9b4/lib/' \ --enable-optimized \ --enable-protected \ --enable-openssl=/usr/local/ssl \ --enable-sqliteunlock \ --with-mysql=/usr/local/mysql/bin/mysql_config \ --with-postgresql=/usr/local/postgres/9b4/bin/pg_config \ --with-sqlite=/usr/local (note: # /usr/local/postgres/9b4/bin/pg_config --version PostgreSQL 9.0beta4 # /usr/local/mysql/bin/mysql_config --version 5.0.51 # nm /usr/local/mysql/lib/mysql/libmysqlclient.so | grep mysql_init 000300f0 T mysql_init ) Some pertinent output from configure: ... checking for /usr/local/mysql/bin/mysql_config... yes checking mysql.h usability... yes checking mysql.h presence... yes checking for mysql.h... yes checking for mysql_init in -lmysqlclient... yes fail, >= 4.1 required checking for postgresql... yes checking for /usr/local/postgres/9b4/bin/pg_config... yes checking libpq-fe.h usability... yes checking libpq-fe.h presence... yes checking for libpq-fe.h... yes ... +------------------------------------------------------------+ | License: | | This is Open Source Software and use is subject to the GNU | | GENERAL PUBLIC LICENSE, available in this distribution in | | the file COPYING. | | | | By continuing this installation process, you are bound by | | the terms of this license agreement. If you do not agree | | with the terms of this license, you must abort the | | installation process at this point. | +------------------------------------------------------------+ | The Zild Database Library is configured as follows: | | | | Optimized: ENABLED | | Protected: ENABLED | | Profiling: DISABLED | | Zild: DISABLED | | Sqlite3 unlock notification API: ENABLED | | Unit Tests Build: DISABLED | | Openssl: ENABLED | |------------------------------------------------------------| | SQLite3: ENABLED | | MySQL: DISABLED | | PostgreSQL: ENABLED | +------------------------------------------------------------+ Platform is sun4u - Solaris SPARC E450 Any Ideas? We're off to try fiddling with the configure script... thanks! Lou

2 1

libzdb compilation with G++ compiler
by neo reeves 02 Dec '09

02 Dec '09

Hi All, I would like to link the zdb library with the existing CPP source code. So when I tried to compile the zdb library code with GNU cpp compiler, its not able to compile. Can anybody please let me know how to link or compile the zdb library with the CPP source code. Thanks in advance,- Neo The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

1 0

[Announce] libzdb 2.6
by Jan-Henrik Haukeland 03 Jul '09

03 Jul '09

Version 2.6 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.6.tar.gz MD5 checksum: 54eef941f130768d2d0a311873550e25 libzdb-2.6.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: * Linux 2.6 (x86 and x64) * Mac OS X Leopard (Darwin 10.5.x x86/ppc) * FreeBSD 6.x and 7.x (x86 and x64) * Solaris 10 and Solaris Express (sparc/x86) * OpenBSD 4.x (x64) Release notes: -------------- 1) This release greatly improves upon SQLite concurrency. We have tested libzdb with SQLite using up to 300 concurrent threads without experiencing lock problems. To achieve this, we use the experimental SQLite unlock notification API. To enable this API you need to first build and configure SQLite (version > 3.6.12) with the SQLITE_ENABLE_UNLOCK_NOTIFY preprocessor symbol like so: CFLAGS="$CFLAGS -DSQLITE_ENABLE_UNLOCK_NOTIFY" ./configure ... Then you need to enable this API in libzdb using the --enable- sqliteunlock configure switch when configuring and building libzdb. 2) For those using libzdb with the excellent DBMail (http://www.dbmail.org/ ) project it is strongly recommended to upgrade. This version of libzdb is tested by the DBMail project and should work with the latest DBMail release. Changes in this release: ------------------------ * Internal optimizing changes and improvements * Enable shared cache mode for SQLite >= 3.5 * Added new configure option --enable-sqliteunlock which enables SQLite unlock notification. This feature requires SQLite >= 3.6.12 compiled with the SQLITE_ENABLE_UNLOCK_NOTIFY C-preprocessor symbol. This option greately improves upon SQLite concurrency when libzdb and SQLite is used from a multi-threaded program. * Removed deprecated ResultSet_readData() from API Bug fixes: * PostgreSQL: Unescape values retrieved via ResultSet_getBlob() and via ResultSet_getBlobByName(). By an incurie, unescape was left out of libzdb version 2.5.

1 0

error in the configure script
by Gustavo Baratto 15 Apr '09

15 Apr '09

Hello there... I got this error in the configure script on 2.5: # ./configure --prefix=/opt/libzdb-2.5 --with-mysql=/opt/mysql/bin/mysql_config --without-postgresql --without-sqlite --enable-protected --enable-optimized checking for a BSD-compatible install... /usr/bin/ginstall -c checking whether build environment is sane... yes checking for a thread-safe mkdir -p... config/install-sh -c -d checking for gawk... gawk checking whether make sets $(MAKE)... yes checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking for style of include used by make... GNU checking dependency style of gcc... none checking how to run the C preprocessor... gcc -E checking for grep that handles long lines and -e... /usr/bin/ggrep checking for egrep... /usr/bin/ggrep -E checking whether gcc needs -traditional... no checking for re2c... no checking for flex... /usr/bin/flex checking build system type... i386-pc-solaris2.11 checking host system type... i386-pc-solaris2.11 checking for a sed that does not truncate output... /usr/bin/gsed checking for ld used by gcc... /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking for /usr/ccs/bin/ld option to reload object files... -r checking for BSD-compatible nm... /usr/bin/nm -p checking whether ln -s works... yes checking how to recognize dependent libraries... pass_all checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking dlfcn.h usability... yes checking dlfcn.h presence... yes checking for dlfcn.h... yes checking for g++... g++ checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking dependency style of g++... none checking how to run the C++ preprocessor... g++ -E checking for g77... g77 checking whether we are using the GNU Fortran 77 compiler... yes checking whether g77 accepts -g... yes checking the maximum length of command line arguments... 786240 checking command to parse /usr/bin/nm -p output from gcc object... ok checking for objdir... .libs checking for ar... ar checking for ranlib... ranlib checking for strip... strip checking if gcc supports -fno-rtti -fno-exceptions... no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc static flag -static works... no checking if gcc supports -c -o file.o... yes checking whether the gcc linker (/usr/ccs/bin/ld) supports shared libraries... yes checking whether -lc should be explicitly linked in... yes checking dynamic linker characteristics... solaris2.11 ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... no checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes configure: creating libtool appending configuration tag "CXX" to libtool checking for ld used by g++... /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking whether the g++ linker (/usr/ccs/bin/ld) supports shared libraries... yes checking for g++ option to produce PIC... -fPIC checking if g++ PIC flag -fPIC works... yes checking if g++ static flag -static works... no checking if g++ supports -c -o file.o... yes checking whether the g++ linker (/usr/ccs/bin/ld) supports shared libraries... yes checking dynamic linker characteristics... solaris2.11 ld.so checking how to hardcode library paths into programs... immediate appending configuration tag "F77" to libtool checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for g77 option to produce PIC... -fPIC checking if g77 PIC flag -fPIC works... yes checking if g77 static flag -static works... no checking if g77 supports -c -o file.o... yes checking whether the g77 linker (/usr/ccs/bin/ld) supports shared libraries... yes checking dynamic linker characteristics... solaris2.11 ld.so checking how to hardcode library paths into programs... immediate checking for pthread_create in -lpthread... yes checking for library containing crypt... none required checking for mysql... yes checking for /opt/mysql/bin/mysql_config... yes checking mysql.h usability... yes checking mysql.h presence... yes checking for mysql.h... yes checking for mysql_init in -lmysqlclient... yes fail, >= 4.1 required checking for postgresql... no checking for SQLite3... no configure: error: No available database found or selected. Try configure --help I created this patch, and now I don't get the error anymore: # diff -bu configure configure.new --- configure Tue Apr 14 21:59:50 2009 +++ configure.new Tue Apr 14 21:59:22 2009 @@ -20331,7 +20331,7 @@ sed 's/^/| /' conftest.$ac_ext >&5 ( exit $ac_status ) -mysql="no" +mysql="yes" fi rm -f core *.core core.conftest.* gmon.out bb.out conftest$ac_exeext conftest.$ac_objext conftest.$ac_ext fi -- g.

2 2

[Announce] libzdb 2.5
by Jan-Henrik Haukeland 05 Apr '09

05 Apr '09

Version 2.5 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.5.tar.gz MD5 checksum: cf9406ce6505e6265a07ada4990b6526 libzdb-2.5.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a minor feature and bug fix release which has been tested on the following platforms: Darwin 9.6.0 [x86] Linux FC/U [x86/x64] FreeBSD 6/7 [x86/x64] Changes in this release: * PostgreSQL: Blob retrieval optimized * PostgreSQL: Added unix-socket parameter to connection URL * Removed GPL license exceptions. The library is now licensed under the GPL version 3 only. * Deprecated ResultSet_readData(). This function _is_ useful for MySQL, but not for other drivers where it has some overhead. * Added GCC __attribute__ printf checks where applicable * Internal optimizing changes and improvements We expect this release to be stable for some time. Just a FYI if you plan to package this release.

1 1

Is 2.5 PPC Mac OS X Compatible?
by Mike McGonagle 05 Apr '09

05 Apr '09

Hello, I was going through the 2.5 version hoping to install this on my Mac, and test some stuff out. But it appears from the annoucement email, that it only supports Intel Mac, is this true? or is there a ./configure option that would allow PPC compilation? Thanks, Mike

2 4

Packaging for Fedora
by Bernard Johnson 02 Mar '09

02 Mar '09

Hello, I was trying to package libzdb for inclusion in Fedora. One concern that came up was the sonames generated with the version of libzdb as part of the soname. https://bugzilla.redhat.com/show_bug.cgi?id=474044#c4 Have you considered generating your sonames to reflect the ABI version of the package rather than tying it to the package version?

2 6

unix sockets
by Paul J Stevens 02 Mar '09

02 Mar '09

Jan-Henrik, Is there a mechanism for connecting to postgresql through a unix socket? I see there is a 'unix-socket' query option for mysql, but what about pgsql? thanks, -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 3

[Announce] libzdb 2.4
by Jan-Henrik Haukeland 16 Feb '09

16 Feb '09

Version 2.4 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.4.tar.gz MD5 checksum: b4c4ba0090881d4714f7f3e56d6eadbd libzdb-2.4.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a minor feature and bug fix release which has been tested on the following platforms: Darwin 9.6.0 [x86] Linux FC/U [x86/x64] FreeBSD [x86] Changes in this release: * The configure options --with_mysql=<path> and --with_postgresql=<path> has a new meaning. If <path> is given it is assumed to be the full path to respectively mysql_config and to pg_config. Example: ./configure --with_mysql=/usr/local/mysql/bin/mysql_config ./configure --with_postgresql=/usr/local/pgsql/bin/pg_config * From version 2.4, libzdb places its header files into a zdb sub-directory as in, <prefix>/include/zdb. Clients must now use the include-dir compiler flag, -I<prefix>/include/zdb. * Internal optimizing changes and improvements * Changed prototypes of type 'extern void foo()' to 'extern void foo(void)' so the library compiles without warning if -Wstrict-prototype is used with gcc. Thanks to Paul Stevens Bug fixes: * Fixed off-by-one bug in Vector_remove * PostgreSQL: Fixed PostgresqlResultSet_getColumnSize to report correct value. * PostgreSQL: Improved error reporting and fixed potential allocation bugs in prepared statements. * PostgreSQL: Calling PreparedStatement_setString with a NULL value now works

1 0

error in the configure script (No available database found or selected)
by Gustavo Baratto 20 Jan '09

20 Jan '09

Hello there... I'm getting a weird error saying no database was selected, even though the configure script seem to find mysql This is the full output of the configure script: opensolaris:~/src/libzdb-2.3# ./configure --prefix=/opt/libzdb-2.3 --with-mysql=/opt/mysql/ --without-postgresql --without-sqlite --enable-protected checking for a BSD-compatible install... /usr/bin/ginstall -c checking whether build environment is sane... yes checking for a thread-safe mkdir -p... config/install-sh -c -d checking for gawk... gawk checking whether make sets $(MAKE)... yes checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking for style of include used by make... GNU checking dependency style of gcc... none checking how to run the C preprocessor... gcc -E checking for grep that handles long lines and -e... /usr/bin/ggrep checking for egrep... /usr/bin/ggrep -E checking whether gcc needs -traditional... no checking for re2c... no checking for flex... /usr/bin/flex checking build system type... i386-pc-solaris2.11 checking host system type... i386-pc-solaris2.11 checking for a sed that does not truncate output... /usr/bin/gsed checking for ld used by gcc... /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking for /usr/ccs/bin/ld option to reload object files... -r checking for BSD-compatible nm... /usr/bin/nm -p checking whether ln -s works... yes checking how to recognize dependent libraries... pass_all checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking dlfcn.h usability... yes checking dlfcn.h presence... yes checking for dlfcn.h... yes checking for g++... g++ checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking dependency style of g++... none checking how to run the C++ preprocessor... g++ -E checking for g77... g77 checking whether we are using the GNU Fortran 77 compiler... yes checking whether g77 accepts -g... yes checking the maximum length of command line arguments... 786240 checking command to parse /usr/bin/nm -p output from gcc object... ok checking for objdir... .libs checking for ar... ar checking for ranlib... ranlib checking for strip... strip checking if gcc supports -fno-rtti -fno-exceptions... no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc static flag -static works... no checking if gcc supports -c -o file.o... yes checking whether the gcc linker (/usr/ccs/bin/ld) supports shared libraries... yes checking whether -lc should be explicitly linked in... yes checking dynamic linker characteristics... solaris2.11 ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... no checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes configure: creating libtool appending configuration tag "CXX" to libtool checking for ld used by g++... /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking whether the g++ linker (/usr/ccs/bin/ld) supports shared libraries... yes checking for g++ option to produce PIC... -fPIC checking if g++ PIC flag -fPIC works... yes checking if g++ static flag -static works... no checking if g++ supports -c -o file.o... yes checking whether the g++ linker (/usr/ccs/bin/ld) supports shared libraries... yes checking dynamic linker characteristics... solaris2.11 ld.so checking how to hardcode library paths into programs... immediate appending configuration tag "F77" to libtool checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for g77 option to produce PIC... -fPIC checking if g77 PIC flag -fPIC works... yes checking if g77 static flag -static works... no checking if g77 supports -c -o file.o... yes checking whether the g77 linker (/usr/ccs/bin/ld) supports shared libraries... yes checking dynamic linker characteristics... solaris2.11 ld.so checking how to hardcode library paths into programs... immediate checking for pthread_create in -lpthread... yes checking for mysql... checking mysql.h usability... yes checking mysql.h presence... yes checking for mysql.h... yes checking for postgresql... no checking for SQLite3... sqlite=no configure: error: No available database found or selected. Try configure --help Thanks for any help

2 7

[Announce] libzdb 2.3
by Jan-Henrik Haukeland 05 Dec '08

05 Dec '08

Version 2.3 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.3.tar.gz MD5 checksum: 62e16369e268e9280978d36343207e60 libzdb-2.3.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 9.5.0 [ppc/x86] Linux FC/U [x86/x64] FreeBSD [x86] Note, a few function signatures in public interfaces has been changed. Functions that can throw an exception on error, now just returns void. This is done to be consistent wrt error handling via exceptions. This means that existing client code may require modest refactoring if return values are checked. In addition, internal improvements has been done here and there. Changes in this release: Version 2.3 ----------- * Cleaned up API and changed function return type to void for those functions that can throw exception on error. * Support variable arguments in Connection_prepareStatement() to make it easy to build prepared statements in-place

1 0

support for other databases
by Uwe Kiewel 04 Dec '08

04 Dec '08

Hi, do you plan to implement support for other databases? An interface to sqlrelay and/or DB2 would be fine. Kind regards, Uwe

2 1

[Announce] libzdb 2.2.3
by Jan-Henrik Haukeland 30 Jul '08

30 Jul '08

Version 2.2.3 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.2.3.tar.gz MD5 checksum: a2a79dfbafa10a20d2cf0edfb5d5795e libzdb-2.2.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 9.4.0 [ppc/x86] Linux FC/U [x86/x64] FreeBSD [x86] Note, this release should fix problems with SQLite database locks. As you probably know, SQLite locks the database file on certain operations. This is a problem when two or more connections tries to update the SQLite database at the same time, since only one connection will succeed. There are ways around this problem and the strategy we use in libzdb is to retry the statement whenever a database lock is encountered. Unfortunately the retry code had a bug which prevented it to run more than one time. This is now fixed and libzdb will handle concurrent usage of SQLite much better. Changes in this release: Version 2.2.3 ------------- Bug fixes: * Make sure connection properties, max rows and query timeout are reset on Connection_close(), if changed. * Ensure that timeout is set for new Connections and fixed a bug in the SQLite retry macro so the SQLite driver now will retry executing on database lock

1 0

[Announce] libzdb 2.2.2
by Jan-Henrik Haukeland 08 Jun '08

08 Jun '08

Version 2.2.2 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.2.2.tar.gz MD5 checksum: 756e148181b8f108a8a586dbd0a25b0c libzdb-2.2.2.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a non-critical minor bug fix release which has been tested on the following platforms: Darwin 9.3.0 [ppc/x86] Linux FC/U [x86/x64] FreeBSD [x86] Changes in this release: Version 2.2.2 ------------- * Ensure that reaper progress forward and remove all connections it can * Fixed a va_copy bug on 64 bits systems

1 0

[Announce] libzdb 2.2.1
by Jan-Henrik Haukeland 04 May '08

04 May '08

Version 2.2.1 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.2.1.tar.gz MD5 checksum: 20c6bceae77f9e358e19b3ca4283afa1 libzdb-2.2.1.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 9.2.2 [ppc/x86] Linux FC/U [x86] Changes in this release: Version 2.2.1 ------------- * SQLite: Improved error reporting by using sqlite3_prepare_v2() when available. Thanks to Paul Stevens for suggesting this. Bug fixes: * MySQL and PostgreSQL: Fixed off-by-one count when verifying validity of parameter and column index. Thanks to Paul Stevens for bug report. * MySQL: Workaround mysql column truncation bug. Thanks to Paul Stevens for bug report.

1 0

Connection_lastRowId on postgresql
by Paul J Stevens 03 May '08

03 May '08

Jan-Henrik, This call always returns 0 on a postgresql connection. I assume this is because my tables are without OIDs. Is that intentional? I can work around it. But perhaps a small note in the api docs would be in order? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 15

ensureCapacity
by Paul J Stevens 03 May '08

03 May '08

Jan-Henrik, Found some time today to do more testing on a problem I was still having with the mysql driver (the postgres driver is kicking ass). I suspect there is still a problem in ensureCapacity (or it's consumers). I'm attaching a small program that will reliably reproduce this. Looks like strings from the /first/ row (and only the first row) retrieved from a resultset are still being truncated at 256 char length. tested against yesterdays svn-rev. thanks, -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 3

more segfaults (sqlite this time)
by Paul J Stevens 25 Apr '08

25 Apr '08

Dont shoot the messenger plz :-) running some tests using sqlite I'm getting what appears to be stack corruption: (gdb) bt #0 0xffffe410 in __kernel_vsyscall () #1 0xb78cbf75 in raise () from /lib/tls/i686/cmov/libc.so.6 #2 0xb78cd8f1 in abort () from /lib/tls/i686/cmov/libc.so.6 #3 0xb7d01b95 in Util_abort (e=0xb7d102a0 "MemoryException -- %s at %s in line %d\n") at src/util/Util.c:83 #4 0xb7d023d2 in Mem_resize (p=0x5316e008, size=1665138688, file=0xb7d214c0 "src/util/StringBuffer.c", line=61) at src/util/Mem.c:76 #5 0xb7d07c29 in StringBuffer_vappend (S=0x8115438, s=0x81008c0 "UPDATE OR IGNORE dbmail_mailboxes SET mtime=STRFTIME('%Y-%m-%d %H:%M:%S','now','localtime') WHERE mailbox_idnr=2", ap=0xbfe38778 "{z\t\b��\t\b�") at src/util/StringBuffer.c:61 #6 0xb7d0e88f in SQLiteConnection_execute (C=0x8115de8, sql=0x81008c0 "UPDATE OR IGNORE dbmail_mailboxes SET mtime=STRFTIME('%Y-%m-%d %H:%M:%S','now','localtime') WHERE mailbox_idnr=2", ap=0xbfe38778 "{z\t\b��\t\b�") at src/db/sqlite/SQLiteConnection.c:174 any ideas? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 7

segfaults in ResultSet_free
by Paul J Stevens 07 Apr '08

07 Apr '08

Jan-Henrik, I've started using threads in my application and now the mysql driver starts to segfault: Starting program: /home/paul/git/dbmail/src/dbmail-imapd -D [Thread debugging using libthread_db enabled] [New process 27692] [New Thread -1217631440 (LWP 27692)] [New Thread -1218696304 (LWP 27694)] [Thread -1218696304 (LWP 27694) exited] Program received signal SIGSEGV, Segmentation fault. [Switching to Thread -1217631440 (LWP 27692)] 0xb7d80175 in ResultSet_free (R=0x81526e4) at src/db/ResultSet.c:65 65 (*R)->op->free(&(*R)->I); this only happens when I use the mysql driver. The postgres driver has exhibited some infrequent crashes but those have been very difficult to reproduce. My guess is it has to do with the query involved: INSERT IGNORE INTO dbmail_headername (headername) VALUES (?) a construct not used for postgres. Perhaps this type of query affects the kind of MYSQL_RES returned. I'm not sure. I'll try to investigate myself. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 3

[Announce] libzdb 2.2
by Jan-Henrik Haukeland 28 Mar '08

28 Mar '08

Version 2.2 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.2.tar.gz MD5 checksum: 3a1677704ce3821c53d6d0ae7b98dbb5 libzdb-2.2.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/U [x86] Changes in this release: Version 2.2 ----------- * Detailed error message added to exception. In an exception handler, the variable Exception_frame.message, now provides an alternative to Connection_getLastError() for obtaining the latest error message * From this release, building with exceptions handling is no longer optional but required * Internal optimizing changes Bug fixes: * Fixed Connection_prepareStatement() error reported on a PostgreSQL Connection. Thanks to Paul Stevens for bug report. * MySQL: Fixed error in ResultSet_getBlob() and ResultSet_getString() which lead to a segfault when trying to obtain "large" strings and blobs. Again thanks to Paul Stevens. * PostgreSQL: Fixed the "syntax error at character 12" for prepared statemen deallocation. Thanks to Paul Stevens for bug report.

1 0

errors during Connection_clear/Connection_close
by Paul J Stevens 27 Mar '08

27 Mar '08

Hi there, me again :-) Whenever I close a connection that holds a prepared statement, the postgres backend logs an error like this: 2008-03-20 09:49:54 CET LOG: execute 1804289383: select user_idnr from dbmail_users where userid=$1 2008-03-20 09:49:54 CET DETAIL: parameters: $1 = 'testuser1' 2008-03-20 09:49:54 CET ERROR: syntax error at or near "1804289383" at character 12 2008-03-20 09:49:54 CET STATEMENT: DEALLOCATE 1804289383; it's *always* at character 12, where of course the stmt ID varies. It only occurs when I close the connection, I assume because that triggers a Connection_clear, which releases the statements. This doesn't appear to affect functionality, but it doesn't exactly inspire confidence either, I suppose. Any ideas? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 1

segfaults in mysql driver
by Paul J Stevens 22 Mar '08

22 Mar '08

Jan-Henrik, I'm running into some problems with the mysql backend. I can't seem to retrieve long-ish strings. The attached code will reliably segfault on my systems. This code does *not* fail on Postgresql. Am I doing something wrong? thanks, -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

3 12

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

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

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

libzdb-general