libzdb-general

libzdb-general@tildeslash.com

1 participants
152 discussions

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

Libzdb 3.0 beta
by Jan-Henrik Haukeland 05 Jan '14

05 Jan '14

Happy new year! We been working on a new libzdb 3.0 release which include some new useful features. Most notable support for Date, Time and timestamp. This release includes a lot of changes so we wanted to release this as a beta version/release candidate first. If you can, please help us test. If you find a problem, please use the issue tracker at https://github.com/tildeslash/libzdb/issues Download: http://www.tildeslash.com/libzdb/dist/libzdb-3.0b.tar.gz MD5 checksum: 6c0334d8132723d8a58414d4b208690e Developer version: https://github.com/tildeslash/libzdb/releases Changes in this release: ------------------------ * New: Methods for retrieving Date, Time, DateTime and TimeStamp column values from a ResultSet. PreparedStatement_setTimestamp for setting Unix timestamp. * New: ResultSet_isnull, can be used to explicit test if a column value in a Result Set is SQL null. A Result Set already returns the NULL pointer for string and blob types and 0 for primitive data types, but to differ between SQL null and the value NULL or 0, this method can be used. * New: PreparedStatement_getParameterCount, Returns the number of parameters in a prepared statement * New: It is now a checked runtime error for the url parameter given in ConnectionPool_new() to be NULL. * New: No longer require flex installed as the generated file is part of the dist. * Fixes: Oracle: Fixed a memory corruption in OracleResultSet https://github.com/tildeslash/libzdb/issues/4 Best regards -- Jan-Henrik Haukeland

2 1

libzdb
by edavanzo＠vodafone.it 30 Nov '13

30 Nov '13

Hi, I have a request for a bit particular: Can I have libzdb.dylib already compiled for use in a xcode project (iphone or iPad prj) to connect to an Oracle DB and then execute a Select command. Sorry for the strange request but I have no familiarity with compilers. Thanks for everything. (If needed I can pay the bother) Or can you tell me where and how I can buy it. Best Regards.

2 1

MSSQL and Sybase with libzdb
by Abhay Gupta 27 Nov '13

27 Nov '13

Hi, I was wondering as to why the support for MSSQL and Sybase is not added via a freetds library ? This will make libzdb complete pool library with mostly used databases being supported . Thanks, Abhay

2 1

MySQL Cluster with dbmail, Possible?
by Matt . 05 Nov '13

05 Nov '13

Hi All, I'm new to dbamil with libzdb but it works great in the first setup. Is it possible with libzdb to connect to a pool of MySQL servers which are all master using an array in some config anywhere ? I hope someone can help out. Thanks! Cheers, Matt

2 1

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

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