[gnome-db] loading sqlite extensions with gda?

"Leibowitz, Michael" <[email protected]>
Newsgroups gmane.comp.gnome.db
Message-ID <CAB-iPKXo2D7K7umF2fK3q10j3owhWJTcW7TgecK8MFQL4G3WCA@mail.gmail.com>
Hi,

I'm trying to use the spatialite plugin to sqlite3 through gda (gdamm,
actually), without much luck.  I'm trying to load the plugin as
follows:

  _connection->statement_execute_select(
      "SELECT load_extension('libspatialite.so.2')");

I don't get an error with that (it doesn't throw, at least), but the
next line throws:
   _connection->statement_execute_select("SELECT InitSpatialMetadata()");
I get a "no such function" message in the error.

Is it possible to load extensions into sqlite3 this way?  Is there
another way?  Am I doing something obviously wrong?  Why don't I get
an error from the SELECT load_extension?

Version info (ubuntu 11.04 packaged versions):
$ pkg-config --modversion libgdamm-4.0
4.1.1
$ pkg-config --modversion sqlite3
3.7.4

Thanks

-- 
Michael Leibowitz
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.