libzdb-general

libzdb-general@tildeslash.com

1 participants
153 discussions

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

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

← 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