libzdb-general

libzdb-general@tildeslash.com

2 participants
147 discussions

[Announce] libzdb 3.1
by Jan-Henrik Haukeland 31 Aug '15

31 Aug '15

Version 3.1 of libzdb is now available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-3.1.tar.gz MD5 checksum: 01d8519a596d62f6b43559cc29ecd36d Release notes at http://www.tildeslash.com/libzdb/#release_notes

1 0

SQL query timeout for OracleConnection
by Pavlo Lavrenenko 31 Aug '15

31 Aug '15

Hello. I've noticed query timeout for Oracle connections is a stub, seems like OCI API does not provide a way to limit query execution out-of-box. Yet I am trying to workaround the blocked (server-side) connections issue with DBMail and setQueryTimeout() seems to be a good tool for that. So far I came up with a thread-based solution: 1. a dedicated thread is created for every db connection; 2. thread acts like a watchdog: for every started query it counts down from TIMEOUT value to zero; 3. if query execution is finished the counter is reset and thread idles; 4. if counter reaches 0 the thread calls OCIBreak(). I'd like to know your vision on the solution and reasons why query timeouts are not implemented for Oracle backend before I start the development and publish the patch. TIA. -- Best regards, Pavlo Lavrenenko, PortaOne, Inc., 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 2

Multiple database connection pool problem
by patel ravi 12 Aug '15

12 Aug '15

Hello, I am using libzdb for database connection pool from a C++ program . Till now I was making only one database connection pool through libzdb and was working perfect . Now I need to make multiple database connection pools , I tried making this , but it consider only one connection pool and fetch the data from only one database . I found that Multiple database connection is possible through libzdb , somehow I am not able to do that . Any help will be appriciated. Thank You,Ravi

2 1

Undefined reference errors
by Srinivasa Rao Battula 04 May '15

04 May '15

Hello, I am trying to link libzdb on Ubuntu with Code Blocks v13. I am facing following errors: obj/Release/SERVER/DBConnection/zdb_connection/cstzdbresultset.o: In function `CSTZDBResultSet::is_null(unsigned int) const': /home/bsr/work/Development/source_cs_server/SOURCE/SERVER/DBConnection/zdb_connection/cstzdbresultset.cpp:15: undefined reference to `ResultSet_isnull(ResultSet_S*, int)' /home/bsr/work/Development/source_cs_server/SOURCE/SERVER/DBConnection/zdb_connection/cstzdbresultset.cpp:18: undefined reference to `Exception_throw(Exception_T const*, char const*, char const*, int, char const*, ...)' Same problem is seen with all the symbols in the ResultSet.c. I have followed the instructions to build the library and is installed in /usr/local/lib. However, I am not seeing the same with Connection class and some of the exception macros. Please suggest me how to fix this problem. Thanks & Regards BSR Systems Manager M: +91 7032643557 E: bsr(a)srithripurasoft.com <https://3c-bs.gmx.com/mail/client/mail/mailto;jsessionid=35544C236AFAABFE0F…> ------------------------------ <https://3c-bs.gmx.com/mail/client/dereferrer?redirectUrl=http%3A%2F%2Fwww.n…> [image: Inline image 1] #205, Nilgiri Block Aditya Enclave, Ameerpet Hyderabad,Telangana Inda PIN:500016 W: http://www.srithripurasoft.com

1 0

CLOB-columns in Oracle DBs always return 'null'.
by Mats Christensen 04 May '15

04 May '15

Hi, It seems like libzdb (probaly) won't handle CLOBs in Oracle DBs very well. When selecting a CLOB directly nothing but the value 'null' is returned, when typecasting the CLOB to ex. VARCHAR2 it works perfectly. The same problem occurs when inserting data to a CLOB. Tests for Oracle also fails because of this. I've tried libzdb 2.8, 2.12 and 3.0, the same problem occurs in all three. This happens with Oracle Instant Client 11,1 11,2 and 12,1. Has anyone else encountered this? Is it a bug in libzdb or Instant Client? Thank you very much! Regards, Mats Christensen

5 9

Hallo
by Alessandro Vesely 22 Oct '14

22 Oct '14

I was trying to figure out differences between zdb and opendbx. The most relevant one is suspecting that opendbx is not being actively maintained. Opendbx supports Sybase. Libzdb looks very anonymous. Even this list's archives are not accessible. (http://www.tildeslash.com/pipermail/libzdb-general/) So I thought I'd just say hallo :-) Ale

1 0

about libzDB
by Mohamed abdElkhalek 03 Apr '14

03 Apr '14

i want to ask about if i can enable auto re-connection property with MYSQL in libzDB.

2 1

Unisgned integers
by Laxman Prabhu 03 Apr '14

03 Apr '14

Does LibZdb support unsigned int in the prepare statements ? I went through the Prepare statements source code and could only find long, int, long long, string. Is there any way to do a unsigned int operation ? Regards Laxman

2 1

Re: CLOB-columns in Oracle DBs always return 'null'.
by Volodymyr Tarasenko 03 Feb '14

03 Feb '14

Thanks for the code, I'm checking this case. Looks like blob was not read correctly. Let you know as soon as I get new results. Good luck, Volodymyr! On Saturday, February 1, 2014 3:44 PM, Volodymyr Tarasenko <tvntsr(a)yahoo.com> wrote: Hi, Mats, thanks for the code, I'm going to check it. Good luck, Volodymyr! On Saturday, February 1, 2014 2:52 PM, Mats Christensen <matschristensen(a)gmail.com> wrote: I missed the clob data on the earlier sql, this is correct. On Sat, Feb 1, 2014 at 1:44 PM, Mats Christensen <matschristensen(a)gmail.com> wrote: See the attachment select.c and clob_test.sql > > >Libzdb 3.0 and Oracle Instant Client 12.1 >This setup returns the following for me: > > >mats@x220 ~/libzdb/libzdb-3.0/test $ ./select >This is getString: >this is a varchar (null) >this is another var (null) >This is getBlob: >this is a varchar this is a clob >this is another var this is another clob > > > > >Can you see if it works for you? The problem might be my setup although I've tried two completely different linux setups. > > >Thanks! > > >Regards, >Mats Christensen > > > > > >On Sat, Feb 1, 2014 at 1:12 AM, Jan-Henrik Haukeland <hauk(a)tildeslash.com> wrote: > >ResultSet_getBlob or ResultSet_getString should be interchangeable on a blob or text column. Though of course, if the blob column contains binary data only ResultSet_getBlob should be used to get the correct value. >> >>I should say that a problem with using ResultSet_getString on a blob column was just fixed in Oracle and confirmed fixed in version 3.0. So with one datapoint, the above seems to work. If you want us to investigate, we are also more inclined to do so if you can provide a small test program demonstrating the problem. Or argue in detail why the problem must be in libzdb. >> >>Best regards >>-- >>Jan-Henrik Haukeland >> >> >>On 31 Jan 2014, at 13:36, Mats Christensen <matschristensen(a)gmail.com> wrote: >> >>> >>> I'm not very familiar with Oracle either but it seems like CLOB is for Oracle what TEXT is for Postgres and MySQL. >>> >>> There is a function in the dbmail-code called 'db_result_get_blob', it is used for several things, >>> like '_fetch_headers'. HEADERVALUE is a CLOB.on Oracle and TEXT on Postgres. >>> >>> Perhaps this function should have been used on '_fetch_envelope' too? >>> >>> It will probably be easiest for me to just use getBlob instead, as for upstream, perhaps it's a good idea to use >>> 'db_result_get_blob' for all TEXT/CLOB-fields if it works? >>> >>> Thank you very much for the help! >>> >>> Regards, >>> Mats Christensen >>> >> >>-- >>To unsubscribe: >>http://www.tildeslash.com/mailman/listinfo/libzdb-general >> > -- To unsubscribe: http://www.tildeslash.com/mailman/listinfo/libzdb-general

1 0

Announce] libzdb 3.0
by Jan-Henrik Haukeland 06 Jan '14

06 Jan '14

Version 3.0 of libzdb is now available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-3.0.tar.gz MD5 checksum: 3bb9efff10a1f3ebc5b76c1055c48635 Please see the release notes at http://www.tildeslash.com/libzdb/#release_notes

1 0

← Newer
1
2
3
4
5
6
7
...
15
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