Re: [sqlite] False Error 'no such collation sequence'

On 21.06.2013 05:10, Tom Holden wrote: > Ralf Junker ralfjunker at gmx.de Thu Jun 20 18:44:15 EDT 2013 wrote: > > On 19.06.2013 17:18, Tom Holden wrote: > >> I use the SQLiteSpy compilation of SQLite3 which recently upgraded >> from pre SQLite 3.7.8 to pre 4.2.0. > > You must be mistaken. As

Re: [sqlite] False Error 'no such collation sequence'

On Thu, Jun 20, 2013 at 11:10 PM, Tom Holden wrote: > I realise that my usage of SQLite on a database outside of the application > that created it with a proprietary collation sequence that is unavailable > to my SQLIte manager is uncommon but surely not unique. > Can you not

Re: [sqlite] False Error 'no such collation sequence'

Ralf Junker ralfjunker at gmx.de Thu Jun 20 18:44:15 EDT 2013 wrote: On 19.06.2013 17:18, Tom Holden wrote: I use the SQLiteSpy compilation of SQLite3 which recently upgraded from pre SQLite 3.7.8 to pre 4.2.0. You must be mistaken. As the author of SQLiteSpy, I can clearly say that there is

Re: [sqlite] False Error 'no such collation sequence'

On 19.06.2013 17:18, Tom Holden wrote: > I use the SQLiteSpy compilation of SQLite3 which recently upgraded > from pre SQLite 3.7.8 to pre 4.2.0. You must be mistaken. As the author of SQLiteSpy, I can clearly say that there is no SQLiteSpy version 3.7.8 nor 4.2.0. The current version is

Re: [sqlite] anyone know how to use ta-lib api to the sqlite database?

On Thu, 20 Jun 2013 06:37:22 +, YAN HONG YE wrote: > the ta-lib.org, the ta-lib library could use in EXCEL, > I wanna use it in the sqlite database, but I don't know > how to write the c or c++ code to load the ta-lib api in > sqlite database, anyone know it? You cannot

Re: [sqlite] sqlite DB's disk image getting malformed

Filip, Yes have gone through the section 7.4 in http://www.sqlite.org/howtocorrupt.html but as I read it says the bug being a false-positive alarm of corruption with no actual data loss. But we are observing proper a proper DB corruption wherein any read on the same fails with error as "disk

Re: [sqlite] Problem with getting previous command in shell

On Thu, Jun 20, 2013 at 04:13:06PM +, Tilsley, Jerry M. scratched on the wall: > All, > > I have two environments; one production and one test/development. > Both are Redhat Linux 6.3 running SQLite 3.7.10. On the test/development > environment when I'm using the SQLite shell I can use

Re: [sqlite] SQLite C# differences between Windows Server 2008 and 2003

You should be checking the lock after the end of the using. I think the dispose is not done because you are still inside the using statement. Also I think it could take some time even after the using, because I think .net CLR can take it's time collecting it. Also I don't think you need/should

[sqlite] Problem with getting previous command in shell

All, I have two environments; one production and one test/development. Both are Redhat Linux 6.3 running SQLite 3.7.10. On the test/development environment when I'm using the SQLite shell I can use the up/down arrows to use previous commands, but on my prod environment I keep getting "^]]A"

Re: [sqlite] SQLite C# differences between Windows Server 2008 and 2003

Sure here is the code. using (SQLiteConnection sql_con = new SQLiteConnection("Data Source=C:\\Path\\To\\File\\docuidb.db;")) { sql_con.Open(); SQLiteCommand sql_cmd = sql_con.CreateCommand(); string CommandText = "update MyTable set field1='test',

Re: [sqlite] SQLite C# differences between Windows Server 2008 and 2003

Can you post the code? And why do you need to use the SQLite.Interop.dll ? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of james.johns...@mysmartplans.com Sent: Thursday, June 20, 2013 9:59 AM To: 'sqlite-users@sqlite.org'

[sqlite] SQLite C# differences between Windows Server 2008 and 2003

Hello, I am using System.Data.SQLite.dll version 1.0.82.0 and SQLite.Interop.dll to connect to some SQLite databases using C# Web Services. The code is working fine on Windows Server 2008, but on 2003 it is not releasing the database at the end of the call. It is extremely simple code,

Re: [sqlite] sqlite DB's disk image getting malformed

This sounds very much like bug described in 7.4 in http://www.sqlite.org/howtocorrupt.html, except for the SQLite version. Are you sure that it's version 3.6.14.2 and not newer? Best regards, Filip Navara On Wed, Jun 19, 2013 at 9:09 PM, Dhiraj Sadhwani wrote: > Hello, >

Re: [sqlite] Sqlite accepts invalid column names

On Thu, Jun 20, 2013 at 10:26 AM, Rob Golsteijn wrote: > > SELECT a.col2, >b.col2, >a.b.col2,-- invalid column name >b.a.col2,-- invalid column name >a.a.col2,-- invalid column name >b.b.col2,--

Re: [sqlite] False Error 'no such collation sequence'

On Thu, Jun 20, 2013 at 10:43 AM, Tom Holden wrote: > > Richard, I think I know why your test of the command line shell returned > no error – an index is needed on the field with the missing collation. I am > guessing what has changed is that the query optimiser now

Re: [sqlite] False Error 'no such collation sequence'

(my apology for trying to reply to a message in the archive which has no reply-to feature – I hope it ends up in the right thread) Richard, I think I know why your test of the command line shell returned no error – an index is needed on the field with the missing collation. I am guessing what

[sqlite] Sqlite accepts invalid column names

Hi List, I made a copy-paste mistake, resulting in something that looked to me as invalid syntax for column names, but sqlite accepted it. The invalid column names are shown by the following example: .header on -- pragma is deprecated, but shows what happens pragma full_column_names=1;

Re: [sqlite] Deadlock with multiple connections

On 6/19/2013 4:58 PM, J Decker wrote: I have a sqlite database that ends up with 3 connections from the same program in a single thread. The first, only SELECT statements are used. The second, is opened, a BEGIN TRANSACTION issued and then some inserts. I end up opening a 3rd connection to

Re: [sqlite] Deadlock with multiple connections

Have you committed the transaction on connection1? --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of J Decker > Sent: Wednesday, 19 June, 2013

Re: [sqlite] Deadlock with multiple connections

On 19 Jun 2013, at 9:58pm, J Decker wrote: > The insert on the 3rd connection is blocked 'SQLITE_BUSY'. > After 1 second, a COMMIT on the 1st connection is issued, and stays > blocked with 'SQLITE_BUSY'. > > so then the program alternates retrying the last commands since busy

Re: [sqlite] sqlite DB's disk image getting malformed

On Wed, Jun 19, 2013 at 3:09 PM, Dhiraj Sadhwani wrote: > Hello, > I have sqlite code amalgamation(version 3.6.14.2.) as a part of a > dylib/dll. > > Any idea if the usage above mentioned has a significant flaw. > I highly appreciate any help on what could be causing the

Re: [sqlite] sqlite DB's disk image getting malformed

On 19 Jun 2013, at 8:09pm, Dhiraj Sadhwani wrote: > Any idea if the usage above mentioned has a significant flaw. Can you just make this clear ... When you have noticed errors in the results of "pragma integrity_check" you then start again with a database that does not

Re: [sqlite] False Error 'no such collation sequence'

On Wed, Jun 19, 2013 at 11:18 AM, Tom Holden wrote: > I use the SQLiteSpy compilation of SQLite3 which recently upgraded from > pre SQLite 3.7.8 to pre 4.2.0. I also occasionally use the SQLite3 Windows > command-line shell. I am now encountering an error with the current >

[sqlite] sqlite DB's disk image getting malformed

Hello, I have sqlite code amalgamation(version 3.6.14.2.) as a part of a dylib/dll. As part of exported apis from this dylib we open a sql session/connection and keep it open for a longish duration and share the session handle among different threads of the same process for doing transactions on

[sqlite] Deadlock with multiple connections

I have a sqlite database that ends up with 3 connections from the same program in a single thread. The first, only SELECT statements are used. The second, is opened, a BEGIN TRANSACTION issued and then some inserts. I end up opening a 3rd connection to the database and issue another begin

[sqlite] False Error 'no such collation sequence'

I use the SQLiteSpy compilation of SQLite3 which recently upgraded from pre SQLite 3.7.8 to pre 4.2.0. I also occasionally use the SQLite3 Windows command-line shell. I am now encountering an error with the current versions that I did not with earlier ones – sorry, I cannot be precise at this

[sqlite] FTS performance (mobile devices)

The title mentions mobile devices for the sole reason - the criteria for the performance are much higher than in the desktop world. For example our application (where we consider adding FTS) may run into memory problems on some weaker devices when we increase memory consumption by approx. 10 MB.

Re: [sqlite] Connection between SQLite - Other Databases

On Thu, 20 Jun 2013 04:34:19 + "Reddy C. balaji" wrote: > Hi All, > Please let me know the options available to connect to other > databases ( Oracle, MSSQL , MySQL etc ) from SQLite. For example, to connect > from Oracle to other databases DBLink

[sqlite] Unlock Notify problems

Hello, I am currently having some problems with the unlock notify and getting in a state of deadlock. I am using code based on http://www.sqlite.org/unlock_notify.html, with the latest sqlite. The setup is as follows: - WAL is on - Multi Threaded is on - Temp store is memory - Database is

Re: [sqlite] Connection between SQLite - Other Databases

Hi! You can check Libgda which allows you to open several connections (e.g. 1 for SQLite and 1 for Oracle), bind them together in different namespaces, and execute SQL code on all the bound connections at the same time. Regards, Vivien On 20 June 2013 06:34, Reddy C. balaji

Re: [sqlite] Connection between SQLite - Other Databases

I use a virtual table module for reading from oracle tables. A configuration script interrogates the Oracle DB for tables/views conforming to a naming regime and issues CREATE VIRTUAL TABLE IF NOT EXISTS USING oracle (''); for each matching DB object. The XCreate function uses the oracle name

Re: [sqlite] Connection between SQLite - Other Databases

On 20 Jun 2013, at 5:34am, "Reddy C. balaji" wrote: > Please let me know the options available to connect to other databases ( > Oracle, MSSQL , MySQL etc ) from SQLite. None. SQLite doesn’t understand TCP/IP. It can’t connect to anything. Simon.

[sqlite] anyone know how to use ta-lib api to the sqlite database?

the ta-lib.org, the ta-lib library could use in EXCEL, I wanna use it in the sqlite database, but I don't know how to write the c or c++ code to load the ta-lib api in sqlite database, anyone know it? ___ sqlite-users mailing list