Hi zhang jie,
I don’t think there was a problem on the creation and updating of the
database. You see, I log every sql statement execute from database creation and
updates, and I didn’t see any sql error or any error in that case. Also, I open
the database using command line in linux and it wo
Im using a software ipswitch WS_FTP to transfer the file from linux to
windows. Im not sure before if I configured it to binary transfer but I
tried it again and make sure to configure it and set it to binary
transfer, still im getting the same result.
Currently, Im trying to create the datab
Hi ryan bel brillo,
First of all,thank you for your reply.
The problem is not a compatibility with database created in linux and
windows . I downloaded source code sqlite-2.8.17.tar.gz through your website
under windows OS. But I gunziped and cross-compiled it for
AT91ARM9200(deve
"Randy J. Ray" <[EMAIL PROTECTED]> wrote:
> This may be a basic SQL question, but I can't find the answer in the
> SQL-related documents on the site, so...
>
> I have a field in a table that is typed as text, though it is 99% of the time
> numerical. (It's used to track issue numbers of magazines,
Dave Brown <[EMAIL PROTECTED]> wrote:
Yeah if I put BEGIN IMMEDIATE in thread1 as well, then it works, but
as you
say I don't see why I need to do this. Perhaps the implicit
transaction
which is created in my 1-line INSERT statement isn't an immediate
transaction??
It's probably not, but even i
Randy J. Ray wrote:
This may be a basic SQL question, but I can't find the answer in the
SQL-related documents on the site, so...
I have a field in a table that is typed as text, though it is 99% of the time
numerical. (It's used to track issue numbers of magazines, which for some
esoteric publi
ryan bel brillo wrote:
> Is there a compatibility problem with database created in linux and
> windows? I remember this problem on occurs on sqlite version 2.6.2 or
> earlier.. Or is there a problem in the way I create the database?
How are you getting the file from Linux to Windows? If you used
Hi all,
Im new in this list and with sqlite. Im not sure if this topic have
been discussed before.
Anyway, I have this problem regarding sqlite. I created a c program
that would create a new sqlite database from some sql file then update
it every five minutes using sql statement stored in
This may be a basic SQL question, but I can't find the answer in the
SQL-related documents on the site, so...
I have a field in a table that is typed as text, though it is 99% of the time
numerical. (It's used to track issue numbers of magazines, which for some
esoteric publications may be alphanu
- Original Message
> From: Joe Wilson <[EMAIL PROTECTED]>
> The disk read/write reordering optimization only works if the
> database file is contiguous on the disk and not fragmented.
> --- [EMAIL PROTECTED] wrote:
> > Basically, the db file is accessed with seek + read/write operations
Yeah if I put BEGIN IMMEDIATE in thread1 as well, then it works, but as you
say I don't see why I need to do this. Perhaps the implicit transaction
which is created in my 1-line INSERT statement isn't an immediate
transaction??
Seems like there should be a flag or pragma or something to force all
Dave Brown <[EMAIL PROTECTED]> wrote:
Igor - ok I tried this, and now I am getting SQLITE_BUSY returned
when I try
to sqlite3_exec my "BEGIN IMMEDIATE" statement. So I then put that
in a
do-while( rc == SQLITE_BUSY) loop, and now my first thread is getting
SQLITE_BUSY returned when it tries to e
Igor - ok I tried this, and now I am getting SQLITE_BUSY returned when I try
to sqlite3_exec my "BEGIN IMMEDIATE" statement. So I then put that in a
do-while( rc == SQLITE_BUSY) loop, and now my first thread is getting
SQLITE_BUSY returned when it tries to execute the 1-line INSERT statement
(with
Dave Brown <[EMAIL PROTECTED]> wrote:
Hi all - I am seeing a strange problem where I have multiple threads
trying to both do writes to the database, and one thread gets back an
immediate SQLITE_BUSY even though *both* have set the busy handler to
10 seconds, and the write operation is much much f
Hi all - I am seeing a strange problem where I have multiple threads trying
to both do writes to the database, and one thread gets back an immediate
SQLITE_BUSY even though *both* have set the busy handler to 10 seconds, and
the write operation is much much faster than this (on the order of
millise
On 3/13/06, Rafal Rusin <[EMAIL PROTECTED]> wrote:
> > Maybe you want to call this:
> >
> > " int sqlite3_busy_timeout(sqlite3*, int ms);
> >
> > This routine sets a busy handler that sleeps for a while when a table
> > is locked. The handler will sleep multiple times until at least "ms"
> > m
I had major problems with multithreaded access to a sqlite database file
on an NFS mount. While not exactly your scenerio there might be some
similarities. I had to come up with a crazy scheme to allow only one
thread to access the sqlite database at a time. See below.
I came up with a sch
> Maybe you want to call this:
>
> " int sqlite3_busy_timeout(sqlite3*, int ms);
>
> This routine sets a busy handler that sleeps for a while when a table
> is locked. The handler will sleep multiple times until at least "ms"
> milliseconds of sleeping have been done. After "ms" milliseconds o
[EMAIL PROTECTED] wrote:
BTW, yes, the schema is 'as is' and i have to convert it,
but how to converts rows to columns and add to other
columns? ;-)
I'm not sure I understand this question. Without knowing any details
about your problem, I'd suggest something like this. Change tbl from
this:
On 3/13/06, Rafal Rusin <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I'm having problems with famous multithread bug
> "Database is locked".
> I tried to work around that with sqlite3_busy_timeout
> or busy_handler, but with no success. I had deadlocks.
> I was using version 3.3.4 on Debian Linux.
> Cou
[EMAIL PROTECTED] wrote:
> hi all,
>
> it there a way to execute a SQL query generated by SELECT ?
> for eg. :
> select 'insert into plan (personid, curseid, statid) select
> tbl.excelid, ' || id || ',status.id from tbl, status where
> tbl.' || fldname || ' = status.name ;' from curses;
>
A plan
Hello,
I'm having problems with famous multithread bug
"Database is locked".
I tried to work around that with sqlite3_busy_timeout
or busy_handler, but with no success. I had deadlocks.
I was using version 3.3.4 on Debian Linux.
Could You give me some links to discussion on that
topic?
Maybe there
On 3/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Igor,
>
> thank you very much!
>
> BTW, yes, the schema is 'as is' and i have to convert it,
> but how to converts rows to columns and add to other
> columns? ;-)
You return the result to a string variable in your program and then execute
On Fri, 10 Mar 2006 [EMAIL PROTECTED] wrote:
>- Original Message
>> From: Christian Smith <[EMAIL PROTECTED]>
>
>> But SQLite depends on the OS caching abilities for much of it's
>> performance. Removing it is like saying SQLite is rubbish on Intel
>> processors after testing on a i486.
>
Igor,
thank you very much!
BTW, yes, the schema is 'as is' and i have to convert it,
but how to converts rows to columns and add to other
columns? ;-)
Regards,
e.
Цитат на писмо от Igor Tandetnik <[EMAIL PROTECTED]>:
> [EMAIL PROTECTED] wrote:
> > it there a way to execute a SQL query generate
[EMAIL PROTECTED] wrote:
it there a way to execute a SQL query generated by SELECT ?
for eg. :
select 'insert into plan (personid, curseid, statid) select
tbl.excelid, ' || id || ',status.id from tbl, status where
tbl.' || fldname || ' = status.name ;' from curses;
No, not really. You have a ra
Darren Duncan <[EMAIL PROTECTED]> wrote:
> At 7:05 PM -0500 3/12/06, [EMAIL PROTECTED] wrote:
> >Let me amplify this by pointing out that I have zero interest
> >in taking SQLite in the direction of The Third Manifesto. Those
> >who want to do so are welcomed - encouraged even - to fork the
> >tre
hi all,
it there a way to execute a SQL query generated by SELECT ?
for eg. :
select 'insert into plan (personid, curseid, statid) select
tbl.excelid, ' || id || ',status.id from tbl, status where
tbl.' || fldname || ' = status.name ;' from curses;
regards
emily
-
Sl
OK thank you.
John
On 13/03/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> "john.newby" <[EMAIL PROTECTED]> wrote:
> > Hi, I sent this request yesterday from my other address but wasn't sure
> if
> > anyone had received it as my other email address didn't receive it but
> both
> > address a
29 matches
Mail list logo
