Re: [sqlite] [sqlite-dev] Why I always got error SQLITE_MISUSE 21 /* Library used incorrectly */

hi Pavel, Thanks for your reply and reminder. I am now using SQLite version 3.3.5, and i cannot find flag SQLITE3_THREADSAFE in source code, so my question is how can i ensure i compile with this option? The second question is when i met SQLITE_MISUSE error, can i reset or reopen the database to

[sqlite] Help with Transaction Error.

I am trying to use SQL Jet within my java application, but I consistently get the following error when I run this section of code. For some reason I cannot open this particular database. I can open up a separate database with in my program, but this one always causes the error.

[sqlite] Reasons for SQLITE_CANTOPEN

Hello, I am accessing the same database from several threads, each using a separate connection. Shared cache is not enabled. When my program has been running for a while, I suddenly get an SQLITE_CANTOPEN error when I'm trying to open a database connection with a new thread. The database file,

Re: [sqlite] graphs and sql

On Sat, Jan 09, 2010 at 03:41:24PM -0500, Robert Citek scratched on the wall: > Hello all, > > Does anyone have any recommendations for books or other resources that > deal with working with graphs (i.e. vertexes and edges) using sql? > > For example, if I could store a graph in a sqlite

Re: [sqlite] graphs and sql

Hi Robert, >For example, if I could store a graph in a sqlite database, I'd like >to query the database to know if the graph contains a Eulerian >path[1]. I may be driven by a misleading uneducated impression, but given the nature of most graph-related algorithms --I see the search for Eulerian

[sqlite] graphs and sql

Hello all, Does anyone have any recommendations for books or other resources that deal with working with graphs (i.e. vertexes and edges) using sql? For example, if I could store a graph in a sqlite database, I'd like to query the database to know if the graph contains a Eulerian path[1]. [1]

Re: [sqlite] Import a other database. Search for the fastes way

Carsten Giesen wrote: > Now my question. > > I work on a way to have a cache DB from the Main Server on the PC of my > client. > In the case the server is down they can go on working. (Like Outlook and > Exchange) > > > > For the first time I have to copy a lot of data from the main server. > >

Re: [sqlite] Import a other database. Search for the fastes way

On Sat, 9 Jan 2010 14:39:29 +0100, "Carsten Giesen" wrote: >Hello, > > >first I want to say hello, I'm the new ;) Welcome to the club! >I'm a newby in SQLite but I'm not new in SQL. > >My main DB is MSSQL and I see, as we know from Microsoft, there must be a

[sqlite] Import a other database. Search for the fastes way

Hello, first I want to say hello, I'm the new ;) I'm a newby in SQLite but I'm not new in SQL. My main DB is MSSQL and I see, as we know from Microsoft, there must be a lot of differences. Now my question. I work on a way to have a cache DB from the Main Server on the PC of my client.