- libzdb-general - tildeslash.com

Fwd: Can't install
by Javier Olivares Sierras 25 Oct '13

25 Oct '13

Hi, I have installed libzdb without problems before, but now I'm trying to do the same and I always get the same error message. I tried to install mysql-server both from apt-get and using the generic binaries. I have installed the mysql-client too, using "apt-get install mysql-client". The command I use to try to configure your library is this: root@ubuntu:/usr/local/libzdb-2.12# ./configure --without-postgresql --without-sqlite --with-mysql=/usr/local/mysql/bin/mysql_config checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking for a thread-safe mkdir -p... /bin/mkdir -p checking for gawk... no checking for mawk... mawk checking whether make sets $(MAKE)... yes checking whether make supports nested variables... yes checking for gcc... gcc checking whether the C compiler works... yes checking for C compiler default output file name... a.out checking for suffix of executables... checking whether we are cross compiling... no 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 whether gcc understands -c and -o together... yes 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... /bin/grep checking for egrep... /bin/grep -E checking whether gcc needs -traditional... no checking for re2c... re2c_not_found checking for flex... flex checking lex output file root... lex.yy checking lex library... -lfl checking whether yytext is a pointer... yes checking build system type... x86_64-unknown-linux-gnu checking host system type... x86_64-unknown-linux-gnu checking how to print strings... printf checking for a sed that does not truncate output... /bin/sed checking for fgrep... /bin/grep -F checking for ld used by gcc... /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... yes checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm -B checking the name lister (/usr/bin/nm -B) interface... BSD nm checking whether ln -s works... yes checking the maximum length of command line arguments... 1572864 checking whether the shell understands some XSI constructs... yes checking whether the shell understands "+="... yes checking how to convert x86_64-unknown-linux-gnu file names to x86_64-unknown-linux-gnu format... func_convert_file_noop checking how to convert x86_64-unknown-linux-gnu file names to toolchain format... func_convert_file_noop checking for /usr/bin/ld option to reload object files... -r checking for objdump... objdump checking how to recognize dependent libraries... pass_all checking for dlltool... no checking how to associate runtime and link libraries... printf %s\n checking for ar... ar checking for archiver @FILE support... @ checking for strip... strip checking for ranlib... ranlib checking command to parse /usr/bin/nm -B output from gcc object... ok checking for sysroot... no checking for mt... mt checking if mt is a manifest tool... no 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 for dlfcn.h... yes checking for objdir... .libs checking if gcc supports -fno-rtti -fno-exceptions... no checking for gcc option to produce PIC... -fPIC -DPIC checking if gcc PIC flag -fPIC -DPIC works... yes checking if gcc static flag -static works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.o... (cached) yes checking whether the gcc linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes checking whether -lc should be explicitly linked in... no checking dynamic linker characteristics... GNU/Linux ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for library containing pthread_create... -lpthread checking for library containing crypt... -lcrypt checking for library containing dlopen... -ldl checking for mysql... yes 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... no checking for postgresql... no checking for SQLite3... no checking for oracle... checking if Oracle support is enabled... no configure: error: No available database found or selected. Try configure --help I though the problem was because the line "checking for mysql_init in -lmysqlclient... no", but I have checked several times the client library, and all seems to be ok (of course, It's not). I'll appreciate any clue you can offer. Thank you!, Javier

4 4

configure error:
by Steve Benton 02 Oct '13

02 Oct '13

Hello, I have downloaded and am trying to build libzdb 2.12 on an ubuntu 12.04 64bit system. When I run configure command line: ./configure --without-postgresql --without-sqlite I receive the following error: checking for mysql... yes checking for mysql_config... /usr/bin/mysql_config checking mysql.h usability... yes checking mysql.h presence... yes checking for mysql.h... yes *checking for mysql_init in -lmysqlclient... no* Dump from running mysql_config sage: /usr/bin/mysql_config [OPTIONS] Options: --cflags [-I/usr/include/mysql -DBIG_JOINS=1 -fno-strict-aliasing -g] --include [-I/usr/include/mysql] --libs [-L/usr/lib/x86_64-linux-gnu -lmysqlclient -lpthread -lz -lm -lrt -ldl] --libs_r [-L/usr/lib/x86_64-linux-gnu -lmysqlclient_r -lpthread -lz -lm -lrt -ldl] --plugindir [/usr/lib/mysql/plugin] --socket [/var/run/mysqld/mysqld.sock] --port [0] --version [5.5.32] --libmysqld-libs [-L/usr/lib/x86_64-linux-gnu -lmysqld -lpthread -lz -lm -lrt -lwrap -lcrypt -ldl] --variable=VAR VAR is one of: pkgincludedir [/usr/include/mysql] pkglibdir [/usr/lib/x86_64-linux-gnu] plugindir [/usr/lib/mysql/plugin] I have installed mysql_server, mysql_client, and libmysqlclient-dev. I have removed these packages and then re-installed and still get the same configure error. Any ideas why this is happening?

3 6

leak possible in try/catch/finally pattern?
by Paul J Stevens 09 Sep '13

09 Sep '13

Jan-Henrik, I'm getting reports of small leakage when I follow this pattern: c = ConnectionPool_getConnection(pool); TRY // prepare and bind and execute statement, or // run or execute a query, with or without transactions CATCH(SQLException) // log exception // set volatile boolean result flag FINALLY Connection_close(c); END_TRY; The try/accept block varies; but in all cases the connection leaks. I'm attaching a stripped valgrind log which was posted to my bug-tracker. So I wonder, is there something in the try...finally...end_try block I need to modify to prevent this? -- ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin * Premium Hosting Services and Web Application Consultancy * www.nfg.nl/info@nfg.nl/+31.85.877.99.97 ________________________________________________________________

2 3

[Announce] libzdb 2.12
by Jan-Henrik Haukeland 03 Sep '13

03 Sep '13

Version 2.12 of libzdb is now available: Download: http://tildeslash.com/libzdb/dist/libzdb-2.12.tar.gz MD5 checksum: dd95114cae471d1b5dfda1f263b222c1 Changes in this release: ------------------------ New: PreparedStatement_rowsChanged added to PreparedStatement.h Fixes: Oracle: OCIPing is used to check Oracle connections and to ensure that the Pool returns connected connections. Thanks to Pavlo Lavrenenko.

1 0

Re: [Dbmail] [Maria-discuss] Fwd: MariaDB and dbmail
by Paul J Stevens 02 Sep '13

02 Sep '13

On 09/02/2013 01:02 AM, Reindl Harald wrote: > so something goes wrong in combination with libzdb > IMHO this *must not* happen if MariaDB claims to be a drop-in-replacemnet I've done some additional investigation, and indeed MariaDB appears to mess up the server cursor when a blob is in the result. I'm attaching a test-case and with a schema and data for you to use. 10.0.4-MariaDB-1~precise-log libzdb-2.11.2 libzdb uses mysql_stmt_fetch to move the server cursor forward. This has worked flawlessly until now for MySQL, SQLite, PostgreSQL and Oracle. With MariaDB we seem to hit a problem as soon as a blob column is in the columns. https://github.com/tildeslash/libzdb/blob/master/src/db/mysql/MysqlResultSe… Just try the test program with and without the 'p.data' column, and run it. Since part_order is the primary ordering key, I use that to test for result integrity. -- ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin * Premium Hosting Services and Web Application Consultancy * www.nfg.nl/info@nfg.nl/+31.85.877.99.97 ________________________________________________________________

1 0

libzdb in debian
by Paul J Stevens 10 Aug '13

10 Aug '13

Jan-Henrik, FYI, good news! libzdb has landed in debian/unstable. Thanks to Jack Bates for pushing this. http://packages.qa.debian.org/libz/libzdb.html -- ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin * Premium Hosting Services and Web Application Consultancy * www.nfg.nl/info@nfg.nl/+31.85.877.99.97 ________________________________________________________________

1 0

affected rows from PreparedStatement_execute?
by Paul J Stevens 04 Aug '13

04 Aug '13

Jan-Henrik, Is the a way to obtain the number of affected rows after executing a prepared statement, like there is for Connection_execute? -- ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin * Premium Hosting Services and Web Application Consultancy * www.nfg.nl/info@nfg.nl/+31.85.877.99.97 ________________________________________________________________

2 3

how to use ResultSet_Next()
by 马佳佳 10 Jul '13

10 Jul '13

hello! what we want to do is to insert table curenttimestamp (2013-01-01 12:00:00:111),and we can get the time from the table .we use oracle 11gr2. redhat I have two questions in using libzdb. i. while i debug my app ,the ResultSet_Next()返回false,i donot know why ii.how to get the time from table my code is just like : ResultSet_T r = Connection_executeQuery(con, "select TIME from bleach");//the bleach consist of only time,and time is timestamp while (ResultSet_next(r)) { printf("%s\n", ResultSet_getString(r, 1)); } Thanks everymuch! jiajiama

1 0

re: libzdb-general Digest, Vol 43, Issue 8
by 马佳佳 27 Jun '13

27 Jun '13

Thank you very much !I Have solute my question as you told! -----邮件原件----- 发件人: libzdb-general-bounces(a)tildeslash.com [mailto:libzdb-general-bounces@tildeslash.com] 代表 libzdb-general-request(a)tildeslash.com 发送时间: 2013年6月26日 18:00 收件人: libzdb-general(a)tildeslash.com 主题: libzdb-general Digest, Vol 43, Issue 8 Send libzdb-general mailing list submissions to libzdb-general(a)tildeslash.com To subscribe or unsubscribe via the World Wide Web, visit http://www.tildeslash.com/mailman/listinfo/libzdb-general or, via email, send a message with subject or body 'help' to libzdb-general-request(a)tildeslash.com You can reach the person managing the list at libzdb-general-owner(a)tildeslash.com When replying, please edit your Subject line so it is more specific than "Re: Contents of libzdb-general digest..." Today's Topics: 1. ??: libzdb-general Digest, Vol 43, Issue 7 (???) 2. Re: ??: libzdb-general Digest, Vol 43, Issue 7 (Paul J Stevens) ---------------------------------------------------------------------- Message: 1 Date: Wed, 26 Jun 2013 14:51:15 +0800 From: ??? <hnxymjj(a)163.com> To: <libzdb-general(a)tildeslash.com> Subject: ??: libzdb-general Digest, Vol 43, Issue 7 Message-ID: <000001ce7239$8ef423b0$acdc6b10$@com> Content-Type: text/plain; charset="gb2312" Hello! Thank you very much for your help! The question I am contacting to him. However now I have another question: Now I am doing a project ,use qt and libzdb,but I donnot know how to use libzdb in the multi-thread environment . as I find the most time is the connectpool_start() ,and at the end of the thread I must call url_free() and connectpool_free .Is is right? I hope someone who can help me! Thx jiajiama -----????----- ???: libzdb-general-bounces(a)tildeslash.com [mailto:libzdb-general-bounces@tildeslash.com] ?? libzdb-general-request(a)tildeslash.com ????: 2013?6?25? 18:00 ???: libzdb-general(a)tildeslash.com ??: libzdb-general Digest, Vol 43, Issue 7 Send libzdb-general mailing list submissions to libzdb-general(a)tildeslash.com To subscribe or unsubscribe via the World Wide Web, visit http://www.tildeslash.com/mailman/listinfo/libzdb-general or, via email, send a message with subject or body 'help' to libzdb-general-request(a)tildeslash.com You can reach the person managing the list at libzdb-general-owner(a)tildeslash.com When replying, please edit your Subject line so it is more specific than "Re: Contents of libzdb-general digest..." Today's Topics: 1. Re: how to use libzdb in windows (Jan-Henrik Haukeland) ---------------------------------------------------------------------- Message: 1 Date: Mon, 24 Jun 2013 22:23:01 +0200 From: Jan-Henrik Haukeland <hauk(a)tildeslash.com> To: This is the libzdb general mailing list <libzdb-general(a)tildeslash.com> Subject: Re: how to use libzdb in windows Message-ID: <0D9D9A0D-FB18-4A60-961F-2426BCF275CC(a)tildeslash.com> Content-Type: text/plain; charset=GB2312 On Jun 24, 2013, at 6:44 AM, ??? <hnxymjj(a)163.com> wrote: > how can I compile the libzdb on windows and how can I use it! Can > you give me an example? Libzdb does not support Windows. However I see someone has done some "work" to port libzdb to Windows using MinGW, https://github.com/haiwen/libzdb. Maybe ask them? ------------------------------ _______________________________________________ libzdb-general mailing list libzdb-general(a)tildeslash.com http://www.tildeslash.com/mailman/listinfo/libzdb-general End of libzdb-general Digest, Vol 43, Issue 7 ********************************************* ------------------------------ Message: 2 Date: Wed, 26 Jun 2013 10:04:46 +0200 From: Paul J Stevens <paul(a)nfg.nl> To: This is the libzdb general mailing list <libzdb-general(a)tildeslash.com> Subject: Re: ??: libzdb-general Digest, Vol 43, Issue 7 Message-ID: <51CAA09E.2050009(a)nfg.nl> Content-Type: text/plain; charset=UTF-8 On 26-06-13 08:51, ??? wrote: > Now I am doing a project ,use qt and libzdb,but I donnot know how > to use libzdb in the multi-thread environment . as I find the most > time is the > connectpool_start() ,and at the end of the thread I must call > url_free() and connectpool_free .Is is right? I hope someone who can help me! I use libzdb in a multi-threaded setup. Creating and cleaning up the connection pool is done in the main thread, so the pool is shared between all threads. Worker threads only need to do: ConnectionPool_getConnection(pool) use the connection and do Connection_close(connection); once they are done with it so it can return to the pool No need to worry about locking since that is libzdb's job. Starting a separate pool for each thread invalidates the use of a connection-pool. -- ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin * Premium Hosting Services and Web Application Consultancy * www.nfg.nl/info@nfg.nl/+31.85.877.99.97 ________________________________________________________________ ------------------------------ _______________________________________________ libzdb-general mailing list libzdb-general(a)tildeslash.com http://www.tildeslash.com/mailman/listinfo/libzdb-general End of libzdb-general Digest, Vol 43, Issue 8 *********************************************

1 0

答复: libzdb-general Digest, Vol 43, Issue 7
by 马佳佳 26 Jun '13

26 Jun '13

Hello! Thank you very much for your help! The question I am contacting to him. However now I have another question: Now I am doing a project ,use qt and libzdb,but I donnot know how to use libzdb in the multi-thread environment . as I find the most time is the connectpool_start() ,and at the end of the thread I must call url_free() and connectpool_free .Is is right? I hope someone who can help me! Thx jiajiama -----邮件原件----- 发件人: libzdb-general-bounces(a)tildeslash.com [mailto:libzdb-general-bounces@tildeslash.com] 代表 libzdb-general-request(a)tildeslash.com 发送时间: 2013年6月25日 18:00 收件人: libzdb-general(a)tildeslash.com 主题: libzdb-general Digest, Vol 43, Issue 7 Send libzdb-general mailing list submissions to libzdb-general(a)tildeslash.com To subscribe or unsubscribe via the World Wide Web, visit http://www.tildeslash.com/mailman/listinfo/libzdb-general or, via email, send a message with subject or body 'help' to libzdb-general-request(a)tildeslash.com You can reach the person managing the list at libzdb-general-owner(a)tildeslash.com When replying, please edit your Subject line so it is more specific than "Re: Contents of libzdb-general digest..." Today's Topics: 1. Re: how to use libzdb in windows (Jan-Henrik Haukeland) ---------------------------------------------------------------------- Message: 1 Date: Mon, 24 Jun 2013 22:23:01 +0200 From: Jan-Henrik Haukeland <hauk(a)tildeslash.com> To: This is the libzdb general mailing list <libzdb-general(a)tildeslash.com> Subject: Re: how to use libzdb in windows Message-ID: <0D9D9A0D-FB18-4A60-961F-2426BCF275CC(a)tildeslash.com> Content-Type: text/plain; charset=GB2312 On Jun 24, 2013, at 6:44 AM, ??? <hnxymjj(a)163.com> wrote: > how can I compile the libzdb on windows and how can I use it! Can you give me an example? Libzdb does not support Windows. However I see someone has done some "work" to port libzdb to Windows using MinGW, https://github.com/haiwen/libzdb. Maybe ask them? ------------------------------ _______________________________________________ libzdb-general mailing list libzdb-general(a)tildeslash.com http://www.tildeslash.com/mailman/listinfo/libzdb-general End of libzdb-general Digest, Vol 43, Issue 7 *********************************************

2 1

how to use libzdb in windows
by 马佳佳 24 Jun '13

24 Jun '13

Hello! I have a question that how can I compile the libzdb on windows and how can I use it! Can you give me an example? THX jiajiama

2 1

about pool reconnect
by springrate 22 Jun '13

22 Jun '13

hi, i read source, maybe this is true? after the pool started, the conn in pool can be always healthy. in real word, conn can be disconnected. in this situation, client get a conn from pool, when using the conn, executing or querying can get a exception when conn is disconnected. how to process the exception? conn need a reconnection operator or free conn and new a connection. may be Connection need a status and reaper thread can check conn's status and try reconnect and keep enough connection when db service function recover.

2 1

User Data Object For Abort Handler
by Jacob M. H. Smith 15 Jun '13

15 Jun '13

Hello! As I understand it, the abort handler is the only way catch fatal errors in the library, like the inability to connect to the server or something similar. Its a simple C function pointer. The problem I have with this is that I use the library from within Objective-C classes and I want my objects to handle possible errors. I can't see a practical way to redirect the control flow back to my object in such a case. A lot of libraries that work with handler functions give you the opportunity to pass along with the function pointer a user data object that will be provided to the handler when invoked. It would be nice to see something similar for the abort handler because at the moment I am limited in how I can react to fatal errors in zdb. Best regards, Jacob

2 1

Debian package
by Jack Bates 03 Jun '13

03 Jun '13

Hello, I am interested in doing some work to get a package of Libzdb (such as the one here [1], prepared by Paul J Stevens) into Debian. Paul, you currently own the ITP [2] for a Libzdb package in Debian, would you like me to try to upload a package? Libzdb authors, if I try to get a Libzdb package into Debian, are you in favor of that? I run DBMail on Debian and I think there is interest in once again making it available from the Debian repositories, which is why I'm interested in doing some work to upload Libzdb. Thank you! [1] http://debian.nfgd.net/debian/dists/unstable/main/source/libs/libzdb_2.10.2… [2] http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=466699

1 0

[Announce] libzdb 2.11.2
by Jan-Henrik Haukeland 17 Apr '13

17 Apr '13

Version 2.11.2 of libzdb is now available: Download: http://tildeslash.com/libzdb/dist/libzdb-2.11.2.tar.gz MD5 checksum: f3ebd6c32c47be084643a44d34459499 Changes in this release: ------------------------ New: Throw SQLException if a database access error occurs when ResultSet_next() is called. Previously, access errors could be masked as end of result set. Thanks to JiaQiang Xu. Fixes: (Volodymyr Tarasenko) Possible mem leak in Oracle's blob operation fixed. Fixes: MySQL and SQLite detection on ubuntu 12.04

2 2

Re: libzdb memory leakage
by Pavlo Lavrenenko 11 Apr '13

11 Apr '13

On 04/10/2013 05:47 PM, Volodymyr Tarasenko wrote: > Hi Pavlo, > > Could you check my last commit? Jan is planning to release 2.11.2 > version, I would like to be sure that this fix is working for you... > > Good luck, > Volodymyr! > I've checked recent changes and everything works as expected. Thanks. -- Best regards, Pavlo Lavrenenko, PortaOne, Inc., Junior Software Developer Tel: +1-866-SIP VOIP (+1 866 747 8647) ext. 7624 PortaOne - VoIP Solutions Company Visit our Website: http://www.portaone.com

2 1

libzdb memory leakage
by Pavlo Lavrenenko 10 Apr '13

10 Apr '13

Hi. I have a question regarding http://code.google.com/p/libzdb/source/detail?r=538 commit. Currently because of next check: > if (R->columns[i].buffer) { > *size = (int)R->columns[i].length; > return (const void *)R->columns[i].buffer; > } its possible to return a buffer with the size smaller than actual blob size. OracleResultSet_getBlob() should fall through to the loop with OCILobRead2() and RESIZE() with a check like: > if (R->columns[i].buffer == NULL) { > R->columns[i].buffer = ALLOC(LOB_CHUNK_SIZE); > } prior to the loop mentioned. Should I duplicate this mail to bugs-libzdb(a)tildeslash.com? Do you guys have mailing list archive available? -- Best regards, Pavlo Lavrenenko, PortaOne, Inc., Junior Software Developer Tel: +1-866-SIP VOIP (+1 866 747 8647) ext. 7624 PortaOne - VoIP Solutions Company Visit our Website: http://www.portaone.com

3 6

[Announce] libzdb 2.11.1
by Jan-Henrik Haukeland 19 Dec '12

19 Dec '12

Hi everyone Version 2.11.1 of libzdb is now available: Download: http://tildeslash.com/libzdb/dist/libzdb-2.11.1.tar.gz MD5 checksum: 155e89d96df4ec22e984442137f75289 Changes in this release: ------------------------ Fixed: MySQL: A ResultSet bind memory error could occur if string or blob columns of different size caused successive buffer reallocation. Thanks to Ryan Addams for discovering the problem.

1 0

[Announce] libzdb 2.11
by Jan-Henrik Haukeland 06 Dec '12

06 Dec '12

Hi everyone Version 2.11 of libzdb is now available: Download: http://tildeslash.com/libzdb/dist/libzdb-2.11.tar.gz MD5 checksum: f2e44cde8d270d83d8e8c169ed4110fe Changes in this release: ------------------------ * New: Added support for the new bytea hex encoding format introduced in PostgreSQL 9.0. This means that ResultSet_getBlob will correctly return the binary stored in a bytea column independent if the column is escape encoded (old format) or hex encoded (new format). * Fixes: MySQL: A table with two or more columns larger than 256 bytes would cause libzdb to truncate the second column to 256 bytes in the first row. Thanks to Me from China for bug report and patch. * Fixes: Improved Build Configuration. Thanks to Johan Bergström for report

1 1

We will advise you for free how to increase your income by 2, 000 Eur per month.
by martinp＠tildeslash.com 19 Nov '12

19 Nov '12

We invite you to work in the remote assistant position. This work takes 2-3 hours per week and requires absolutely no investment. The essence of this work for incoming client requests in your city. The starting salary is about ~2000 Euro per month + bonuses. You get paid your salary every 2 weeks and your bonuses after fulfilling each task! We guarantee work for everyone. But we accept applications this week only! Therefore, you should write a request right now. And you will start earning money, starting from next week. Please indicate in the request: Your name: Your email address: City of residence: Please send the request to my email Patty(a)jobnorwayno.com and I will answer you personally as soon as possible Sincerely, Patty Bryan

1 0

We invite you to work in your spare time for 100 Eur per hour
by krieg＠tildeslash.com 18 Nov '12

18 Nov '12

We invite you to work in the remote assistant position. This work takes 2-3 hours per week and requires absolutely no investment. The essence of this work for incoming client requests in your city. The starting salary is about ~2000 Euro per month + bonuses. You get paid your salary every 2 weeks and your bonuses after fulfilling each task! We guarantee work for everyone. But we accept applications this week only! Therefore, you should write a request right now. And you will start earning money, starting from next week. Please indicate in the request: Your name: Your email address: City of residence: Please send the request to my email Aaron(a)jobnorwayno.com and I will answer you personally as soon as possible Sincerely, Aaron Keys

1 0

mysql executeQuery uses prepared statement
by Julien Coloos 09 Nov '12

09 Nov '12

Hi, It appears libzdb mysql implementation of Connection_executeQuery actually uses a prepared statement to query the database. This may consume a lot more resources than doing a standard query. At least each query generates 3 actions (statement preparation, execution and then closing). On one of our mysql servers handling up to 4K selects per second, the reported number of operations went up to more than 10K, and the CPU usage went from ~2% user and ~1% system to ~6% user and ~12% system. Some older servers did not have enough CPU available to handle the new load. Is there a reason for using a (lone) prepared statement for each query, or could there be a way in future versions of the library to at least allow to do standard queries (mysql_query or mysql_real_query, and mysql_fetch_*) ? Regards

2 2

[Announce] libzdb 2.10.6
by Jan-Henrik Haukeland 30 Oct '12

30 Oct '12

Hi everyone Version 2.10.6 of libzdb is available: Download: http://tildeslash.com/libzdb/dist/libzdb-2.10.6.tar.gz MD5 checksum: 60d27a7c3857a8fd62da7ba89daa5c25 This is mostly a bug fix release which has been tested on the following platforms: * Linux 2.6 (x86 and x64) * Mac OS X Mountain Lion (Darwin 10.8.x x86_64) * Mac OS X Lion (Darwin 10.7.x x86_64) * 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: ------------------------ * New: ConnectionPool_start() now throws an SQLException instead of calling ABORT if starting the pool failed. Thanks to Christopher O'Hara for suggestion. * Fixes: MySQL: Using a stored procedure which returned a result set would freeze the connection until it was reaped. Thanks to Jesse White for patch. * Fixes: Ensure that the library can be restarted after it was stopped without leaking resources. Only applicable for MySQL which could leak memory on runtime restart. Thanks to Axel Steiner for initial patch and suggestion. Restartable in this context means that you can call ConnectionPool_start and ConnectionPool_stop repeatedly.

2 1

Firebird Database Support
by Christian Mölders 15 Aug '12

15 Aug '12

Hi @ all! My name is Christian and I want to use dbMail with Firebird Databases. dbMails database connectivity based up on libzdb. However no Firebird-Driver exist, so I have joined this group to support the libzdb-project and develop the driver on my own. C is not my preferred codeing language, comeing from Java, Scala and PHP, therefore I will ask a lot ;-) I only coded the typical C apps with few hundred lines of code while studying. Please let me know, if there are any informations or existing approaches for an implementation of the Firebird Driver. Thanks! -- Christian Moelders Software engineer Im Schacht 1 D-35435 Wettenberg Cell: +49 1578 4492525 Mail: cm(a)christian-moelders.de http://christian-moelders.de - out of date ;-)

1 0

OS X Mountain Lion and libzdb
by Jan-Henrik Haukeland 29 Jul '12

29 Jul '12

Just a quick FYI for those attempting to build libzdb 2.10.5 on OS X (10.8) Mountain Lion. Libzdb failed to build on 10.8 because Apple had removed libfl which was required to build a scanner tool used by libzdb. Thanks to a patch from Johan Bergström, I have uploaded a new version of libzdb 2.10.5 which modify configure to also check for libl which works equally well for libzdb. There are no other changes other than configure.ac so I decided to keep the version number. (Apologies to package purists which may not like this). So if you have updated to Mountain Lion, please download libzdb _again_ from http://tildeslash.com/libzdb/dist/libzdb-2.10.5.tar.gz and it should work again.

1 0

DATE_FORMAT
by Hans Richardo 25 Jul '12

25 Jul '12

Dear all, How to use DATE_FORMAT on query with zdb? I have a query which use DATE_FORMAT( DATE_START, '%d-%m-%Y %k:%i:%s' ) AS DATE_START The return from ResultSet_getStringByName( r, "DATE_START" ) is -1208391138-Success-2012 16:0:(null) The data on table is 2012-04-19 16:04:00 so the result should be 19-04-2012 16:04:00 Please help me, Thanks

2 2

[Announce] libzdb 2.10.5
by Jan-Henrik Haukeland 13 Jul '12

13 Jul '12

Hi everyone Version 2.10.5 of libzdb is available: Download: http://tildeslash.com/libzdb/dist/libzdb-2.10.5.tar.gz MD5 checksum: 275007ec5a6fcc41216de36df4d9e776 This release adds automatically URL unescaping of the following URL components; credentials, path and parameter values. This was added as a result of the discussion today on the mailing list where it became clear that libzdb 2.10.4 and previous versions did not support the '@' char in password as well as certain other chars in parameter values. URL unsafe characters can now be used in the above mentioned components by escaping (encode) them. See for example http://www.december.com/html/spec/esccodes.html for an overview of the most common chars and their escaped versions. For example: A connection URL with the password 'b@r', must URL encode '@' using %40. So the connection URL becomes: mysql://localhost:3306/test?user=foo&password=b%40r or mysql://foo:b%40r@localhost:3306/test

1 0

MySQL Password
by Hans Richardo 13 Jul '12

13 Jul '12

Dear all, Have you tried using @ symbol on your MySQL password? I can't connect to my db cause it use @ in the password The error message on abort handler : Failed to start connection pool -- no password specified in URL How to solve this without change the db password? Thanks

3 2

Lizdb Only Mysql Package
by Hans Richardo 28 Jun '12

28 Jun '12

Hi, First, I have installed libzdb with full package (MySQL, PostgreSQL, SQLite and Oracle) on default Prefix. Then I install again with ./configure --without-postgresql --without-sqlite --without-oci --prefix=/project/libzdb-mysql Cause I only want to use the mysql package only, but after I compile my program and use the library on /project/libzdb-mysql why it still use libclntsh.so.11.1, libsqlite3.so.0, libnnz11.so (the library for oracle and sqllite), how to remove it? Please help me, I have to upload my program on my server without PostgreSQL, SQLite and Oracle package. Thanks

3 6

ResultSet_getStringByName to receive NULL
by Hans Richardo 20 Jun '12

20 Jun '12

Thanks for the Version 2.10.4 of libzdb. Please help me, I want to accomodate ResultSet_getStringByName to a String variable, but it comes error if the value returned is NULL. How can I resolve its? This is the error message : terminate called after throwing an instance of 'std::logic_error' what(): basic_string::_S_construct NULL not valid Thanks, Hans

2 1

[Announce] libzdb 2.10.4
by Jan-Henrik Haukeland 19 Jun '12

19 Jun '12

Hi all Version 2.10.4 of libzdb is available: Download: http://tildeslash.com/libzdb/dist/libzdb-2.10.4.tar.gz MD5 checksum: 71431f36728e73223050c24a3ae3912a Changes in this release: ------------------------ * MySQL: Improved error reporting for select and prepared statements

1 0

Libzdb SQLException
by Hans Richardo 19 Jun '12

19 Jun '12

Please help me, give me an example how to error handling (or print error message) if I have an wrong query. I have tried this code with wrong table name (TB_DAT => TB_DATA) but the SQLException doesn't return anything. Connection_T conn = ConnectionPool_getConnection(pool); TRY { ResultSet_T r = Connection_executeQuery( conn, "select id from TB_DAT" ); while ( ResultSet_next( r ) ) __PRINT( ResultSet_getString( r, 1 ) ); } CATCH( SQLException ) { printf( "SQLException - %s\n", Exception_frame.message ); } FINALLY { Connection_close( conn ); } END_TRY; Thanks Hans

3 2

[Announce] libzdb 2.10.3
by Jan-Henrik Haukeland 21 Apr '12

21 Apr '12

Hi everyone Version 2.10.3 of libzdb is available: Download: http://tildeslash.com/libzdb/dist/libzdb-2.10.3.tar.gz MD5 checksum: 1436402b2aedb9189474021501d85562 This is a bug fix release which has been tested on the following platforms: * Linux 2.6 (x86 and x64) * Mac OS X Lion (Darwin 10.7.x x86_64) * Mac OS X Snow Leopard (Darwin 10.6.x i386/x86_64) * 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: ------------------------ * Fixed an Oracle compile issue. Libzdb now uses strict C99 and the Oracle code needed to use a typed union instead of an anonymous union for gcc to compile libzdb w/ Oracle. Thanks to Stas Oginsky Those that use Oracle with libzdb should update.

1 0

configure error: no available database found
by Konstantin Kouptsov 18 Apr '12

18 Apr '12

Hello, I have just downloaded the library source, libzdb-2.10.26, and I am trying to install it. When running ./configure script I get the following error: configure: error: No available database found or selected. Try configure --help What is it specifically looking for? I have mysql database installed and running. The --help option does not really help to understand what's wrong. Konstantin.

2 1

Store Procedure
by Joe Flemmings 07 Apr '12

07 Apr '12

I'm having problems with a stored procedure that returns only one column. ResultSet_getColumnName(rset,1) has the header info but ResultSet_getString(rset,1) is empty. When i run it on MySQL it works. Please advice. Joe

2 4

Get Number of Rows
by Joe Flemmings 06 Apr '12

06 Apr '12

I need to get the number of rows in a query. I only see number of columns with ResultSet_getColumnCount Please advice. Thanks Joe

2 10

[Announce] libzdb 2.10.2
by Jan-Henrik Haukeland 15 Mar '12

15 Mar '12

Hi everyone Version 2.10.2 of libzdb is available: Download: http://tildeslash.com/libzdb/dist/libzdb-2.10.2.tar.gz MD5 checksum: 7fc43cd79131eb989e8732f1c52b1bb6 This is a bug fix release which has been tested on the following platforms: * Linux 2.6 (x86 and x64) * Mac OS X Lion (Darwin 10.7.x x86_64) * Mac OS X Snow Leopard (Darwin 10.6.x i386/x86_64) * 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: ------------------------ * Fixed an Oracle connection parameter bug. Thanks to l00106600 * A zdb.pc library package config file was added. Thanks to Matthieu Verbert Those that use Oracle with libzdb should update.

1 0

Re: pkgconfig support
by Jan-Henrik Haukeland 13 Jan '12

13 Jan '12

Hello Matthieu I must admit I know very little about packaging, but this seems useful to me. Thank you very much. Patch was added, http://code.google.com/p/libzdb/source/detail?r=471 Best regards -- Jan-Henrik Haukeland On Jan 12, 2012, at 11:29 AM, Matthieu Verbert wrote: > Dear all, > It seems like a general trend to ship a .pc file along with the headers and .so file in a development package to ease the work of users of the library. > I did a trivial implementation (see attached patch, comments welcome) for libzdb, and was wondering whether it would be of general interest. > What do you think ? > Best regards, > > Matthieu

1 0

pkgconfig support
by Matthieu Verbert 12 Jan '12

12 Jan '12

Dear all, It seems like a general trend to ship a .pc file along with the headers and .so file in a development package to ease the work of users of the library. I did a trivial implementation (see attached patch, comments welcome) for libzdb, and was wondering whether it would be of general interest. What do you think ? Best regards, Matthieu

1 0

inconsistencies after configure of libzdb
by Lou Picciano 06 Jan '12

06 Jan '12

Jan-Henrik, First, thanks for your great work on libzdb - looks like something we should be paying more attention to! For the moment, I'm building for use with dbmail - doing all this on OpenIndiana x86 (the reincarnation of OpenSolaris). Paul Stevens suggested I should get in touch with you... What started as a question may turn out to be a series of observations - as I've now managed to get libzdb built with protected-mode disabled. Was running into a problem that --disable-protected apparently didn't! Also, that the 'results banner' presented after ./configure seems to be inconsistent with what's actually going on. For example, even though I --disable-profiling, the 'banner' states it's enabled. As I plan to use libzdb, pls let me know if I can provide any information of use to you in debugging. Meanwhile, again; Thanks for the great work. Lou Picciano

3 2

[Announce] libzdb 2.10
by Jan-Henrik Haukeland 29 Oct '11

29 Oct '11

Hi everyone Version 2.10 of libzdb is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.10.tar.gz MD5 checksum: fdc04b4b7f33cdcdfc6b559ba9965825 This is a feature release which has been tested on the following platforms: * Linux 2.6 (x86 and x64) * Mac OS X Lion (Darwin 10.7.x x86_64) * Mac OS X Snow Leopard (Darwin 10.6.x i386/x86_64) * 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: ------------------------ * Make libzdb compatible and includable in a C++ or in a Objective-C++ project. * Internal code refactoring and improvements What's next? ------------ I thought adding datetime, date and time functions to a ResultSet might be useful. What do you think? Other ideas?

1 0

Problems using reference include Headers on C++ project.
by Antonio Castellon - RAC 28 Oct '11

28 Oct '11

Dear Developers & friends, I installed the libzdb on my systems from the sources and the compilation and installation was finished successfull, later I can see the includes into my /usr/local/include/zdb folder, but when I put the header : #include <zdb/zdb.h> into my C++ project, it launch an exception on building time. **** Build of configuration Debug for project SerialTest2 **** make all Building file: ../src/SerialTest2.cpp Invoking: GCC C++ Compiler g++ -I/usr/local/include/zdb -O0 -g3 -Wall -c -fmessage-length=0 -MMD -MP -MF"src/SerialTest2.d" -MT"src/SerialTest2.d" -o"src/SerialTest2.o" "../src/SerialTest2.cpp" In file included from /usr/local/include/zdb/zdb.h:33, from ../src/SerialTest2.cpp:19: /usr/local/include/zdb/URL.h:55: *error: conflicting declaration ‘typedef struct URL_T* URL_T’* /usr/local/include/zdb/URL.h:55: *error: ‘struct URL_T’ has a previous declaration as ‘struct URL_T’* *...* * * * * Somebody has an idea that what's happen? Thanks in advance Toni

2 7

[Announce] libzdb 2.9
by Jan-Henrik Haukeland 15 Aug '11

15 Aug '11

Hi everyone Version 2.9 of libzdb is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.9.tar.gz MD5 checksum: 8478e36a0f74dd93b810f12baa81afe0 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 Lion (Darwin 10.7.x x86_64) * Mac OS X Snow Leopard (Darwin 10.6.x i386/x86_64) * 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: ------------------------ * SQLite: Unescape path to allow for (white-)space in database file path. Thanks to Jonas Schnelli * SQLite: Use sqlite3_open_v2 instead of sqlite3_enable_shared_cache which is deprecated in OS X Lion. * Oracle: Fixed a problem with ResultSet not returning all data. Thanks to Volodymyr Tarasenko * Plus internal optimizing changes

1 0

ConnectionPool_free does not return
by Michel Verbraak 20 Jul '11

20 Jul '11

We use the libzdb library in one of our projects together with mysql 5.5 This program is multithreaded and the different threads (forks) use the same connection pool. On a sigterm to the main process the child processes are killed and the main process will clear all allocated resource. When this main process calls "ConnectionPool_free" this function never returns. I can produce more debug info when needed. Regards, -- Michel Verbraak

2 5

Abwesenheitsnotiz: Abwesenheitsnotiz: Abwesenheitsnotiz: Abwesenheitsnotiz: Abwesenheitsnotiz: Re: ConnectionPool_free does not return
by jonas.schnelli＠include7.ch 20 Jul '11

20 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: Abwesenheitsnotiz: Re: ConnectionPool_free does not return
by jonas.schnelli＠include7.ch 20 Jul '11

20 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: Re: ConnectionPool_free does not return
by jonas.schnelli＠include7.ch 20 Jul '11

20 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: Re: ConnectionPool_free does not return
by jonas.schnelli＠include7.ch 20 Jul '11

20 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: Re: ConnectionPool_free does not return
by jonas.schnelli＠include7.ch 20 Jul '11

20 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: 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

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

libzdb-general