libdbi-devel — Discussion about development of the core library and DBD interface

[libdbi-devel] Re: [libdbi-users] stupid question about nulls

[<m.e...@ls...>]

Like this? This seems to work for me, but I find it vaguely troubling
that the field size, which is an unsigned long long, is meant to be
negative...

dbd_pgsql.c.patch:
512a513
>                       row->field_sizes[curfield] = -1;

dbi_result.c.patch:
334a335,344
> unsigned short dbi_result_isnull(dbi_result Result, const char*
fieldname) {
>       unsigned long long size = dbi_result_get_field_size(Result,
fieldname);
>       return (size == -1) ? 1 : 0;
> }
> 
> unsigned short dbi_result_isnull_idx(dbi_result Result, unsigned short
idx) {
>       unsigned long long size = dbi_result_get_field_size_idx(Result,
idx);
>       return (size == -1) ? 1 : 0;
> }
> 


On Thu, 2004-07-29 at 17:43, Christian Stamgren wrote:
> Hello again,
> 
> Guess you are using the function 
> dbi_result_get_field_length( )   which today return size-1 for some reason.
> 
> You could use: 
> dbi_result_get_field_size( )  which returns the accual value. 
> 
> But I guess these functions would need to be tweaked to fit in with this new 
> behaviour. 
> The right (clean) way  of doing things would be to implement 
> dbi_result_field_isnull() or simular to check if a field is null.
> That way we could change the internals of libdbi without changing all 
> applications that was hacked to check if size was -1. It will also make it 
> more obvious what happens.   
> 
> Regards,
> 
> //Christian
> 
> 
> On Thursday 29 July 2004 15.14, m.e...@ls... wrote:
> > Thanks Christian! I didn't even think of looking at the length...
> >
> > I only have pqsql, but it looks as if for this one at least the length
> > is always 0 except for strings, where it is equal to the length of the
> > string (as you say it does not seem to implement what's in the comment).
> >
> > I tried implementing your suggestion myself in dbd_pgsql.c, and got as
> > far as
> >
> > 512a513
> >
> > >                       row->field_sizes[curfield] = -1;
> >
> > Unfortunately, now I get a length of -2 for NULLs???
> >
> > Maybe someone familiar with the driver could have a look at this? It
> > would be neat to be able to distinguish between NULL, "" and 0...
> >
> > Max
> >
> > On Thu, 2004-07-29 at 12:41, Christian Stamgren wrote:
> > > Hello.
> > >
> > > I belive this is a short comming of the libdbi-drivers as it looks today.
> > >
> > > By reading dbi-dev.h you will find this row part of dbi_row_t struct.:
> > >
> > > unsigned long long *field_sizes; /* NULL field = 0, string field = len,
> > > anything else = -1 */
> > >
> > > But the drivers does not implemet it this way.
> > >
> > >
> > > I'll suggest that we change it so that:
> > > NULL field = -1, string field = len, anything else = 0
> > >
> > > That way we will have distinction between NULL and a string of 0 chars
> > > (which is not the same as NULL).
> > >
> > > It would then be easy to implement a couple of funtions like:
> > >
> > > dbi_result_field_isnull(result, "fieldname");
> > > or
> > > dbi_result_field_isnull_idx(result, 2);
> > >
> > >
> > >
> > > Regards,
> > >
> > > //Christian
> > >
> > > On Wednesday 28 July 2004 15.45, m.e...@ls... wrote:
> > > > Hi,
> > > >
> > > > I have been running some queries that return NULLs at times (in fields
> > > > that contain doubles).
> > > >
> > > > It looks as if you use dbi_result_get_double() you get 0 whenever the
> > > > query returned a NULL.
> > > >
> > > > How can I distinguish between a NULL and 0? It looks like I might have
> > > > missed something obvious here...
> > > >
> > > > Thanks,
> > > >
> > > > Max
> > > >
> > > >
> > > > -------------------------------------------------------
> > > > This SF.Net email is sponsored by BEA Weblogic Workshop
> > > > FREE Java Enterprise J2EE developer tools!
> > > > Get your free copy of BEA WebLogic Workshop 8.1 today.
> > > > http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
> > > > _______________________________________________
> > > > libdbi-users mailing list
> > > > lib...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/libdbi-users
> 

[libdbi-devel] Re: [libdbi-users] stupid question about nulls

[Christian S. <chr...@ce...>]

Hello again,

Guess you are using the function 
dbi_result_get_field_length( )   which today return size-1 for some reason.

You could use: 
dbi_result_get_field_size( )  which returns the accual value. 

But I guess these functions would need to be tweaked to fit in with this new 
behaviour. 
The right (clean) way  of doing things would be to implement 
dbi_result_field_isnull() or simular to check if a field is null.
That way we could change the internals of libdbi without changing all 
applications that was hacked to check if size was -1. It will also make it 
more obvious what happens.   

Regards,

//Christian


On Thursday 29 July 2004 15.14, m.e...@ls... wrote:
> Thanks Christian! I didn't even think of looking at the length...
>
> I only have pqsql, but it looks as if for this one at least the length
> is always 0 except for strings, where it is equal to the length of the
> string (as you say it does not seem to implement what's in the comment).
>
> I tried implementing your suggestion myself in dbd_pgsql.c, and got as
> far as
>
> 512a513
>
> >                       row->field_sizes[curfield] = -1;
>
> Unfortunately, now I get a length of -2 for NULLs???
>
> Maybe someone familiar with the driver could have a look at this? It
> would be neat to be able to distinguish between NULL, "" and 0...
>
> Max
>
> On Thu, 2004-07-29 at 12:41, Christian Stamgren wrote:
> > Hello.
> >
> > I belive this is a short comming of the libdbi-drivers as it looks today.
> >
> > By reading dbi-dev.h you will find this row part of dbi_row_t struct.:
> >
> > unsigned long long *field_sizes; /* NULL field = 0, string field = len,
> > anything else = -1 */
> >
> > But the drivers does not implemet it this way.
> >
> >
> > I'll suggest that we change it so that:
> > NULL field = -1, string field = len, anything else = 0
> >
> > That way we will have distinction between NULL and a string of 0 chars
> > (which is not the same as NULL).
> >
> > It would then be easy to implement a couple of funtions like:
> >
> > dbi_result_field_isnull(result, "fieldname");
> > or
> > dbi_result_field_isnull_idx(result, 2);
> >
> >
> >
> > Regards,
> >
> > //Christian
> >
> > On Wednesday 28 July 2004 15.45, m.e...@ls... wrote:
> > > Hi,
> > >
> > > I have been running some queries that return NULLs at times (in fields
> > > that contain doubles).
> > >
> > > It looks as if you use dbi_result_get_double() you get 0 whenever the
> > > query returned a NULL.
> > >
> > > How can I distinguish between a NULL and 0? It looks like I might have
> > > missed something obvious here...
> > >
> > > Thanks,
> > >
> > > Max
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.Net email is sponsored by BEA Weblogic Workshop
> > > FREE Java Enterprise J2EE developer tools!
> > > Get your free copy of BEA WebLogic Workshop 8.1 today.
> > > http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
> > > _______________________________________________
> > > libdbi-users mailing list
> > > lib...@li...
> > > https://lists.sourceforge.net/lists/listinfo/libdbi-users

[libdbi-devel] Re: [libdbi-users] stupid question about nulls

[<m.e...@ls...>]

Thanks Christian! I didn't even think of looking at the length...

I only have pqsql, but it looks as if for this one at least the length
is always 0 except for strings, where it is equal to the length of the
string (as you say it does not seem to implement what's in the comment).

I tried implementing your suggestion myself in dbd_pgsql.c, and got as
far as

512a513
>                       row->field_sizes[curfield] = -1;

Unfortunately, now I get a length of -2 for NULLs???

Maybe someone familiar with the driver could have a look at this? It
would be neat to be able to distinguish between NULL, "" and 0...

Max



On Thu, 2004-07-29 at 12:41, Christian Stamgren wrote:
> Hello.
> 
> I belive this is a short comming of the libdbi-drivers as it looks today. 
> 
> By reading dbi-dev.h you will find this row part of dbi_row_t struct.:
> 
> unsigned long long *field_sizes; /* NULL field = 0, string field = len, 
> anything else = -1 */
> 
> But the drivers does not implemet it this way. 
> 
> 
> I'll suggest that we change it so that:
> NULL field = -1, string field = len, anything else = 0
> 
> That way we will have distinction between NULL and a string of 0 chars (which 
> is not the same as NULL).
> 
> It would then be easy to implement a couple of funtions like: 
> 
> dbi_result_field_isnull(result, "fieldname");
> or 
> dbi_result_field_isnull_idx(result, 2);
> 
> 
> 
> Regards, 
> 
> //Christian
> 
> 
> 
> On Wednesday 28 July 2004 15.45, m.e...@ls... wrote:
> > Hi,
> >
> > I have been running some queries that return NULLs at times (in fields
> > that contain doubles).
> >
> > It looks as if you use dbi_result_get_double() you get 0 whenever the
> > query returned a NULL.
> >
> > How can I distinguish between a NULL and 0? It looks like I might have
> > missed something obvious here...
> >
> > Thanks,
> >
> > Max
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by BEA Weblogic Workshop
> > FREE Java Enterprise J2EE developer tools!
> > Get your free copy of BEA WebLogic Workshop 8.1 today.
> > http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
> > _______________________________________________
> > libdbi-users mailing list
> > lib...@li...
> > https://lists.sourceforge.net/lists/listinfo/libdbi-users
> 

[libdbi-devel] Re: [libdbi-users] stupid question about nulls

[Christian S. <cm...@ce...>]

Hello.

I belive this is a short comming of the libdbi-drivers as it looks today. 

By reading dbi-dev.h you will find this row part of dbi_row_t struct.:

unsigned long long *field_sizes; /* NULL field = 0, string field = len, 
anything else = -1 */

But the drivers does not implemet it this way. 


I'll suggest that we change it so that:
NULL field = -1, string field = len, anything else = 0

That way we will have distinction between NULL and a string of 0 chars (which 
is not the same as NULL).

It would then be easy to implement a couple of funtions like: 

dbi_result_field_isnull(result, "fieldname");
or 
dbi_result_field_isnull_idx(result, 2);



Regards, 

//Christian



On Wednesday 28 July 2004 15.45, m.e...@ls... wrote:
> Hi,
>
> I have been running some queries that return NULLs at times (in fields
> that contain doubles).
>
> It looks as if you use dbi_result_get_double() you get 0 whenever the
> query returned a NULL.
>
> How can I distinguish between a NULL and 0? It looks like I might have
> missed something obvious here...
>
> Thanks,
>
> Max
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by BEA Weblogic Workshop
> FREE Java Enterprise J2EE developer tools!
> Get your free copy of BEA WebLogic Workshop 8.1 today.
> http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
> _______________________________________________
> libdbi-users mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libdbi-users

[libdbi-devel] Firebird/Interbase Driver in cvs.

[Christian M. S. <cm...@ce...>]

Hello list,=20

I have commited a Firebird/Interbase (firebird.sourceforge.net)
driver to libdbi-drivers cvs.
Its mostly operational, everything except the sequencing API should work.=20

There seems to be some errors with the cvs notification email program so th=
ere=20
haven't been any email sent to libdbi-drivers-cvs list (at least not that I=
=20
noticed).=20


Have fun,

=2D-=20
Christian M. Stamgren | COO; Head of development
Direct: +46 (0)8-410 446 01 | Mobile: +46 (0)708-50 74 01
E-mail: cm...@ce...
=20
Cention AB | PO Box 3326 | S-103 66 Stockholm | Sweden
Visiting address: Geijersv=E4gen 24 | S-112 44 Stockholm
Phone: +46 (0)8-410 446 00 | Fax: +46 (0)8-656 49 00

[libdbi-devel] FASD project: Online survey launched

[<ben...@id...>]

Dear Open Source developer

I am doing a research project on "Fun and Software Development" in which I kindly invite you to participate.
You will find the online survey under http://fasd.ethz.ch/qsf/. The questionnaire consists of 53 questions and you will need about 15 minutes to complete it.

With the FASD project (Fun and Software Development) we want to define the motivational significance of fun when software developers decide to engage in Open Source projects. What is special about our research project is that a similar survey is planned with software developers in commercial firms. This procedure allows the immediate comparison between the involved individuals and the conditions of production of these two development models. Thus we hope to obtain substantial new insights to the phenomenon of Open Source Development.


With many thanks for your participation,
Benno Luthiger


PS:
The results of the survey will be published under http://www.isu.unizh.ch/fuehrung/blprojects/FASD/.
We have set up the mailing list fa...@we... for this study. Please see http://fasd.ethz.ch/qsf/mailinglist_en.html for registration to this mailing list.

_______________________________________________________________________

Benno Luthiger
Swiss Federal Institute of Technology Zurich
8092 Zurich

Mail: benno.luthiger(at)id.ethz.ch
_______________________________________________________________________

[libdbi-devel] big feature requests

[Markus H. <mar...@mh...>]

Hi Andrew,

could you be a little more specific about what functions you have in
mind and how you retrieve this information from PostgreSQL? I'd like
to have a look whether the other database engine can supply this
information.

regards,
Markus

Andrew Hill writes:
 > just been going over libdbi and it looks very nice but i want to make 
 > some big feature requests. I'm being a bit greedy i know. sorry. I can 
 > help and provide code for postgresql but i not very familure with mysql 
 > and how to do it in that or the other databases.  And I dont even know 
 > if you would want such features to be supported. 
 > 
 > I'd like to be able to know more details and attributes of fields.
 > default value of a field, be it a function or a value.   nice to know if 
 > it is a function or a  value.
 > if its indexed or not.
 > if its a primary key.
 > if it is a char, what is string limit for storing in database.
 > if it has any constraints/forign relationships to another table and field.
 > if there is any comments made on the field.
 > 
 > General db stuff.
 > list all views in a database
 > 

-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

[libdbi-devel] some big feature requests

[Dru <an...@tr...>]

just been going over libdbi and it looks very nice but i want to make 
some big feature requests. I'm sorry for just out right asking this,
I'm being a bit greedy i know. I can help and do all the code for 
postgresql but i not very familure with mysql and how to do it in that 
or the other databases.  And I dont even know if you would want such 
features to be supported.
I'd like to be able to know more details and attributes of fields.

- default value of a field, be it a function or a value.   nice to know 
if it is a function or a  value.
- if its indexed or not.
- if its a primary key.
- if it is a char, what is string limit for storing in database.
- if it has any constraints/forign relationships to another table and field.
- if there is any comments made on the field.

This stuff is all retrievable from postgresql, though it varies from 
postgresql verisons.  if the database doesnt support it we could ask for
it to be supported.

General db stuff.
- when you do an insert, get the id or oid of the record just inserted. 
mysql and postgresql have a function in standard api for this.
- list all views in a database

[libdbi-devel] big feature requests

[Andrew H. <dr...@tr...>]

just been going over libdbi and it looks very nice but i want to make 
some big feature requests. I'm being a bit greedy i know. sorry. I can 
help and provide code for postgresql but i not very familure with mysql 
and how to do it in that or the other databases.  And I dont even know 
if you would want such features to be supported. 

I'd like to be able to know more details and attributes of fields.
default value of a field, be it a function or a value.   nice to know if 
it is a function or a  value.
if its indexed or not.
if its a primary key.
if it is a char, what is string limit for storing in database.
if it has any constraints/forign relationships to another table and field.
if there is any comments made on the field.

General db stuff.
list all views in a database

Re: [libdbi-devel] Cygwin packages

[Markus H. <mar...@mh...>]

David Parker writes:
 > On Wed, 18 Feb 2004 23:08:49 +0100, Markus Hoenicka wrote:
 > 
 > > I'm not sure
 > > whether I have the access rights to fiddle with the libdbi web
 > > page. Would you please add the tarballs and a link to the libdbi web
 > > page?
 > 
 > Done, they are in http://libdbi.sf.net/downloads/
 > Sorry for the lag... I think the website dir is group writable, so it should
 > work from your account(?)
 > 

I'll try next time. Thanks anyway for lending me a hand this time.

regards,
Markus

-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

Re: [libdbi-devel] Cygwin packages

[David P. <da...@ne...>]

On Wed, 18 Feb 2004 23:08:49 +0100, Markus Hoenicka wrote:

> I'm not sure
> whether I have the access rights to fiddle with the libdbi web
> page. Would you please add the tarballs and a link to the libdbi web
> page?

Done, they are in http://libdbi.sf.net/downloads/
Sorry for the lag... I think the website dir is group writable, so it should
work from your account(?)

David

--
David Parker <da...@ne...>
Neon Goat Productions
http://www.neongoat.com

[libdbi-devel] Cygwin packages

[Markus H. <mar...@mh...>]

Hi David,

Michael Smith was kind enough to provide binary Cygwin packages of
libdbi and libdbi-drivers (containing the PostgreSQL driver, as this
is the only officially packaged SQL engine for Cygwin). I'm not sure
whether I have the access rights to fiddle with the libdbi web
page. Would you please add the tarballs and a link to the libdbi web
page? The tarballs are available here:

http://www.logopoeia.com/refdb/

Thanks
Markus

-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

Re: [libdbi-devel] troubles

[David P. <da...@ne...>]

On Wed, 21 Jan 2004 19:08:29 +0200, Subredu Manuel wrote:

>  using if ( !dbi_conn_ping() ) reconnect seems to work very well. 

... which raises the question, would it be a good idea for libdbi to have an
"auto-reconnect" option available to each dbi_conn that performs this behavior
automatically? It would be easy enough to add, and the only overhead is
checking the value of that option on each query-related function call.

David

-------
David Parker <da...@ne...>
Neon Goat Productions
http://www.neongoat.com
0xF90FFFE5 / F362 51F7 6D51 85EB AF68 75B9 D29B 1AFC F90F FFE5
-------

Re: [libdbi-devel] troubles

[Markus H. <mar...@mh...>]

David Parker writes:
 > ... which raises the question, would it be a good idea for libdbi to have an
 > "auto-reconnect" option available to each dbi_conn that performs this behavior
 > automatically? It would be easy enough to add, and the only overhead is
 > checking the value of that option on each query-related function call.
 > 

Sounds good to me.

regards,
Markus

-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

Re: [libdbi-devel] troubles

[Subredu M. <di...@ia...>]

On Tue, Jan 20, 2004 at 10:13:44PM +0100, Markus Hoenicka wrote:

> I'm not exactly the MySQL expert on this list, but I think this is why
> we've added the dbi_conn_ping() function. It is not documented yet,
> but the usage should be pretty obvious from the libdbi sources. All
> you'd have to do is to ping the server before issuing the query that
> crashes your app currently. If the server does not reply, open a new
> connection.
>=20
> regards,
> Markus

 using if ( !dbi_conn_ping() ) reconnect seems to work very well.=20

--=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
 inf. Manuel SUBREDU
 Network Engineer at RoEduNet Iasi

 Phone:     +40 (232) 201003
            +40 (742) 088067
 Email:     di...@ia...
 website:   http://manuel.iasi.roedu.net
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

[libdbi-devel] troubles

[Markus H. <mar...@mh...>]

 > is this a libdbi problem or a mysql problem ? As far as I can tell, it
 > happens like this:
 >  * program opens connection to mysql server and leaves it open
 >  * mysql server is timeout -ing and closing the connection
 >  * program needs to query mysql server using already opened connection
 >  * libdbi tryies to write to the connection he knew is opened and a SIGPIPE
 > is raised.
 >  * nobody's happy :(

 > Can you give me a solution with this one ? Besides modifications in the
 > program to open/close connections. 

I'm not exactly the MySQL expert on this list, but I think this is why
we've added the dbi_conn_ping() function. It is not documented yet,
but the usage should be pretty obvious from the libdbi sources. All
you'd have to do is to ping the server before issuing the query that
crashes your app currently. If the server does not reply, open a new
connection.

regards,
Markus

-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

[libdbi-devel] troubles

[Subredu M. <di...@ia...>]

 Hi,

 I'm have some troubles with libdbi + mysql . I have a C program for
detecting floods. When the program starts, his open a connection to a mysql
database (on another machine) take some data from there, and leaves the
connection opened. After some time (>6 hours) when the program needs to
interogate the database, it crashes. I've run the program inside a gdb. This
is the output of a bt command in gdb

Program received signal SIGPIPE, Broken pipe.
0x420d6fd8 in write () from /lib/i686/libc.so.6
(gdb) bt
#0  0x420d6fd8 in write () from /lib/i686/libc.so.6
#1  0x40200c3c in _db_process_ () from /usr/lib/mysql/libmysqlclient.so.10
#2  0x401d76da in net_real_write () from /usr/lib/mysql/libmysqlclient.so.10
#3  0x401d73e8 in net_flush () from /usr/lib/mysql/libmysqlclient.so.10
#4  0x401d7586 in net_write_command () from /usr/lib/mysql/libmysqlclient.s=
o.10
#5  0x401d3814 in simple_command () from /usr/lib/mysql/libmysqlclient.so.10
#6  0x401d5c50 in mysql_real_query () from /usr/lib/mysql/libmysqlclient.so=
.10
#7  0x401d59e5 in mysql_query () from /usr/lib/mysql/libmysqlclient.so.10
#8  0x4001da0b in dbd_query () from /usr/lib/dbd/libmysql.so
#9  0x4002424e in dbi_conn_query () from /usr/lib/libdbi.so.0
#10 0x08052960 in query (q=3D0xbfffa7c0 "select * from tbl_filtre where f_i=
p_src=3D'192.168.0.1' and f_ip_dst=3D'0.0.0.0' and f_end_time > 1074514239"=
, want_result=3D1)
    at database.c:127
#11 0x0804cade in oldFilterExists (response=3D0x4005c4e0) at zazu.c:1683
#12 0x0804d95f in mail_flow (response=3D0x4005c4e0) at zazu.c:2022
#13 0x0804f70c in analyze (header_buff=3D0xbfffb0a0 "", flow_buff=3D0xbfffb=
0b8 "\23\006\213\2273\204\214=D9I=A0E") at zazu.c:2746
#14 0x0804f81c in display_nfe (buff=3D0xbfffb0a0 "", buff_len=3D1464) at za=
zu.c:2814
#15 0x080505e3 in main (argc=3D4, argv=3D0xbffff104) at zazu.c:3290
#16 0x42015967 in __libc_start_main () from /lib/i686/libc.so.6

(gdb) select-frame 10
(gdb) list 127
122         dbi_result result;
123
124         if ( conn =3D=3D NULL )
125             return NULL;
126
127         result =3D dbi_conn_query(conn,q);
128
129         if ( result =3D=3D NULL)
130         {
131             return NULL;
(gdb) print conn
$1 =3D 0x809eb88
(gdb) print result
$2 =3D (void *) 0x40013020


The versions are:

 RedHat 8.0 (updated)

 libdbi-drivers-dbd-pgsql-0.7.1-1
 libdbi-devel-0.7.2-1
 libdbi-drivers-dbd-mysql-0.7.1-1
 libdbi-0.7.2-1

 mysql-devel-3.23.58-1.80
 mysql-3.23.58-1.80
 mysql-server-3.23.58-1.80

gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7)

Linux some.com 2.4.20-18.8 #1 Thu May 29 08:57:39 EDT 2003 i686 i686 i386 G=
NU/Linux

is this a libdbi problem or a mysql problem ? As far as I can tell, it
happens like this:
 * program opens connection to mysql server and leaves it open
 * mysql server is timeout -ing and closing the connection
 * program needs to query mysql server using already opened connection
 * libdbi tryies to write to the connection he knew is opened and a SIGPIPE
is raised.
 * nobody's happy :(

Can you give me a solution with this one ? Besides modifications in the
program to open/close connections.=20


PS: Please include me in Cc when reply, because I'm not subscribed to the
list
=20
     many thanks in advance.

--=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
 inf. Manuel SUBREDU
 Network Engineer at RoEduNet Iasi

 Phone:     +40 (232) 201003
            +40 (742) 088067
 Email:     di...@ia...
 website:   http://manuel.iasi.roedu.net
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

[libdbi-devel] ANN: libdbi-0.7.2 released

[David P. <da...@ne...>]

libdbi-0.7.2 is released! Downloads and more info at
http://libdbi.sourceforge.net

You'll probably also want to grab new drivers from the libdbi-drivers
project, http://libdbi-drivers.sourceforge.net

Thank you to all who hack on the project, your efforts are always
appreciated.

ChangeLog:

        * release 0.7.2 (the "Shoshified" release)
        * time_t values are now returned in GMT, not local time
        * added encoding accessor
        * added read-only string quoting function
        * added range checking functions
        * fixed various corner-case bugs

David

-------
David Parker <da...@ne...>
Neon Goat Productions
http://www.neongoat.com
0xF90FFFE5 / F362 51F7 6D51 85EB AF68 75B9 D29B 1AFC F90F FFE5
-------

[libdbi-devel] Re: [Libdbi-drivers-devel] yet another delay (related to cygwin)

[David P. <da...@ne...>]

On Wed, 14 Jan 2004 21:45:38 +0100, Markus Hoenicka wrote:

> In any case, today's tests were successful. Much to my delight SQLite
> now also works on Cygwin, which gives Cygwin users some choice
> too. I've made some small additions to the Win32 Makefile and README
> which reflect this change.
> 
> I'm done with fixing things and testing. As David's packages work on
> all systems so far, I'd suggest to repackage the current CVS versions
> on his box and release them asap. David, do you want to do this or
> would you like me to release the libdbi-drivers?

Great, I can package both at the same time, no worries. I'll do that tonight
or tomorrow late afternoon.

David

-------
David Parker <da...@ne...>
Neon Goat Productions
http://www.neongoat.com
0xF90FFFE5 / F362 51F7 6D51 85EB AF68 75B9 D29B 1AFC F90F FFE5
-------

[libdbi-devel] [Libdbi-drivers-devel] yet another delay (related to cygwin)

[Markus H. <mar...@mh...>]

Markus Hoenicka writes:
 > Ok, I've added the gmtime() implementation. Please hang on until I've
 > tested that on Cygwin too. I'll do that tomorrow first thing in the
 > morning.
 > 

Of course all this fuss was about timegm() (which newlib doesn't
have), not about gmtime(which newlib does have). Sorry for the
confusion.

In any case, today's tests were successful. Much to my delight SQLite
now also works on Cygwin, which gives Cygwin users some choice
too. I've made some small additions to the Win32 Makefile and README
which reflect this change.

I'm done with fixing things and testing. As David's packages work on
all systems so far, I'd suggest to repackage the current CVS versions
on his box and release them asap. David, do you want to do this or
would you like me to release the libdbi-drivers?

regards,
Markus

-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

[libdbi-devel] [Libdbi-drivers-devel] yet another delay (related to cygwin)

[Markus H. <mar...@mh...>]

Markus Hoenicka writes:
 > Hi,
 > 
 > today I had a chance to run a quick test on a Windoze box. Needless to
 > say that my recent change in the datetime stuff (localtime vs UTC)
 > broke libdbi on Cygwin. I'll have to add an implementation of gmtime()
 > (which Cygwin's newlib lacks) and fiddle with the configure script
 > accordingly. I hope I'll get this done tonight.

Ok, I've added the gmtime() implementation. Please hang on until I've
tested that on Cygwin too. I'll do that tomorrow first thing in the
morning.

regards,
Markus

-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

Re: [libdbi-devel] Re: [Libdbi-drivers-devel] test builds available

[David P. <da...@ne...>]

Markus Hoenicka <mar...@mh...> said:

> David Parker writes:
>  > http://libdbi.sourceforge.net/downloads/libdbi-0.7.2-dap_1.tar.gz
>  > http://libdbi.sourceforge.net/downloads/libdbi-drivers-0.7.1-
dap_1.tar.gz
> These work ok for me on a FreeBSD 4.7 box. Things would be easier
> though if the tarballs were world-readable on the server...

Sorry about that, the above URLs should now work properly.

David

-------
David Parker <da...@ne...>
Neon Goat Productions
http://www.neongoat.com
0xF90FFFE5 / F362 51F7 6D51 85EB AF68 75B9 D29B 1AFC F90F FFE5
-------

[libdbi-devel] Re: [Libdbi-drivers-devel] test builds available

[Markus H. <mar...@mh...>]

David Parker writes:
 > http://libdbi.sourceforge.net/downloads/libdbi-0.7.2-dap_1.tar.gz
 > http://libdbi.sourceforge.net/downloads/libdbi-drivers-0.7.1-dap_1.tar.gz
 > 

These work ok for me on a FreeBSD 4.7 box. Things would be easier
though if the tarballs were world-readable on the server...

regards,
Markus
-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

[libdbi-devel] yet another delay (related to cygwin)

[Markus H. <mar...@mh...>]

Hi,

today I had a chance to run a quick test on a Windoze box. Needless to
say that my recent change in the datetime stuff (localtime vs UTC)
broke libdbi on Cygwin. I'll have to add an implementation of gmtime()
(which Cygwin's newlib lacks) and fiddle with the configure script
accordingly. I hope I'll get this done tonight.

regards,
Markus

-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

[libdbi-devel] Re: [Libdbi-drivers-devel] test builds available

[David P. <da...@ne...>]

On Mon, 12 Jan 2004 12:07:55 -0800, David Parker wrote:

> Last time packaging libdbi-drivers there were problems (probably)
> because of a weird combination of libtool/automake/autoconf versions. The
> libtool stuff was hardcoding RPATHs into compiled code even when told not to.

Sorry to delay things, but the same problems with RPATH are still happeneing.
It's probably something specific to the FreeBSD version of libtool and
friends. I re-autogen'd both packages on a linux box with libtool 1.5.0a,
tarballs are here:

http://libdbi.sourceforge.net/downloads/libdbi-0.7.2-dap_1.tar.gz
http://libdbi.sourceforge.net/downloads/libdbi-drivers-0.7.1-dap_1.tar.gz

Let me know how these work out...

David

-------
David Parker <da...@ne...>
Neon Goat Productions
http://www.neongoat.com
0xF90FFFE5 / F362 51F7 6D51 85EB AF68 75B9 D29B 1AFC F90F FFE5
-------