Sqlite3 problem

[Jaco]

Hi,

After a serious struggle to get Lazarus up and running on a MacOS 10.5, I tried to compile a tiny test application I made in Lazarus for Windows, using a Sqlite3 database.
The project fails to compile with a long list of "Undefined symbols", like:
Undefined symbols:
  "_sqlite3_exec", referenced from:     SQLITE3DS_TSQLITE3DATASET_$__SQLITEEXEC$PCHAR$TSQLITECDECLCALLBACK$POINTER$$LONGINT in sqlite3ds.o


Does anyone have a suggestion how to solve this problem?

Thanks, from a Mac newbie

Jaco

[Phil]

The project fails to compile with a long list of "Undefined symbols", like:
Undefined symbols:
  "_sqlite3_exec", referenced from:     SQLITE3DS_TSQLITE3DATASET_$__SQLITEEXEC$PCHAR$TSQLITECDECLCALLBACK$POINTER$$LONGINT in sqlite3ds.o

What version and build of FPC are you using?

Where are your sqlite3 client libraries located on your Mac? You'll need to link against them. I don't have any experience with sqlite3 but looking at FPC's sqlite.pp I see that it uses an external library for sqlite_exec and other functions. This library is probably named libsqlite.dylib on your Mac.

Thanks.

-Phil

[Jaco]

FPC is 2.2.0, from an image a couple of days ago.
I found a file named libsqlite3.0.dylib
in /usr/lib/
with an alias named libsqlite3.dylib
Would it be sufficient to copy this library to, e.g., my application's directory?

Thanks,

Jaco

[Phil]

FPC is 2.2.0, from an image a couple of days ago.
I found a file named libsqlite3.0.dylib
in /usr/lib/
with an alias named libsqlite3.dylib

Leave the files where they are and add /usr/lib to Libraries in Compiler Options. If you're compiling from a script, use the -Fl/usr/lib switch for FPC. See if that helps the linker find the libraries.

Did you install these libraries? I'm not at my Mac right now so I don't know if these are included with OS X or not. This will determine whether you need to distribute the .dylib files with your app or not.

Thanks.

-Phil

[Jaco]

OK, I got it working by adding a {$linklib sqlite3.dylib} statement in the sqlite3.pp file, an copying the sqlite* files to my project directory. Maybe not worth a beauty contest, but at least it works.
Thanks for pointing me into the direction of the dylib.

[Phil]

OK, I got it working by adding a {$linklib sqlite3.dylib} statement in the sqlite3.pp file, an copying the sqlite* files to my project directory. Maybe not worth a beauty contest, but at least it works.
Thanks for pointing me into the direction of the dylib.

I was confused when I wrote that. Yes, when the library is specified with "external", you need to include $linklib with OS X. See how they did it in FPC's gtk.pp.

I think you should file a bug report for this, so that somebody adds $linklib to sqlite3.pp with $IFDEF for Darwin the way it's done in gtk.pp.

I believe that libsqlite3.dylib is included with OS X. You can maybe do some googling to verify this. What that means is that you won't have to distribute it with your app. I believe FPC includes /usr/lib when it passes switches to the linker so it should still work without copying the .dylib to your project's folder - or maybe you're only copying the source files. Let me know if this works with the .dylib in /usr/lib.

Thanks.

-Phil

[bobyuan]

OK, I got it working by adding a {$linklib sqlite3.dylib} statement in the sqlite3.pp file, an copying the sqlite* files to my project directory. Maybe not worth a beauty contest, but at least it works.
Thanks for pointing me into the direction of the dylib.

Where did you find the sqlite3.pp file? I met the same problem but have no clue to find the sqlite3.pp file. Please help!

thanks in advance.
bob

[Jonas Maebe]

OK, I got it working by adding a {$linklib sqlite3.dylib} statement in the sqlite3.pp file, an copying the sqlite* files to my project directory. Maybe not worth a beauty contest, but at least it works.
Thanks for pointing me into the direction of the dylib.

Where did you find the sqlite3.pp file? I met the same problem but have no clue to find the sqlite3.pp file. Please help!

You can also add that linklib directive to your main program source file, it will have the same effect.

[bobyuan]

You can also add that linklib directive to your main program source file, it will have the same effect.

I was trying to install the package of sqlite3laz. I don't have a project to run.

[Jonas Maebe]

You can also add that linklib directive to your main program source file, it will have the same effect.

I was trying to install the package of sqlite3laz. I don't have a project to run.

The problem described above was fixed in FPC 2.2.4. You should not have to add this linklib statement anywhere anymode.

[bobyuan]

You can also add that linklib directive to your main program source file, it will have the same effect.

I was trying to install the package of sqlite3laz. I don't have a project to run.

The problem described above was fixed in FPC 2.2.4. You should not have to add this linklib statement anywhere anymode.

I installed 2.2.4 fpc, fpc src and lazarus (lazarus is 2.2.4 20748 build). When I tried to install sqlite3.laz under Developer/Lazarus/Components/sqlite, same error message.

Anyone can provide some hint to help me install SQLite3 packages?

thanks.

[Hinnack]

I do have th same problem with lazarus from svn trunk and fpc 2.2.4

on recompiling the IDE I get:

Undefined symbols:
  "_sqlite3_prepare", referenced from:
      _SQLITE3DS_TSQLITE3DATASET_$__INTERNALGETHANDLE$$POINTER in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__EXECUTEDIRECT$ANSISTRING in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__BUILDLINKEDLIST in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRING in sqlite3ds.o
  "_sqlite3_errmsg", referenced from:
      _SQLITE3DS_TSQLITE3DATASET_$__INTERNALGETHANDLE$$POINTER in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__RETURNSTRING$$ANSISTRING in sqlite3ds.o
  "_sqlite3_column_decltype", referenced from:
      _SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in sqlite3ds.o
  "_sqlite3_column_name", referenced from:
      _SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in sqlite3ds.o
  "_sqlite3_exec", referenced from:
      _SQLITE3DS_TSQLITE3DATASET_$__SQLITEEXEC$PCHAR$TSQLITECDECLCALLBACK$POINTER$$LONGINT in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__BUILDLINKEDLIST in sqlite3ds.o
  "_sqlite3_column_text", referenced from:
      _SQLITE3DS_TSQLITE3DATASET_$__BUILDLINKEDLIST in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRING in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$_QUICKQUERY$crc9A533FFC_FILLSTRINGSANDOBJECTS in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$_QUICKQUERY$crc9A533FFC_FILLSTRINGS in sqlite3ds.o
  "_sqlite3_column_type", referenced from:
      _SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in sqlite3ds.o
  "_sqlite3_open", referenced from:
      _SQLITE3DS_TSQLITE3DATASET_$__INTERNALGETHANDLE$$POINTER in sqlite3ds.o
  "_sqlite3_step", referenced from:
      _SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__EXECUTEDIRECT$ANSISTRING in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__BUILDLINKEDLIST in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__BUILDLINKEDLIST in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRING in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$_QUICKQUERY$crc9A533FFC_FILLSTRINGSANDOBJECTS in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$_QUICKQUERY$crc9A533FFC_FILLSTRINGS in sqlite3ds.o
  "_sqlite3_libversion", referenced from:
      _SQLITE3DS_TSQLITE3DATASET_$__GETSQLITEVERSION$$ANSISTRING in sqlite3ds.o
  "_sqlite3_column_count", referenced from:
      _SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__BUILDLINKEDLIST in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRING in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRING in sqlite3ds.o
  "_sqlite3_close", referenced from:
      _SQLITE3DS_TSQLITE3DATASET_$__INTERNALCLOSEHANDLE in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__INTERNALGETHANDLE$$POINTER in sqlite3ds.o
  "_sqlite3_finalize", referenced from:
      _SQLITE3DS_TSQLITE3DATASET_$__INTERNALGETHANDLE$$POINTER in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__INTERNALINITFIELDDEFS in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__EXECUTEDIRECT$ANSISTRING in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__BUILDLINKEDLIST in sqlite3ds.o
      _SQLITE3DS_TSQLITE3DATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRING in sqlite3ds.o
  "_sqlite3_changes", referenced from:
      _SQLITE3DS_TSQLITE3DATASET_$__GETROWSAFFECTED$$LONGINT in sqlite3ds.o
  "_sqlite3_column_int", referenced from:
      _SQLITE3DS_TSQLITE3DATASET_$_QUICKQUERY$crc9A533FFC_FILLSTRINGSANDOBJECTS in sqlite3ds.o
ld: symbol(s) not found
An error occurred while linking
Error: Error while linking
TExternalToolList.Run Exception: Error: Error while linking

[bobyuan]

Any one is kind enough to provide some help on this problem?

thanks in advance.

[laguna]

Solution use ZeosDB.

View my topic Zeos DB

http://lazarus.freepascal.org/index.php/topic,7034.0.html

[Loesje]

I think that your sqlite3.dylib is too old, or maybe even for sqlite2?