www.digitalmars.com         C & C++   DMDScript  

digitalmars.D - D vs MySQL5

reply KUV <KUV_member pathlink.com> writes:
When using existing MySQL binding with version 5, I get "segmentation fault"
error. Does anyone have module for working with this version?
Oct 02 2005
parent reply el.gato <forward_ua ukr.net> writes:
KUV Wrote:


 When using existing MySQL binding with version 5, I get "segmentation fault"
 error. Does anyone have module for working with this version?
 
 


i have the same problem :( but only when using threads and running about 10-20
concurrent connections (each thread with it's own connection to mysql) :(
Feb 22 2008
parent reply nobody <nobody web1.de> writes:
el.gato Wrote:


 KUV Wrote:
 

 When using existing MySQL binding with version 5, I get "segmentation fault"
 error. Does anyone have module for working with this version?
 
 


 
 i have the same problem :( but only when using threads and running about 10-20
concurrent connections (each thread with it's own connection to mysql) :(


Are you using DDBI or the mysql_binding from www.steinmole.de/d  ?
Have you an example for get the "segmentation fault" ?
Feb 24 2008
parent el.gato <forward_ua ukr.net> writes:
nobody Wrote:


 el.gato Wrote:
 

 KUV Wrote:
 

 When using existing MySQL binding with version 5, I get "segmentation fault"
 error. Does anyone have module for working with this version?
 
 


 
 i have the same problem :( but only when using threads and running about 10-20
concurrent connections (each thread with it's own connection to mysql) :(


 
 Are you using DDBI or the mysql_binding from www.steinmole.de/d  ?
 Have you an example for get the "segmentation fault" ?


I use DDBI, because mysql_binding works only with Phobos.

This might work as an example:

import  tango.core.Thread;

import  tango.net.http.HttpConst;

import  tango.util.log.Configurator;

import  mango.net.http.server.HttpServer,
        mango.net.http.server.HttpRequest,
        mango.net.http.server.HttpResponse,
        mango.net.http.server.HttpProvider;

import dbi.sqlite.SqliteDatabase;
import dbi.Row;

/*******************************************************************************

        Create a simple HttpServer, that responds with a trivial HTML page.
        The server listens on localhost:8080

*******************************************************************************/

void main ()
{
        // our simple http hander
        class Provider : HttpProvider
        {
                override void service (HttpRequest request, HttpResponse
response)
                {
                        MysqlDatabase db = new MysqlDatabase();
                       
db.connect("dbname=mysql;host=localhost;port=3306","root","");
                        db.close();
                        response.getOutputBuffer.append("<html>Hi
:-)</html>").flush;
                }
        }

        // bind server to port 8080 on a local address
        auto addr = new InternetAddress (8080);

        // create a (1 thread) server using the ServiceProvider to service
requests
        auto server = new HttpServer (new Provider, addr, 100, 100);

        // start listening for requests (but this thread does not listen)
        server.start;
}

This will start server on 8080 port, 100 threads, each thread connects and
disconnects from mysql, even nothing getting from it. Then run for example: ab
-c 100 -n 100 'http://localhost:8080/'
and you'll get segfault..

PS: dont have dmd compiler here, so the code might work, but i'm not sure:)
sorry
Feb 25 2008