libzdb-general

libzdb-general@tildeslash.com

1 participants
152 discussions

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

← Newer
1
2
3
4
5
6
7
8
9
...
16
Older →

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

libzdb-general