RE: [sqlite] Re: data base locked problem
> "Igor Tandetnik" <[EMAIL PROTECTED]> schrieb am 11.09.2007 13:40:30: > > > > Armin Steinhoff wrote: > > > if we are try to create a new data base with sqlite we see the > > > following error outputs: > > > > > > # sqlite x.db > > > OPEN3 /appl/sbin/x.db > > > OPEN-EX 4 /tmp/sqlite_Iihb60vuQk4Nf9D > > > SQLite version 2.8.0 > > > Enter ".help" for instructions > > > sqlite> create table yy(xx char(10), x int); > > > SQL error: database is locked > > > sqlite> .q > > > CLOSE 3 > > > CLOSE 4 > > > > > > What's the problem ?? > > > > My guess is, the user account you are running under doesn't have > > permissions to create new files under /appl/sbin. > > No, that's not the case. Please see the correct file > descriptors shown by the trace output (OPEN / OPEN-EX) Try using strace or truss to see what the underlying open failure is (if any). > > --Armin > > >The error message is > > somewhat misleading. > > > > Igor Tandetnik > > > > > > > -- > > --- To unsubscribe, send email to > > [EMAIL PROTECTED] > > > -- > > --- > > > > > _ > Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! > http://smartsurfer.web.de/?mc=100071=0066 > > > -- > --- > To unsubscribe, send email to [EMAIL PROTECTED] > -- > --- > > - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Difference in these indices?
Hi, > > It might make sense to create a separate standalone utility program > > (like sqlite3_analyzer) that reuses some the sqlite source > to do bulk > > inserts into a table in a database file as fast a possible with out > > having to worry about locking or journaling etc. > > That would solve my problem too (thread: "CREATE INDEX > performance" on indexing a 5.8-million record table). I'd > love something like that! Having such a utility would solve a lot of my problems regarding getting data into the DB. My current application does not allow access to the data until the DB is populated so (in this case) I don't derive any benefit from locking, journalling, etc. Once the DB is populated I find SQLite to more than fast enough. -- andy - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Re: Java wrapper for both windows and linux
Hi, > > Can you elaborate on how you make this selection, and how > you package > > the fragment? > > > > => Since fragments are host-specific, only the fragment you > need will be loaded. > (If you use an update site, only the fragment you need > will be downloaded). > > Note: the System property "java.library.path" is also set in > the plugin Activator, in order to found the embedded > dll/shared library in the right fragment. I didn't think it was possible to change "java.library.path" after the VM has started. If it is possible to change this value then that may have an adverse affect on other plugins. Or is the change isolated just to the plugin itself? Do you mind posting your plugin Activator that sets this property? > > Does this answer to your question ? > > > -- > --- > To unsubscribe, send email to [EMAIL PROTECTED] > -- > --- > > - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Busy timeout and prepare statements
Hi, I'm seeking some clarification regarding set_busy_timeout(). If I set this to some positive value does this work when using prepared statements (prepare, step, reset) or only when using sqlite3_exec(). Thanks.
