Re: [gnome-db] GDA: segfault!!! (what did I do wrong???)

[Neil Zanella <nzanella gmail com>]

Hello,

I ran a backtrace and the problem seemed to be in glib. After that, my
postgresql
server simply won't start (maybe the postgresql provider broke
something). So now
I am using the same code with the mysql provider and it works fine.
Rodrigo, thanks
for letting me know about the backtrace stuff.

My problem now is that my create table statements don't work with mysql 3
(because mysql 3 doesn't get CHECK and ON UPDATE statements etc...,
so I'm getting version 4.1 of mysql, and then we'll see. BTW, given that
libgda is middleware, I should be able to provide libgda with those
statements and libgda would take care of say, when I have a
cascade statement, carrying out the cascade for me even
when mysql doesn't support it right?

Sorry I can't issue a proper bug report. As I said, postgresql won't start
from the /etc/init.d/postgresql start any more, but maybe that was my
own fault cause of some other stupid thing I did.

Thank you for explaining,

I'd like to grasp whether libgda is intended to "transform" my "standard SQL"
statements into "vendor-specific SQL" statements.

Thanks,

Neil

On Wed, 10 Nov 2004 13:14:51 +0100, Rodrigo Moya <rodrigo gnome-db org> wrote:
> On Tue, 2004-11-09 at 21:28 -0700, Neil Zanella wrote:
> 
> 
> > I don't have a semicolon at the end of my query cause it's not part of
> > SQL, and it's
> > a simple SELECT joe FROM Doe type query. Here is the code. INSERT works fine,
> > now I need to retrieve some data and that's just about all I'm going
> > to need from the
> > GDA library. So here is the code. It segfaults, and I want to know why.
> >
> > Thanks,
> >
> > Neil
> >
> > --------------------------------------------------------------------------------
> >
> > GdaCommand *cmd = gda_command_new(query,
> >   GDA_COMMAND_TYPE_SQL, GDA_COMMAND_OPTION_STOP_ON_ERRORS);
> >
> > GdaDataModel *dm;
> >
> > dm = gda_connection_execute_single_command(cnc, cmd, NULL);
> >
> > g_assert(dm != NULL);
> >
> > fprintf(stdout, "hello!!!\n");
> > fprintf(stdout, "hello %d\n", gda_data_model_get_n_rows(dm));
> > fflush(stdout);
> >
> > --------------- output:
> >
> > hello!!!
> > segfault
> > 
> run your program in gdb abd get a backtrace when it crashes (command
> 'bt' in (gdb) prompt.
> --
> Rodrigo Moya <rodrigo gnome-db org>
>