GNAColl SQLite Binding Installation Problem (Mac, Snow Leopard)

GNAColl SQLite Binding Installation Problem (Mac, Snow Leopard)

[Alexander Korolev]

Hi,
I've installed GNATColl as a part of GNAT GPL 5 up until "make test"
step.
There is no single error on steps
"configure"
./configure --prefix=/usr/local/gnatcoll --with-sqlite

and "make"

make

Tried to make a test

make test

got errors related to libgnatcoll_sqlite.dylib

-----
! dyld: Library not loaded: @rpath/libgnatcoll_sqlite.dylib
!   Referenced from: /Developer/adacore/AdaCore/GNATcoll/gnatcoll-
gpl-2011-src/testsuite/../local_install/bin/gnatcoll_db2ada
!   Reason: image not found

----
I wasn't able to find the file libgnatcoll_sqlite.dylib.  Did anybody
experience the same or similar or have any guess.


Thanks.
Alexander


THE TRACE AFTER "MAKE TEST"  COMMAND


make prefix=/Developer/adacore/AdaCore/GNATcoll/gnatcoll-gpl-2011-src/
local_install install >/dev/null
make prefix=/Developer/adacore/AdaCore/GNATcoll/gnatcoll-gpl-2011-src/
local_install -C testsuite test
=== GNATCOLL.SQL.PREPARED: FAILURE
*** test.out.15132	2011-08-10 08:49:01.000000000 +0400
--- out.15132.post	2011-08-10 08:49:01.000000000 +0400
***************
*** 1,60 ****
! [MAIN] -------------- Preparing database -------------
! [SQL] Connecting to sqlite database test.db ()
! [SQL.LITE] Create empty db file
! [SQL] PRAGMA foreign_keys=ON
! [SQL] BEGIN
! [SQL] CREATE TABLE data (   id Integer NOT NULL,
! _SQL_    name Text DEFAULT 'default',
! _SQL_    value Integer DEFAULT '1', PRIMARY KEY (id))
! [SQL] CREATE TABLE pairs (   id Integer NOT NULL,
! _SQL_    end1 Integer,
! _SQL_    end2 Integer,
! _SQL_    value Text, PRIMARY KEY (id), FOREIGN KEY (end1) REFERENCES
data (id), FOREIGN KEY (end2) REFERENCES data (id))
! [SQL] CREATE INDEX "pairs_end1" ON "pairs" ("end1")
! [SQL] CREATE INDEX "pairs_end2" ON "pairs" ("end2")
! [SQL] COMMIT
! [SQL.INSPECT] Loading data from initialdata.txt into database
! [SQL] PRAGMA foreign_keys=OFF
! [SQL] compute (insertval): INSERT INTO data(id,name,value) VALUES (?
1,?2,?3)
! [SQL] BEGIN
! [SQL.LITE] PREPARE insertval
! [SQL] (insertval), 1, aaa, 1
! [SQL] (insertval), 2, bbb, 2
! [SQL] (insertval), 3, acc, 2
! [SQL] compute (insertval): INSERT INTO pairs(id,end1,end2,value)
VALUES (?1,?2,?3,?4)
! [SQL] Finalize stmt on server: insertval
! [SQL] INSERT INTO pairs(id,end1,end2,value) SELECT
10,t2.id,t3.id,'With ''quote' FROM data t2,data t3 WHERE t2.name='aaa'
and t3.name='bbb'
! [SQL] INSERT INTO pairs(id,end1,end2,value) SELECT
11,t2.id,t3.id,'With "quote' FROM data t2,data t3 WHERE t2.name='bbb'
and t3.name='acc'
! [SQL] COMMIT
! [MAIN] -------------- Simple queries -------------
! [SQL.SELECT] SELECT data.id FROM data WHERE data.value=2 (2 tuples)
! [SQL.SELECT] SELECT data.id FROM data WHERE data.value=2
! [MAIN] -------------- preparation on client -------------
! [SQL] compute (stmt3): SELECT data.id FROM data WHERE data.value=2
! [SQL.SELECT] (stmt3) (2 tuples)
! [SQL.SELECT] (stmt3) (2 tuples)
! [SQL] Prepared statement was freed, can't execute
! [MAIN] -------------- caching on client -------------
! [SQL] compute (stmt4): SELECT data.id FROM data WHERE data.value=2
! [SQL.SELECT] (stmt4) (2 tuples)
! [SQL.CACHE] Use cache for stmt4
! [SQL] Unset cache for stmt4
! [MAIN] -------------- preparation on server -------------
! [SQL] compute (query2): SELECT data.id FROM data WHERE data.value=2
! [SQL.LITE] PREPARE query2
! [SQL.SELECT] (query2) (2 tuples)
! [SQL.SELECT] (query2) (2 tuples)
! [MAIN] ----------- same prepared stmt, on second connection --
! [SQL] Connecting to sqlite database test.db ()
! [SQL] PRAGMA foreign_keys=ON
! [SQL.LITE] PREPARE query2
! [SQL.SELECT] (query2) (2 tuples)
! [MAIN] -------------- using parameters -------------
! [SQL] Finalize stmt on server: query2 (for 2 connections)
! [SQL] compute (stmt6): SELECT data.id FROM data WHERE data.value=?1
! [SQL.LITE] PREPARE stmt6
! [SQL.SELECT] (stmt6), 2 (2 tuples)
! [SQL.SELECT] (stmt6), 3 (0 tuples)
! [SQL] Finalize stmt on server: stmt6
! [SQL.LITE] Closing connection to sqlite
! [SQL.LITE] Closing connection to sqlite
--- 1,7 ----
! dyld: Library not loaded: @rpath/libgnatcoll_sqlite.dylib
!   Referenced from: /Developer/adacore/AdaCore/GNATcoll/gnatcoll-
gpl-2011-src/testsuite/../local_install/bin/gnatcoll_db2ada
!   Reason: image not found
! ./test.cmd: line 2: 15148 Trace/BPT trap          gnatcoll_db2ada -
dbmodel dbschema.txt -api dbschema
! prepared.adb:39:06: file "dbschema.ads" not found
! gnatmake: "<pwd>/prepared.adb" compilation error
! ./test.cmd: line 4: ./prepared: No such file or directory

Re: GNAColl SQLite Binding Installation Problem (Mac, Snow Leopard)

[Simon Wright]

Alexander Korolev <antonovkablog@gmail.com> writes:

> I've installed GNATColl as a part of GNAT GPL 5 up until "make test"
> step.

What is GNAT GPL 5? I guess you mean GNAT GPL 2011?

Which version of Mac OS X are you running? 

> There is no single error on steps
> "configure"
> ./configure --prefix=/usr/local/gnatcoll --with-sqlite
>
> and "make"
>
> make
>
> Tried to make a test
>
> make test
>
> got errors related to libgnatcoll_sqlite.dylib
>
> -----
> ! dyld: Library not loaded: @rpath/libgnatcoll_sqlite.dylib
> !   Referenced from: /Developer/adacore/AdaCore/GNATcoll/gnatcoll-
> gpl-2011-src/testsuite/../local_install/bin/gnatcoll_db2ada
> !   Reason: image not found
>
> ----
> I wasn't able to find the file libgnatcoll_sqlite.dylib.  Did anybody
> experience the same or similar or have any guess.

It's in gnatcoll-gpl-2011-src/src/lib/sqlite/relocatable/.

I don't see why dyld didn't find it at runtime, unless perhaps it's
confused because the .dylib is a symlink (because gnatcoll isn't fully
up to speed with shared libraries on the Mac). But then why would it
work if calling gnatcoll_db2ada in its original built location?

I'd recommend that you configure for static libraries only
(--disable-shared). NB, all, this is only for Mac users!

Re: GNAColl SQLite Binding Installation Problem (Mac, Snow Leopard)

[Alexander Korolev]

On Aug 11, 1:52 am, Simon Wright <si...@pushface.org> wrote:
> Alexander Korolev <antonovkab...@gmail.com> writes:
> > I've installed GNATColl as a part of GNAT GPL 5 up until "make test"
> > step.
>
> What is GNAT GPL 5? I guess you mean GNAT GPL 2011?
>
> Which version of Mac OS X are you running?
>
>
>
>
>
> > There is no single error on steps
> > "configure"
> > ./configure --prefix=/usr/local/gnatcoll --with-sqlite
>
> > and "make"
>
> > make
>
> > Tried to make a test
>
> > make test
>
> > got errors related to libgnatcoll_sqlite.dylib
>
> > -----
> > ! dyld: Library not loaded: @rpath/libgnatcoll_sqlite.dylib
> > !   Referenced from: /Developer/adacore/AdaCore/GNATcoll/gnatcoll-
> > gpl-2011-src/testsuite/../local_install/bin/gnatcoll_db2ada
> > !   Reason: image not found
>
> > ----
> > I wasn't able to find the file libgnatcoll_sqlite.dylib.  Did anybody
> > experience the same or similar or have any guess.
>
> It's in gnatcoll-gpl-2011-src/src/lib/sqlite/relocatable/.
>
> I don't see why dyld didn't find it at runtime, unless perhaps it's
> confused because the .dylib is a symlink (because gnatcoll isn't fully
> up to speed with shared libraries on the Mac). But then why would it
> work if calling gnatcoll_db2ada in its original built location?
>
> I'd recommend that you configure for static libraries only
> (--disable-shared). NB, all, this is only for Mac users!

Thanks Simon.

- MacOS version 10.6.5
- GPL 2011

I've implemented your recommendation. It seems to me  I can proceed
with make install
step now. Just want to make all "make" steps clean to avoid
consequenses further.

AFTER

make test
--
make prefix=/Developer/adacore/AdaCore/GNATcoll/gnatcoll-gpl-2011-src/
local_install install >/dev/null
make prefix=/Developer/adacore/AdaCore/GNATcoll/gnatcoll-gpl-2011-src/
local_install -C testsuite test
--
AFTER
make examples

make -C examples
gnatmake -Pexamples
gcc -c -gnat05 -I- -gnatA /Developer/adacore/AdaCore/GNATcoll/gnatcoll-
gpl-2011-src/examples/newclass.adb
gcc -c -gnat05 -I- -gnatA /Developer/adacore/AdaCore/GNATcoll/gnatcoll-
gpl-2011-src/examples/common.adb
gcc -c -gnat05 -I- -gnatA /Developer/adacore/AdaCore/GNATcoll/gnatcoll-
gpl-2011-src/examples/textconsole.adb
gnatbind -I- -x /Developer/adacore/AdaCore/GNATcoll/gnatcoll-gpl-2011-
src/examples/obj/newclass.ali
gnatlink /Developer/adacore/AdaCore/GNATcoll/gnatcoll-gpl-2011-src/
examples/obj/newclass.ali /usr/local/gnatcoll/lib/gnatcoll/static/
libgnatcoll_python.a /usr/local/gnatcoll/lib/gnatcoll/static/
libgnatcoll.a /usr/local/gnat/lib/gnat_util/static/libgnat_util.a -Wl,-
rpath,/usr/local/gnat/lib/gcc/x86_64-apple-darwin10.2.0/4.5.3/adalib/ /
System/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/
config/libpython2.6.a -ldl -lm -o /Developer/adacore/AdaCore/GNATcoll/
gnatcoll-gpl-2011-src/examples/newclass
===================================================
== To run, set the environment variable LD_LIBRARY_PATH
==   LD_LIBRARY_PATH=/usr/local/gnatcoll/lib/gnat:$LD_LIBRARY_PATH

Re: GNAColl SQLite Binding Installation Problem (Mac, Snow Leopard)

[Simon Wright]

Alexander Korolev <antonovkablog@gmail.com> writes:

> - MacOS version 10.6.5
> - GPL 2011

OK

> I've implemented your recommendation. It seems to me I can proceed
> with make install step now. Just want to make all "make" steps clean
> to avoid consequenses further.

I think so.

> == To run, set the environment variable LD_LIBRARY_PATH
> ==   LD_LIBRARY_PATH=/usr/local/gnatcoll/lib/gnat:$LD_LIBRARY_PATH

Of course, on Mac OS X that would be DYLD_LIBRARY_PATH. But I don't
think you'll need it. In any case, you've just built static-only!

Re: GNAColl SQLite Binding Installation Problem (Mac, Snow Leopard)

[Dmitry A. Kazakov]

On Thu, 11 Aug 2011 13:04:07 +0100, Simon Wright wrote:

> Alexander Korolev <antonovkablog@gmail.com> writes:
> 
>> == To run, set the environment variable LD_LIBRARY_PATH
>> ==   LD_LIBRARY_PATH=/usr/local/gnatcoll/lib/gnat:$LD_LIBRARY_PATH
> 
> Of course, on Mac OS X that would be DYLD_LIBRARY_PATH. But I don't
> think you'll need it. In any case, you've just built static-only!

Especially because the intended use of SQLite is the "amalgation" source
file compiled and statically linked to the application.

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de

Re: GNAColl SQLite Binding Installation Problem (Mac, Snow Leopard)

[Alexander Korolev]

On Aug 11, 4:04 pm, Simon Wright <si...@pushface.org> wrote:
> Alexander Korolev <antonovkab...@gmail.com> writes:
> > - MacOS version 10.6.5
> > - GPL 2011
>
> OK
>
> > I've implemented your recommendation. It seems to me I can proceed
> > with make install step now. Just want to make all "make" steps clean
> > to avoid consequenses further.
>
> I think so.
>
> > == To run, set the environment variable LD_LIBRARY_PATH
> > ==   LD_LIBRARY_PATH=/usr/local/gnatcoll/lib/gnat:$LD_LIBRARY_PATH
>
> Of course, on Mac OS X that would be DYLD_LIBRARY_PATH. But I don't
> think you'll need it. In any case, you've just built static-only!

"make install" is ok. Also implemented simple bo manager with a CRUD.
It works.
Thanks again.

Re: GNAColl SQLite Binding Installation Problem (Mac, Snow Leopard)

[Alexander Korolev]

On Aug 11, 4:52 pm, "Dmitry A. Kazakov" <mail...@dmitry-kazakov.de>
wrote:
> On Thu, 11 Aug 2011 13:04:07 +0100, Simon Wright wrote:
> > Alexander Korolev <antonovkab...@gmail.com> writes:
>
> >> == To run, set the environment variable LD_LIBRARY_PATH
> >> ==   LD_LIBRARY_PATH=/usr/local/gnatcoll/lib/gnat:$LD_LIBRARY_PATH
>
> > Of course, on Mac OS X that would be DYLD_LIBRARY_PATH. But I don't
> > think you'll need it. In any case, you've just built static-only!
>
> Especially because the intended use of SQLite is the "amalgation" source
> file compiled and statically linked to the application.
>
> --
> Regards,
> Dmitry A. Kazakovhttp://www.dmitry-kazakov.de

Absolutly agree.

Re: GNAColl SQLite Binding Installation Problem (Mac, Snow Leopard)

[Simon Wright]

"Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de> writes:

> On Thu, 11 Aug 2011 13:04:07 +0100, Simon Wright wrote:
>
>> Alexander Korolev <antonovkablog@gmail.com> writes:
>> 
>>> == To run, set the environment variable LD_LIBRARY_PATH
>>> ==   LD_LIBRARY_PATH=/usr/local/gnatcoll/lib/gnat:$LD_LIBRARY_PATH
>> 
>> Of course, on Mac OS X that would be DYLD_LIBRARY_PATH. But I don't
>> think you'll need it. In any case, you've just built static-only!
>
> Especially because the intended use of SQLite is the "amalgation"
> source file compiled and statically linked to the application.

I don't think it's quite so clear-cut as that:
http://www.sqlite.org/amalgamation.html.

For all we know libsqlite3.dylib was produced from the amalgamation, so
you might get the 5-10% performance improvement anyway (if you really
need it).

Re: GNAColl SQLite Binding Installation Problem (Mac, Snow Leopard)

[Dmitry A. Kazakov]

On Sat, 13 Aug 2011 09:51:26 -0700 (PDT), Alexander Korolev wrote:

> On Aug 11, 4:52�pm, "Dmitry A. Kazakov" <mail...@dmitry-kazakov.de>
> wrote:
>> On Thu, 11 Aug 2011 13:04:07 +0100, Simon Wright wrote:
>>> Alexander Korolev <antonovkab...@gmail.com> writes:
>>
>>>> == To run, set the environment variable LD_LIBRARY_PATH
>>>> == � LD_LIBRARY_PATH=/usr/local/gnatcoll/lib/gnat:$LD_LIBRARY_PATH
>>
>>> Of course, on Mac OS X that would be DYLD_LIBRARY_PATH. But I don't
>>> think you'll need it. In any case, you've just built static-only!
>>
>> Especially because the intended use of SQLite is the "amalgation" source
>> file compiled and statically linked to the application.
>>
> Absolutly agree.

Why don't you use the amalgation then?

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de

Re: GNAColl SQLite Binding Installation Problem (Mac, Snow Leopard)

[Dmitry A. Kazakov]

On Sat, 13 Aug 2011 18:05:36 +0100, Simon Wright wrote:

> "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de> writes:
> 
>> On Thu, 11 Aug 2011 13:04:07 +0100, Simon Wright wrote:
>>
>>> Alexander Korolev <antonovkablog@gmail.com> writes:
>>> 
>>>> == To run, set the environment variable LD_LIBRARY_PATH
>>>> ==   LD_LIBRARY_PATH=/usr/local/gnatcoll/lib/gnat:$LD_LIBRARY_PATH
>>> 
>>> Of course, on Mac OS X that would be DYLD_LIBRARY_PATH. But I don't
>>> think you'll need it. In any case, you've just built static-only!
>>
>> Especially because the intended use of SQLite is the "amalgation"
>> source file compiled and statically linked to the application.
> 
> I don't think it's quite so clear-cut as that:
> http://www.sqlite.org/amalgamation.html.
> 
> For all we know libsqlite3.dylib was produced from the amalgamation, so
> you might get the 5-10% performance improvement anyway (if you really
> need it).

I think that performance is not so relevant here, as the nature of SQLite,
which is an embeddable RDBMS/Client. If not for this case, there is little
sense to deploy SQLite at all.

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de

Re: GNAColl SQLite Binding Installation Problem (Mac, Snow Leopard)

[Simon Wright]

"Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de> writes:

> On Sat, 13 Aug 2011 18:05:36 +0100, Simon Wright wrote:
>
>> "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de> writes:
>> 
>>> On Thu, 11 Aug 2011 13:04:07 +0100, Simon Wright wrote:
>>>
>>>> Alexander Korolev <antonovkablog@gmail.com> writes:
>>>> 
>>>>> == To run, set the environment variable LD_LIBRARY_PATH
>>>>> ==   LD_LIBRARY_PATH=/usr/local/gnatcoll/lib/gnat:$LD_LIBRARY_PATH
>>>> 
>>>> Of course, on Mac OS X that would be DYLD_LIBRARY_PATH. But I don't
>>>> think you'll need it. In any case, you've just built static-only!
>>>
>>> Especially because the intended use of SQLite is the "amalgation"
>>> source file compiled and statically linked to the application.
>> 
>> I don't think it's quite so clear-cut as that:
>> http://www.sqlite.org/amalgamation.html.
>> 
>> For all we know libsqlite3.dylib was produced from the amalgamation, so
>> you might get the 5-10% performance improvement anyway (if you really
>> need it).
>
> I think that performance is not so relevant here, as the nature of
> SQLite, which is an embeddable RDBMS/Client. If not for this case,
> there is little sense to deploy SQLite at all.

GNATcoll generates -lsqlite3 at link time. So you will be using a
library if you want to run (or test) with unmodified GNATcoll.

Mac OS X happens to incorporate SQLite as a shared library, not that it
matters.

This has nothing to do with how you might configure an embedded system,
of course.

[OP's problem was with libgnatcoll_sqlite, not with libsqlite3.]