_
libdbi-users mailing list
libdbi-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libdbi-users
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
___
libdbi-users mailing list
libdbi-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libdbi-users
s and
>> Linux platforms?
>> -From where can I get DbiXX detail documentation and source code of the
>> same?
>>
>> Regards,
>> Pabitra
>
> ___
> libdbi-users mailing list
> libdbi-users@lists.sourceforge.net
> https://lists.so
ks fine from the
> sqlite3 shell?
>
> Thank you very much.
> Ciao!
Hi,
unfortunately I didn't find the time to actually reproduce your problem.
However, I've found the following conspicuous line in dbd_sqlite3.c
(line 1236 in my copy):
|| strstr(curr_type, "INTEGER PR
dbi-drivers. libdbi needs a generic
interface to prepared statements that covers all database backends. The
drivers have to implement the feature using the functions of their
respective client libraries. Therefore, it is best to design and discuss
the interface firs
At 2014-11-04 11:41 Alex Bligh was heard to say:
> On 3 Nov 2014, at 22:54, Markus Hoenicka
> wrote:
>
>> I wouldn't bet from valgrind's output that it is libdbi variables
>> which are uninitialized. Can you re-run your test with a different
>> database
ached a full valgrind dump as it's enormous. However, you
> can see
> the first two below.
>
> Any ideas?
>
Hi,
I wouldn't bet from valgrind's output that it is libdbi variables which
are uninitialized. Can you re-run your test with a different database
engine? I
th libdbi and libdbi-drivers contain an autogen.sh script in
the top-level directory which will generate an appropriate configure
script for you.
regards
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
.9, or better yet,
use the git versions of both if you're fiddling with experimental
drivers.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
Want excitement?
Manually upgrade your production da
around the title. This does not seem to generate valid
SQL. Also, if you don't use the printf()-like capabilities of
dbi_conn_queryf(), there is no point in using this function. Use
dbi_conn_query() instead.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
---
Am 2014-01-10 14:17, schrieb Markus Hoenicka:
> if I understand you correctly, you attempt to insert a value containing the
> string "%s Saints going down tonight!" using the libdbi function
> dbi_conn_queryf(). Thing is, dbi_conn_queryf() is intended to make
> d
nsert a value containing
the string "%s Saints going down tonight!" using the libdbi function
dbi_conn_queryf(). Thing is, dbi_conn_queryf() is intended to make
dbi_conn_query() behave somewhat like sprintf() in that you can specify
a formatting string containing placeholders like "
d probably have been removed or at least be
deprecated. For a cleaner solution, please define CFLAGS and LDFLAGS
appropriately before running configure and make.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
sap (see above).
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free t
ying to get a simple test case running, to no avail. I'm
going to release libdbi-drivers without official firebird support
unless someone steps up and takes a look at the firebird driver and
the tests.
best regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
-
ird is kind of picky
about dropping tables which were previously used? This is kind of
weird, as any serious database should support dropping tables. How do
you deal with this in your own programs?
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
th test cases should be complete in that they create
the database, create the table, insert the data, and clean up after
themselves when the test succeeds. It would be a major step forward
towards debugging if I was able to run these test cases on my box
or
messages, but at this time the test program does not run to completion
using this driver. Did you ever succeed in running the new test
kit? Or the old one shipped with 0.8.3 fwiw?
regards,
Markus
--
Markus Hoenicka
ht
weird non-standard
library directories, I don't have any problems building the firebird
driver from the headers and libraries provided by the Debian packages.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
would you please share
some information how you succeeded in running firebird at
all. Again, I'm not talking about libdbi or libdbi-drivers problems. I
just can't get the engine itself to work.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
---
you run make check? If that didn't crash, we need
extra tests to discover problems like these.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
Free Next-Gen Firewall Hardware Offer
Buy yo
new format. We're
now back at 0 errors, but I can test this against PostgreSQL 9.2
only. Would someone be kind enough to test the code on older versions
of this engine?
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
encoding test. After disabling that one, I still get 47 failures,
while both mysql and sqlite3 succeed without a hitch. Is anyone using
PostgreSQL with libdbi, and if yes, which versions?
regards,
Markus
--
Markus Hoenicka
http://www.mhoe
l
aspects of transactions and savepoints as well. I'd greatly appreciate
if everyone could give the current cvs revisions a try and report
success and failures.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
-
Markus Hoenicka writes:
> Another possible reason for problems is the table type. If someone
> uses MyISAM tables, the result I got would be expected. However, MySQL
> uses InnoDB tables as default these days, and I double-checked that
> they were used in my tests.
Turns out
problems too. I'll also check the MySQL logs to see if I find
something weird, and I'll run some transactions in MySQL's plain ol'
command line interface just to make sure it isn't MySQL playing tricks
on us.
regards,
Markus
--
M
a first shot at the required test
functions. MySQL seems to fail to rollback transactions on my box
whereas SQLite3 succeeds. I'm too tired now to track this down, maybe
someone else can have a look at this too. I hope I'll get back to this
on the weekend.
regards,
Markus
--
Markus Hoen
see the new
> transaction functions inside the sgml files as well as the headers.
> However, I do not find any implementation (.c files).
>
> Am I overlooking something?
>
No. Apparently my bad. I'll fix that tonight.
regards,
Markus
--
Markus Hoenicka
htt
ocumentation. Did
anyone else have a chance to test the code lately?
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and muc
48ee1.jpg
> max value on X-Axis is equivalent to ~ 35k rows retrieved from MySQL.
>
> Quite impressive, right ? ;)
>
Looks like my 30 min effort was well spent then. Thanks for kicking my
butt to get this done.
regards,
Markus
--
Markus Hoenic
s ready for prime time. It would be great if we could find
a couple of kind souls who test the current CVS revisions on as many
platforms as possible to find showstoppers, if any.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
-
Markus Hoenicka writes:
> Hi,
>
> I'll have to read the code again a little more thoroughly, but to the
> best of my knowledge libdbi emulates MySQL's approach to retrieving
> rows from result sets. In order to walk through the rows of e.g. a
> Postg
you build from cvs regularly (and only if you update
one but not the other), but I expect those users to know what they're
doing.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
Master
Olivier Doucet was heard to say:
> Hi Markus,
>
> 2013/1/8 Markus Hoenicka :
>> We could modify the driver function
>> dbd_goto_row() by passing both the wanted row index rowidx and the
>> current row index currowidx(which libdbi keeps track of anyway).
>
> This
hether they have to actually seek the
position. pgsql doesn't have to anyway, and mysql doesn't have to if
rowidx = currowidx+1. This API change would not mandate changes to
existing drivers as they may ignore the additional parameter and keep
working as before
th freetds, but without successs.
>
The driver source suggests that the version should use the format
X.XX.XX. If you're using version 7.x, only the first character is
checked though, so "7.0" should have worked here as well.
regards,
Mar
start.
>
FYI I've also updated the docs in cvs to reflect the latest changes.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
LogMeIn Rescue: Anywhere, Anytime Remote support for
ng the documentation and the tests, but feel
free to test the current code yourself. Usage should be pretty obvious
if you look at the diffs. I'm sure some rough edges remain, but
then... it's a start.
regards,
Markus
-
t
MySQL "supported" transactions in MyISAM tables using no-ops.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
Monitor your physical, virtual and cloud infrastructure from a single
we
e if I find
>> some time but feel free to beat me at it.
>
> I am quite busy myself at the moment, but I could try and see if I
> could craft something along that path...
>
> Rainer
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
lines of "begin" or
"begin work" etc. This should be easy to retrofit. I'lls see if I find
some time but feel free to beat me at it.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
e. I always get back error messages related to the mailing lists
when I check in changes. In any case, you can review the changes
through the web cvs frontend:
http://libdbi.cvs.sourceforge.net/viewvc/libdbi/libdbi/src/
The leak was fixed in dbd_helper.c which is now at 1.44.
regards,
Markus
--
th: --leak-check=full --show-reachable=yes
==3717==
==3717== For counts of detected and suppressed errors, rerun with: -v
==3717== Use --track-origins=yes to see where uninitialised values come from
==3717== ERROR SUMMARY: 289 errors from 1 contexts (suppressed: 48 from 8)
regards,
Markus
--
bug is fixed in
the cvs version which, by all means, ist tested, stable, and reliable.
I just won't have the time to finish a new release until September or
so. So if that leak really hurts you, you'd have to build libdbi and
libdbi-drivers from cvs.
regards,
Markus
--
code. dbi_initialize() is
supposed to be run once per process, so the following is more
appropriate:
int main() {
dbi_conn conn;
dbi_initialize(NULL);
while (1) {
[...]
}
dbi_shutdown();
return 0;
}
If it is indeed libdbi that leaks memory, it won't do so in every
c
results with any of the other
database drivers?
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a de
Vikram Ambrose writes:
> And here is an update to the patch for a third bug.
Better late than never ... I've applied your patch, and things seem to
work ok. Thanks for being this patient.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ
!
> no tables in statement !
How did you create the tables? Did you specify types for each column?
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
The ultimate all-in-one performance toolki
f your messages and patches yet. My dayjob currently eats all
available time (lest I stop sleeping entirely). I can't make any
promises, but I'll do my very best to return to my libdbi duties asap.
regards,
Markus
--
Markus Hoenicka
http:/
atforms which do not
provide their own dlopen() implementation. However, building libdbi as
a dynamic library uses libtool anyway, and it should be possible to
statically link a project against libdbi if desired without further
modifications.
regards,
Markus
--
Markus Hoenicka
http://www.m
ately from the
library. I can't judge though whether your idea is technically feasible.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
Protect Your Site and Customers from Malware Attac
are aware that this wouldn't work with arbitrary binary data.
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database
, all new and shiny 0.9.0 will be shipped real
soon now (TM). However, the Debian folks have suggested a bunch of
upstream patches which I'm inclined to include in the next release, so
don't hang on the edges of your seats.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka
e engines, except maybe the
embedded ones. Adding some code to the MySQL driver to fix your
original problem thus might be the wrong solution. Don't you
experience the same problems with other DB engines? In that case, we'd
have to fix li
l error message from libmysqlclient I'd say it's
doable. We'd just have to loop over a limited number of retries,
trying to reconnect each time before resending the query.
regards,
Markus
--
Markus Hoenicka
ould
release a new version after doing some minor cleanup. Unfortunately
I'm haunted by a couple of deadlines in the next couple of weeks, so
it is very uncertain whether I'll be able to finalize a release.
Needless to say, test reports using the current cvs version are always
welcome.
e behind the decision to deprecate the
old versions. Also, most applications will only have to define an
additional structure and pass an additional argument in three function
calls. Sanity doesn't always come that cheap.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenic
hutdown) are
now implemented on top of these functions, using a single static instance
handle.
HTH
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
Throughout its 18-year history, RSA Conference consistently at
Vikram Noel Ambrose was heard to say:
> By the way, the url for the source code repository is dead on the website.
Thanks for the heads up. I may have missed a SourceForge announcement
about restructuring their CVS servers.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
ING:
+ case FIELD_TYPE_STRING:
#ifdef FIELD_TYPE_NEWDECIMAL
case FIELD_TYPE_NEWDECIMAL: // Precision math DECIMAL or
NUMERIC field (MySQL 5.0.3 and up)
#endif
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
-
Markus Hoenicka writes:
> information. This check simply looks spurious to me:
>
> if(field->charsetnr == 63)
>
It probably isn't as wrong as I thought initially. MySQL gurus, please
correct me if I'm wrong, but I take the following from the manual:
The purpose of
information. This check simply looks spurious to me:
if(field->charsetnr == 63)
This looks more to me like a crutch than like an author having a
different opinion. Toby, isn't there a more foolproof check available
in the MySQL C API?
regards,
Markus
--
Markus Hoenicka
http
MySQL version are you running?
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the fi
Vikram Noel Ambrose writes:
> Either mysql is telling libdbi that the field is binary or libdbi is
> getting confused somewhere.
>
Could you please insert a call to dbi_result_get_field_type_idx() to
see what mysql thinks this is?
regards,
Markus
--
Markus Hoenicka
http://www.mho
> Has anyone else run into this?
I've never tried things like this. Which driver do you use?
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
Throughout its 18-year history, RSA C
zon-dev2dev
> _______
> libdbi-users mailing list
> libdbi-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/libdbi-users
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
d only. This would require
users to check integer fields manually, in a similar fashion as you
have to check for NULL values if this is relevant.
What do you think?
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
an atoll() implementation from MySQL back then,
which upon close inspection also turns out to be implemented via its
own strtoll(). Therefore switching from ato*() to strto*() should not
hurt.
> That being said, the only real test is empirical.
>
True indeed. I'll look
lity of the strto* functions? I recall we had to
add an implementation of atoll() to the libdbi sources to compile it
on at least one platform (I can't quite recall which one). Can we
expect that all platforms which are currently supported provide all
required strto*() functions?
regards,
Markus
--
Devin Reade was heard to say:
> Markus Hoenicka wrote:
>
>> To better deal with your shock: Could you please elaborate what's
>> wrong with atoll()?
>
> In the particular case of this use in libdbi, I've not looked at the
> code to see to what extent it
() is merely a wrapper around strtoll() anyways. So do you mind
the use of atoll() per se or the lack of a potentially necessary
discrimination between strtoll() and strtoull()?
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.
t to cast the return values
regardless of their original types. These might serve as last resorts
as well as the casting is done in a driver-specific manner.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
---
rm.
Thanks for the all-clear.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app
hey
might have fixed 64bit issues, if any. If they build from stock
sources, at least an unmodified homebuilt library should work ok.
regards,
Markus
--
Markus Hoenicka
http://www.mhoenicka.de
AQ score 38
-
s you have to do it in SQL, you
could then post-process this value using gmtime() or any other
suitable Unix time function.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds wi
field_type() and
dbi_result_get_field_attrib() to find out which type is returned?
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
sign decision back then as
it is too long ago to remember for sure. But in retrospect I feel what
you describe here offers users a choice of how to treat a single char.
Either as a tiny integer (CHAR) or as a one-byte text [CHAR(1)]. It is
probably best to keep this behaviour.
regards,
edirect.php?banner_id=100&url=/
> ___
> libdbi-users mailing list
> libdbi-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/libdbi-users
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupe
Quoting Toby Thain <[EMAIL PROTECTED]>:
>
> On 13-Oct-08, at 7:15 AM, Markus Hoenicka wrote:
>
>> Hi,
>>
>> just to clarify: it is sqlite, not the sqlite driver which does not
>> support newlines in SQL statements.
>
> Wow, that's inconve
st time I have seen newline characters explicitly
> embedded in an sql statement. Is there a reason that the newline
> characters are needed ?
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupe
November?) I'd like to know if anyone else would like to see
additional features in 1.0. What about your rewritten tests?
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadruped
ion.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
-
This SF.Net email is sponsored by the Moblin Your Move Develope
ns, simply change
"_dbi_internal_error_handler" to _dbd_internal_error_handler" in
dbd_sqlite3.c, around line 733.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with &quo
se provide some instructions how to do it? Thanks
>
> Peter Long.
> _
> See how Windows Mobile brings your life together—at home, work, or on the go.
> http://clk.atdmt.com/MRT/go/msnnkwxp1020093182mrt/direct/01/
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-p
ed the project with an excellent
design which still works as intended today.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
---
blem before the next release.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
-
Sponsored by: SourceForge.net Community
current code work with aliases and such,
I'll most likely be able to reuse this code with the new interface as
well.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
e at all. The last two functions return just about
anything as strings. Obviously these are merely workarounds in your
case, but they still may be helpful to get things done.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the qu
have a performance penalty that most apps want to avoid?
Maybe it's worthwhile to add a section about threading issues to the
programmer's guide? Being a non-expert myself, I'd greatly appreciate
contributions from those "in the know".
regards,
Markus
--
Markus Hoe
u would need to use something like "timeout" across all
> the drivers and have the SQLite3 driver alias this to the old
> property to maintain back compatibility.
>
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the
ed to use something like "timeout" across all
> the drivers and have the SQLite3 driver alias this to the old
> property to maintain back compatibility.
>
Yup. Should be available real soon now.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protec
sn't far either :-) Both the pgsql and mysql
drivers can be trivially retrofitted with a timeout option. I'll see
to it tomorrow. I'll also check if the other engines support a timeout
setting too, so we could use a general option to keep things simple.
regards,
Markus
--
Markus Ho
aware of cancellation. I'd
> personally find this a bit dangerous, given the third party nature of
> libdbi. IMHO the best option would be the caller handle the complexity.
> At least this is what I am doing in rsyslog (but, granted, cancellation
> happens very infrequently there,
; Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
> ___
> libdbi-users mailing list
> libdbi-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/lib
w feel you should rather use
the correct field type if you expect to store strings. But then, this
is just my opinion and I'm open for discussions.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrup
Markus Hoenicka writes:
> João Henrique Freitas writes:
> > How we will automatically convert the types into strings formats,
> > inside dbi_result_fget_string*?
> >
>
> Yes, this should happen within libdbi to make it independent of the
> drivers. We
this value. If the string does not represent a number,
strtoll() returns 0 and sets errno. We should return 0 as well and
report the conversion failure by setting the libdbi error status
appropriately which you can query by calling dbi_conn_error() if
necessary.
regards,
Markus
--
Markus H
Markus Hoenicka writes:
> char* dbi_result_fget_string_copy(dbi_result Result, const char*
> fieldname);
> char* dbi_result_fget_string_copy_idx(dbi_result Result, unsigned int
> fieldidx);
> int dbi_result_fbind_string_copy(dbi_result Result, const char*
> fieldn
ontain a
number) as long long integers which the calling function can cast to
whatever it needs.
Let me know if that would meet your needs.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds wit
to
libdbi? I'd be happy to help.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
-
This SF.net email is sponsored
our changes directly and make them available for other
developers.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
-
This SF.net
1 - 100 of 179 matches
Mail list logo