From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-0.9 required=5.0 tests=BAYES_00,FORGED_GMAIL_RCVD, FREEMAIL_FROM autolearn=no autolearn_force=no version=3.4.4 X-Google-Thread: 103376,f8dc8a429208e220,start X-Google-NewGroupId: yes X-Google-Attributes: gida07f3367d7,domainid0,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit Path: g2news1.google.com!postnews.google.com!e20g2000prf.googlegroups.com!not-for-mail From: Alexander Korolev Newsgroups: comp.lang.ada Subject: GNAColl SQLite Binding Installation Problem (Mac, Snow Leopard) Date: Wed, 10 Aug 2011 11:48:21 -0700 (PDT) Organization: http://groups.google.com Message-ID: NNTP-Posting-Host: 96.49.119.210 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 X-Trace: posting.google.com 1313002207 25509 127.0.0.1 (10 Aug 2011 18:50:07 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 10 Aug 2011 18:50:07 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: e20g2000prf.googlegroups.com; posting-host=96.49.119.210; posting-account=9aAl4woAAACPkuvNJOQxyBXxG_5lfu_0 User-Agent: G2/1.0 X-Google-Web-Client: true X-Google-Header-Order: HUARLECNK X-HTTP-UserAgent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_5; ru-ru) AppleWebKit/533.18.1 (KHTML, like Gecko) Version/5.0.2 Safari/533.18.5,gzip(gfe) Xref: g2news1.google.com comp.lang.ada:20514 Date: 2011-08-10T11:48:21-07:00 List-Id: 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: "/prepared.adb" compilation error ! ./test.cmd: line 4: ./prepared: No such file or directory