Dear Patel,
When does your java program crashes ? At start-up when you open the
database ? When you perform DB queries ?
Which Java library do you use to interface sqlite ? How do you use it ?
Do you perform queries that retrieve big quantity of data ?
SQLite can be tuned to use more or less me
Dear Tom,
There is a pragma that allows you retrieving the structure of a table :
PRAGMA table_info(table_name);
From the result of the command, you can programmatically create your
triggers.
Regards,
Brice
2017-07-15 21:11 GMT+02:00 Thomas Flemming :
> Hi Sqlite-users,
>
> I'm busy doing a u
Hello,
Maybe replace "ZONAGES_SHP_TAB2016".'identifiant' by
"ZONAGES_SHP_TAB2016"."identifiant"
or by
"ZONAGES_SHP_TAB2016".identifiant ?
Regards,
Brice
2016-08-31 15:21 GMT+02:00 Igor Korot :
> Hi,
>
> On Wed, Aug 31, 2016 at 9:14 AM, REGIANY Lucie
> wrote:
> >
> > HELLO
> > I WOULD DO SELECT
Dear Simon,
I am a little worried with your last post because, I must admint that I do
not take special measures in my application when such errors occur to
guarantee that no more DB access are performed.
I have thus the following questions :
1. What would be the proper reaction to SQLITE_FUL
Dear all,
Just to give some feedback on this problem : I changed the HDD of my
client, and configured his anti-virus to exclude the database directory.
I don't know which one of those actions solved the problem, but it now
seems to work like a charm. I will still wait a few days/weeks to be sure
Dear all,
Thank you very much for those advices. I will try them and get back if it
does not solve the issue.
Regarding the advice of Simon on HDD starting to fail, I have one more
question. In fact, I suspected this, as my client has other problems with
his computer. But, in such case, I expecte
OK, but if this scenario was at the origin of my problem, I guess I would
have such a log each time a db query freezes ?
If yes, then there is probably another problem, as I am sure I got such
freezes with no such logs from sqlite.
By the way, if the antivirus is at the origin of the problem, whi
Dear Richard,
Thanks for your answer. The version of sqlite I am using is the 3.9.1
amalgamation.
But, as stated above, I am not sure my freeze problem is linked to the
strange log observed at my client as this log does not systematically
appears on database queries that freeze. Those logs someti
Dear all,
I experience some performance issues with SQLite.
I have an application that uses SQLite to store user data, including agenda
information. One of my client has a relatively big database (around 1.3Gb).
I have indexed the database so that the queries take a reasonable time to
execute.
I
9 matches
Mail list logo