Hi! I'll check your problem this afternoon. BTW, which version of Libgda do you use?
Regards, Vivien On 18 January 2013 09:44, David Régade <[email protected]> wrote: > Hi, > > I try to use gda to connect to a mysql database. I used SimpleExample > found in samples directory and changed dsn to match my needs. > This is only a connect/disconnect loop. > Here is the code: > > > #include <glib-object.h> > #include <glib/gprintf.h> > > #include <libgda/libgda.h> > #include <sql-parser/gda-sql-parser.h> > > #include <unistd.h> > > GdaConnection *open_connection( void ); > > int main( int argc, char *argv[] ) { > int i = 0; > gda_init( ); > GdaConnection *cnc; > > for(i = 0; i<atoi(argv[1]); i++) { > cnc = open_connection( ); > gda_connection_close( cnc ); > > g_object_unref( cnc ); > } > return 0; > } > > /* > * Open a connection to the example.db file > */ > GdaConnection *open_connection( ) { > GdaConnection *cnc; > GError *error = NULL; > GdaSqlParser *parser; > > /* open connection */ > cnc = gda_connection_open_from_**string( "MySQL", "DB_NAME=viewbox", > "USERNAME=user;PASSWORD=pass",**GDA_CONNECTION_OPTIONS_READ_**ONLY, > &error ); > > if( !cnc ) { > g_print( "Could not open connection database: %s\n", > error && error->message ? error->message : "No detail" ); > exit( 1 ); > } > > /* create an SQL parser */ > parser = gda_connection_create_parser( cnc ); > if( !parser ) /* @cnc doe snot provide its own parser => use default > one */ > parser = gda_sql_parser_new( ); > /* attach the parser object to the connection */ > g_object_set_data_full( G_OBJECT( cnc ), "parser", parser, > g_object_unref ); > > return cnc; > } > > > There is no problem with sqlite but memory usage with mysql provider > always increase (thanks to valgrind). > Is there any problem wth this piece of code ? > > Regards > ______________________________**_________________ > gnome-db-list mailing list > [email protected] > https://mail.gnome.org/**mailman/listinfo/gnome-db-list<https://mail.gnome.org/mailman/listinfo/gnome-db-list> >
_______________________________________________ gnome-db-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnome-db-list
