SQLite3 on mac os x
lazarus / 16-Databases

----------------------------------------------------------------------
wotanica · 2010-09-16 07:59

I really want to get databased working under os-x. I went into the
package manager and added the sqlite package, but it fails to
recompile the system. The errors are linking errors which i presume is
for the sqlite3 object files - which are missing.

Does anyone have the missing files that can be used on the mac?
I realize that some object files are cross-platform (i used the
libjpg/tiff .o files from my pc - and they worked fine on my mac,
which was a big surprise).

----------------------------------------------------------------------
theo · 2010-09-16 08:12

http://www.lazarus.freepascal.org/index.php/topic,7387.msg34961.html#m
sg34961

----------------------------------------------------------------------
wotanica · 2010-09-16 08:22

That doesnt really help
Ok, so SQLite should be preinstalled on my mac?
That makes sense, but that means that there are some C-like procedures
that dont have an implementation somewhere in the code?
I would expect the errors below to stem from the same callback system
that libJPG uses (where the host application must provide the
implementation for various methods). Either way it results in a
linking error.

Undefined symbols:
  "_sqlite_freemem", referenced from:
_SQLITEDS_TSQLITEDATASET_$__INTERNALGETHANDLE$$POINTER in sqliteds.o
  "sqlite_libversion", referenced from:
_SQLITEDS_TSQLITEDATASET_$__GETSQLITEVERSION$$ANSISTRING in sqliteds.o
  "sqlite_libencoding", referenced from:
_SQLITEDS_TSQLITEDATASET_$__GETSQLITEENCODING$$ANSISTRING in
sqliteds.o
  "_sqlite_error_string", referenced from:
_SQLITEDS_TSQLITEDATASET_$__RETURNSTRING$$ANSISTRING in sqliteds.o
  "_sqlite_close", referenced from:
_SQLITEDS_TSQLITEDATASET_$__INTERNALCLOSEHANDLE in sqliteds.o
  "_sqlite_changes", referenced from:
_SQLITEDS_TSQLITEDATASET_$__GETROWSAFFECTED$$LONGINT in sqliteds.o
  "_sqlite_finalize", referenced from:
_SQLITEDS_TSQLITEDATASET_$__INTERNALINITFIELDDEFS in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$__EXECUTEDIRECT$ANSISTRING in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$__BUILDLINKEDLIST in sqliteds.o _SQLITEDS_TS
QLITEDATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRING in
sqliteds.o
  "_sqlite_exec", referenced from: _SQLITEDS_TSQLITEDATASET_$__SQLITEE
XEC$PCHAR$TSQLITECDECLCALLBACK$POINTER$$LONGINT in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$__BUILDLINKEDLIST in sqliteds.o
  "_sqlite_open", referenced from:
_SQLITEDS_TSQLITEDATASET_$__INTERNALGETHANDLE$$POINTER in sqliteds.o
  "_sqlite_step", referenced from:
_SQLITEDS_TSQLITEDATASET_$__INTERNALINITFIELDDEFS in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$__EXECUTEDIRECT$ANSISTRING in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$__BUILDLINKEDLIST in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$__BUILDLINKEDLIST in sqliteds.o _SQLITEDS_TS
QLITEDATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRING in
sqliteds.o _SQLITEDS_TSQLITEDATASET_$_QUICKQUERY$crc9A533FFC_FILLSTRIN
GSANDOBJECTS in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$_QUICKQUERY$crc9A533FFC_FILLSTRINGS in
sqliteds.o
  "_sqlite_compile", referenced from:
_SQLITEDS_TSQLITEDATASET_$__INTERNALINITFIELDDEFS in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$__EXECUTEDIRECT$ANSISTRING in sqliteds.o
_SQLITEDS_TSQLITEDATASET_$__BUILDLINKEDLIST in sqliteds.o _SQLITEDS_TS
QLITEDATASET_$__QUICKQUERY$ANSISTRING$TSTRINGS$BOOLEAN$$ANSISTRING in
sqliteds.o
ld: symbol(s) not found
Error: Error while linking


No wait that cant be right.
I did a quick search on my mac for sqlite and found hundreds of sqlite
files. Loads of .O files, some of them in the lazarus folders to.
Hm......

----------------------------------------------------------------------
wotanica · 2010-09-16 11:31

Lazarus report a linking error, which i guess is completely right.
It would only generate above errors if some symbols are missing from
the .o files.
I conclude that this is a classic case of version mixup.
Either the object files are to old/new for the wrapper unit.