Re: [sqlite] Impossible to "catch locked state" (SQLite 3.5.6 & TCL)
On Sun, Mar 09, 2008 at 01:41:24AM +, [EMAIL PROTECTED] wrote: > The error is not occurring until later, the first time you > try to access the database using the dbcomm object. Yes, right - opening itself isn't any access yet. -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Impossible to "catch locked state" (SQLite 3.5.6 & TCL)
Zbigniew Baniewski <[EMAIL PROTECTED]> wrote: > I'm afraid, I've discovered a bug: there's no possibility to "catch" the > error "database is locked". Even, when one's trying something like: > > #v+ > if { [catch {sqlite3 dbcomm $fullPathToDatabaseFile} err] } { > puts $err > } > #v- > > There'll be no $err output, because - as it seems - "catch" won't return > a value > 0. There'll be following lines printed on the console instead: > > database is locked > while evaluating {source ./main.tcl} > The error is not occurring until later, the first time you try to access the database using the dbcomm object. -- D. Richard Hipp <[EMAIL PROTECTED]> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Impossible to "catch locked state" (SQLite 3.5.6 & TCL)
I'm afraid, I've discovered a bug: there's no possibility to "catch" the error "database is locked". Even, when one's trying something like: #v+ if { [catch {sqlite3 dbcomm $fullPathToDatabaseFile} err] } { puts $err } #v- There'll be no $err output, because - as it seems - "catch" won't return a value > 0. There'll be following lines printed on the console instead: database is locked while evaluating {source ./main.tcl} -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [C] Linker Error
Hi Folks Thanks for your answers. I already had the latest build, and i linked the lib correctly with my Linker. I found the solution in the meantime. It was quite easy actually: I only had to manually add the -ldl option to my linker and all worked fine. Thanks anyway for your support :) Kind regards Severin -- Severin A. Mueller Mythenquai 2 CH-8022 Zurich Office: +41 44 278 85 03 Mobile: +41 76 249 85 38 GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen! Jetzt dabei sein: http://www.shortview.de/[EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [C] Linker Error
Looks like you need to include the shared library archive into your LIB list. Severin Müller wrote: > Hi folks > > I tried to include sqlite3 in my current C Project. > > I downloaded the precompiled library sqlite-3.5.6.so and put it in my project. > Then, i downloaded the sqlite source and added sqlite3.h to my project. > > Now, when i try to compiler, i get the following error message: > > /home/fish-guts/workspace/Debug/lib/sqlite-3.5.6.so: undefined reference to > `dlsym' > /home/fish-guts/workspace/Debug/lib/sqlite-3.5.6.so: undefined reference to > `dlerror' > /home/fish-guts/workspace/Debug/lib/sqlite-3.5.6.so: undefined reference to > `dlopen' > /home/fish-guts/workspace/Debug/lib/sqlite-3.5.6.so: undefined reference to > `dlclose' > > I'm using the Ecplipse IDE with GCC on Linux. > > Does anyone know what i'm doing wrong? I noticed, that there is no *.a file > coming along with the precompiled library, Intentionally? > > Many thanks in advance for your quick help! > > Kind regards > > Severin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [C] Linker Error
Clay Dowling <[EMAIL PROTECTED]> wrote: > Severin Müller wrote: > > I tried to include sqlite3 in my current C Project. = > > > = > > > I downloaded the precompiled library sqlite-3.5.6.so and put it in my pro= > ject. > > Then, i downloaded the sqlite source and added sqlite3.h to my project. = > > > = > > > Now, when i try to compiler, i get the following error message: > > = > > > /home/fish-guts/workspace/Debug/lib/sqlite-3.5.6.so: undefined reference = > to `dlsym' > > /home/fish-guts/workspace/Debug/lib/sqlite-3.5.6.so: undefined reference = > to `dlerror' > > /home/fish-guts/workspace/Debug/lib/sqlite-3.5.6.so: undefined reference = > to `dlopen' > > /home/fish-guts/workspace/Debug/lib/sqlite-3.5.6.so: undefined reference = > to `dlclose' > > Rather than use the precompiled library, I recommend one of two options: > > 1. Download the latest version that is in your package manager and use >that, if it is sufficiently recent. > > 2. Download the source and build it. It is a very easy to build >package, and you would then have the option to build a static version if >you wanted (the .a library) > I agree with Clay. Get a copy of the amalagamation. It is a single file of C code named sqlite3.c. Compile it and statically link it with your application. But even then, you're going to get the same linker errors because you have omitted the "-ldl" option when you link. -- D. Richard Hipp <[EMAIL PROTECTED]> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [C] Linker Error
Severin Müller wrote: > I tried to include sqlite3 in my current C Project. > > I downloaded the precompiled library sqlite-3.5.6.so and put it in my project. > Then, i downloaded the sqlite source and added sqlite3.h to my project. > > Now, when i try to compiler, i get the following error message: > > /home/fish-guts/workspace/Debug/lib/sqlite-3.5.6.so: undefined reference to > `dlsym' > /home/fish-guts/workspace/Debug/lib/sqlite-3.5.6.so: undefined reference to > `dlerror' > /home/fish-guts/workspace/Debug/lib/sqlite-3.5.6.so: undefined reference to > `dlopen' > /home/fish-guts/workspace/Debug/lib/sqlite-3.5.6.so: undefined reference to > `dlclose' Rather than use the precompiled library, I recommend one of two options: 1. Download the latest version that is in your package manager and use that, if it is sufficiently recent. 2. Download the source and build it. It is a very easy to build package, and you would then have the option to build a static version if you wanted (the .a library) Clay -- CeaMuS, Simple Content Management http://www.ceamus.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] [C] Linker Error
Hi folks I tried to include sqlite3 in my current C Project. I downloaded the precompiled library sqlite-3.5.6.so and put it in my project. Then, i downloaded the sqlite source and added sqlite3.h to my project. Now, when i try to compiler, i get the following error message: /home/fish-guts/workspace/Debug/lib/sqlite-3.5.6.so: undefined reference to `dlsym' /home/fish-guts/workspace/Debug/lib/sqlite-3.5.6.so: undefined reference to `dlerror' /home/fish-guts/workspace/Debug/lib/sqlite-3.5.6.so: undefined reference to `dlopen' /home/fish-guts/workspace/Debug/lib/sqlite-3.5.6.so: undefined reference to `dlclose' I'm using the Ecplipse IDE with GCC on Linux. Does anyone know what i'm doing wrong? I noticed, that there is no *.a file coming along with the precompiled library, Intentionally? Many thanks in advance for your quick help! Kind regards Severin -- Severin A. Mueller Mythenquai 2 CH-8022 Zurich Office: +41 44 278 85 03 Mobile: +41 76 249 85 38 Pt! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Odd problem with select on large table
Hi James, > / > sqlite3 test.db `select name from PerfTest1 where name = > "key5000"' > > does work. I know this because if I query for "key500" I get back > that row. It may work, but it's still wrong ;-) You should use single quotes for literals, which is correct SQL syntax. SQLite should give an error for double quotes unless it's a column or table name. SQLite doesn't generate an error, unfortunately, because it allows for some cross compatibility with MSSQL or something that permits double quoted literals. That allowance, however, is not standard SQL and causes a host of problems. I'm hoping it will be removed from SQLite. Tom BareFeet ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users