libzdb-general

libzdb-general@tildeslash.com

148 discussions

DATE_FORMAT
by Hans Richardo 25 Jul '12

25 Jul '12

Dear all, How to use DATE_FORMAT on query with zdb? I have a query which use DATE_FORMAT( DATE_START, '%d-%m-%Y %k:%i:%s' ) AS DATE_START The return from ResultSet_getStringByName( r, "DATE_START" ) is -1208391138-Success-2012 16:0:(null) The data on table is 2012-04-19 16:04:00 so the result should be 19-04-2012 16:04:00 Please help me, Thanks

2 2

[Announce] libzdb 2.10.5
by Jan-Henrik Haukeland 13 Jul '12

13 Jul '12

Hi everyone Version 2.10.5 of libzdb is available: Download: http://tildeslash.com/libzdb/dist/libzdb-2.10.5.tar.gz MD5 checksum: 275007ec5a6fcc41216de36df4d9e776 This release adds automatically URL unescaping of the following URL components; credentials, path and parameter values. This was added as a result of the discussion today on the mailing list where it became clear that libzdb 2.10.4 and previous versions did not support the '@' char in password as well as certain other chars in parameter values. URL unsafe characters can now be used in the above mentioned components by escaping (encode) them. See for example http://www.december.com/html/spec/esccodes.html for an overview of the most common chars and their escaped versions. For example: A connection URL with the password 'b@r', must URL encode '@' using %40. So the connection URL becomes: mysql://localhost:3306/test?user=foo&password=b%40r or mysql://foo:b%40r@localhost:3306/test

1 0

MySQL Password
by Hans Richardo 13 Jul '12

13 Jul '12

Dear all, Have you tried using @ symbol on your MySQL password? I can't connect to my db cause it use @ in the password The error message on abort handler : Failed to start connection pool -- no password specified in URL How to solve this without change the db password? Thanks

3 2

Lizdb Only Mysql Package
by Hans Richardo 28 Jun '12

28 Jun '12

Hi, First, I have installed libzdb with full package (MySQL, PostgreSQL, SQLite and Oracle) on default Prefix. Then I install again with ./configure --without-postgresql --without-sqlite --without-oci --prefix=/project/libzdb-mysql Cause I only want to use the mysql package only, but after I compile my program and use the library on /project/libzdb-mysql why it still use libclntsh.so.11.1, libsqlite3.so.0, libnnz11.so (the library for oracle and sqllite), how to remove it? Please help me, I have to upload my program on my server without PostgreSQL, SQLite and Oracle package. Thanks

3 6

ResultSet_getStringByName to receive NULL
by Hans Richardo 20 Jun '12

20 Jun '12

Thanks for the Version 2.10.4 of libzdb. Please help me, I want to accomodate ResultSet_getStringByName to a String variable, but it comes error if the value returned is NULL. How can I resolve its? This is the error message : terminate called after throwing an instance of 'std::logic_error' what(): basic_string::_S_construct NULL not valid Thanks, Hans

2 1

[Announce] libzdb 2.10.4
by Jan-Henrik Haukeland 19 Jun '12

19 Jun '12

Hi all Version 2.10.4 of libzdb is available: Download: http://tildeslash.com/libzdb/dist/libzdb-2.10.4.tar.gz MD5 checksum: 71431f36728e73223050c24a3ae3912a Changes in this release: ------------------------ * MySQL: Improved error reporting for select and prepared statements

1 0

Libzdb SQLException
by Hans Richardo 19 Jun '12

19 Jun '12

Please help me, give me an example how to error handling (or print error message) if I have an wrong query. I have tried this code with wrong table name (TB_DAT => TB_DATA) but the SQLException doesn't return anything. Connection_T conn = ConnectionPool_getConnection(pool); TRY { ResultSet_T r = Connection_executeQuery( conn, "select id from TB_DAT" ); while ( ResultSet_next( r ) ) __PRINT( ResultSet_getString( r, 1 ) ); } CATCH( SQLException ) { printf( "SQLException - %s\n", Exception_frame.message ); } FINALLY { Connection_close( conn ); } END_TRY; Thanks Hans

3 2

[Announce] libzdb 2.10.3
by Jan-Henrik Haukeland 21 Apr '12

21 Apr '12

Hi everyone Version 2.10.3 of libzdb is available: Download: http://tildeslash.com/libzdb/dist/libzdb-2.10.3.tar.gz MD5 checksum: 1436402b2aedb9189474021501d85562 This is a bug fix release which has been tested on the following platforms: * Linux 2.6 (x86 and x64) * Mac OS X Lion (Darwin 10.7.x x86_64) * Mac OS X Snow Leopard (Darwin 10.6.x i386/x86_64) * FreeBSD 6.x, 7.x and 8.x (x86 and x64) * Solaris 10 and Solaris Express (sparc and x86) * OpenBSD 4.x (x86 and x64) Changes in this release: ------------------------ * Fixed an Oracle compile issue. Libzdb now uses strict C99 and the Oracle code needed to use a typed union instead of an anonymous union for gcc to compile libzdb w/ Oracle. Thanks to Stas Oginsky Those that use Oracle with libzdb should update.

1 0

configure error: no available database found
by Konstantin Kouptsov 18 Apr '12

18 Apr '12

Hello, I have just downloaded the library source, libzdb-2.10.26, and I am trying to install it. When running ./configure script I get the following error: configure: error: No available database found or selected. Try configure --help What is it specifically looking for? I have mysql database installed and running. The --help option does not really help to understand what's wrong. Konstantin.

2 1

Store Procedure
by Joe Flemmings 07 Apr '12

07 Apr '12

I'm having problems with a stored procedure that returns only one column. ResultSet_getColumnName(rset,1) has the header info but ResultSet_getString(rset,1) is empty. When i run it on MySQL it works. Please advice. Joe

2 4

← Newer
1
...
5
6
7
8
9
10
11
...
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