libzdb-general

libzdb-general@tildeslash.com

2 participants
147 discussions

a poor design about ConnectionPool_getConnection
by dec wu 19 Aug '16

19 Aug '16

*hi* this function *ConnectionPool_getConnection* is designed badly。 between code *LOCK(P->mutex)* and *END_LOCK*, *Connection_ping* and *Connection_new* may block long time (reconnect/connect to sql server),so other threads will wait long time. * should't block when locked!!!!* see below code for detail: *Connection_T ConnectionPool_getConnection(T P) {* * Connection_T con = NULL;* * assert(P);* * LOCK(P->mutex) * * {* * int size = Vector_size(P->pool);* * for (int i = 0; i < size; i++) {* * con = Vector_get(P->pool, i);* * if (Connection_isAvailable(con) && Connection_ping(con)) {* * Connection_setAvailable(con, false);* * goto done;* * } * * }* * con = NULL;* * if (size < P->maxConnections) {* * con = Connection_new(P, &P->error);* * if (con) {* * Connection_setAvailable(con, false);* * Vector_push(P->pool, con);* * } else {* * DEBUG("Failed to create connection -- %s\n", P->error);* * FREE(P->error);* * }* * }* * }* *done: * * END_LOCK;* * return con;* *}*

1 0

Connecting connection pool using certificate
by Vicki Ma 09 Apr '16

09 Apr '16

Hi, I plan to use libzdb for connection pooling, but I am not sure if I can connect to the connection pool using user certificate. In the document, it specifies how to connect to Postgresql database. postgresql://localhost:5432/test?user=root&password=swordfish Can I pass the following: postgresql://user:secret@localhost I did not see the options mentioning connecting database using certificates. http://tildeslash.com/libzdb/api-docs/postgresoptions.html Thanks very much, Vicki Ma

4 9

Retrieving pqxx::result
by Ma, Vicki 09 Apr '16

09 Apr '16

Hi, I have a question, say, I connect to libzdb connection pool (connecting to a Postgresql database), and execute a query, do I have a way to retreive the native result, ie. pqxx::result from libzdb ResultSet? Thanks in advance, Vicki >

1 0

access Archives of this mailing list
by Ma, Vicki 07 Apr '16

07 Apr '16

Hi, I am new to the mailing list, I want to take a look at archieve, so I don’t ask questions answered before, but I was not able to access the Archives. http://www.tildeslash.com/mailman/listinfo/libzdb-general http://www.tildeslash.com/pipermail/libzdb-general/ Does anyone know how? Thanks Vicki Ma

1 0

access archieve
by Ma, Vicki 07 Apr '16

07 Apr '16

Hi, I am new to the mailling list, I want to take a look at archieve, so I don’t ask questions answered before, but I was not able to access the Archives. http://www.tildeslash.com/mailman/listinfo/libzdb-general http://www.tildeslash.com/pipermail/libzdb-general/ Does anyone know how? Thanks Vicki Ma -- To unsubscribe: http://www.tildeslash.com/mailman/listinfo/libzdb-general

1 0

AssertException in OraclePreparedStatement_getLastError()
by Pavlo Lavrenenko 15 Mar '16

15 Mar '16

Hello. I have dbmail-imapd crashed with: > Jan 20 04:25:17 um1 dbmail/imap4d[24111]: EMERGENCY:[libzdb] TabortHandler(+43): AssertException: 0x0x3db0e15950 > raised in OraclePreparedStatement_getLastError at src/db/oracle/OraclePreparedStatement.c:257 Which seems to be triggered by assert() in OraclePreparedStatement_getLastError(): > 251 /* This is a general error function also used in OracleResultSet */ > 252 const char *OraclePreparedStatement_getLastError(int err, OCIError *errhp) { > 253 sb4 errcode; > 254 char* erb; > 255 pthread_once(&error_msg_key_once, error_msg_key_alloc); > 256 erb = get_err_buffer(); > 257 assert(erb); I do not have any steps to reproduce the issue unfortunately, but maybe you can give me a nudge into a right investigation direction (I am investigating why get_err_buffer() returned NULL). I would also be nice to have another thread safe way to store the error message or even to print it (providing the issue is reproducible at all). -- 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 3

How to directly get the record number from the query results?
by Chengyu Fan 20 Jan '16

20 Jan '16

Hi, Does anyone know how to get the record number from the query results using libzdb? I did not find such API in the manual. Thanks, Chengyu

2 2

libzdb-3.2 release plan
by Pavlo Lavrenenko 06 Oct '15

06 Oct '15

Hello. Just for my information guys, are there any release plans for libzdb-3.2? -- 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

Sorry to bother you
by Ethan Chen 21 Sep '15

21 Sep '15

Dear sir: So sorry to bother you. I am working in a techology company now, and i am in a project which needs to be connected with serveal database. The work have been done well by using the libzdb. But i meet a question when i try to call a function(or store procedure) defiend by myself, which i mean i'd like to find a function like SetProcSQL() in the OCCI that connect ORACLE. Although I have read the documentation, i did not find the examples how to implement it . So can you tell me does any function which can implement it? Thank you for youtr time, maybe i didn't make myself clear for my poor English.I looking for your repley. Best wish. Ethan Chen

1 0

libzdb : Missing 64-bit support Error
by Mahajan, Anand 31 Aug '15

31 Aug '15

Hi there, We are using Libzdb database library version 2.8.1 in our iOS application; now we are trying to upload the application using App Loader to iTunes store; we have got following error; 'Missing 64-bit support - Beginning on February 1, 2015 new iOS apps submitted to the App Store must include 64-bit support and be built with the iOS 8 SDK. Beginning June 1, 2015 app updates will also need to follow the same requirements. To enable 64-bit in your project, we recommend using the default Xcode build setting of "Standard architectures" to build a single binary with both 32-bit and 64-bit code' Following are our project settings; The error message suggested to add 'standard Architecture' to enable 64-bit support in application; upon setting 'arm64' value for 'valid architecture' in project setting; application is displaying following error Undefined symbols for architecture arm64: "_ResultSet_getDouble", referenced from: _getInvProductsFromDB in .o" ld: symbol(s) not found for architecture arm64 clang: error: linker command failed with exit code 1 (use -v to see invocation) We are getting undefined symbol error for every API call of libzdb library; Could you please guide us to build the library for default Xcode setting of standard architecture(arm64, arm7,armv7s)? Appreciate your quick response; Thank you! Anand Mahajan =============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ===============================================================================

2 1

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