I'm currently investigating a problem with my application, SQLite
3.2.5 and a database located on a Mac OSX Server network share that
does not seem to repro with the SQLite 3.1.3 that ships with Mac OSX
4.1. Specifically if I place a SQLite database file on a folder on a
remote network
You learn something new everyday. I didn't know that was the behaviour of
INTEGER PRIMARY KEY. All other databases I've worked with require you to
explicitly declare an identiy/autoincrement column. I was strictly looking
at the metadata returned by PRAGMA. SQLite is certainly a different
Steve O'Hara wrote:
The attraction of a pure Java solution is obvious - if a client wants
this app to run on VMS then I've got to create another JNI library that
is VMS specific. Id you've ever written any JNI you'll know why this
isn't an all together pleasurable experience.
Also -
[EMAIL PROTECTED] wrote:
hsql is pretty smart in java, the storage is editable by texpad it is only
consisted of sql statements. It s an in memory only DB
It can store and use on disk db as well.
I was evaluating it for an embedded DB, seemed prety easy to use. I
haven't used it in
As I mentioned in my question, I have already written a JNI library for
Windows and Solaris for SQLite they work fine. And no Jay, you can't
"link" DLLs/Shared Libraries into Java, you can bind to them via a JNI
container.
The attraction of a pure Java solution is obvious - if a client wants
> Uh, why isn't your first choice simply, "Use SQLite from Java"?
> Surely calling C libraries is something the Java folks have worked out
> how to do many years ago? Or what am I missing here? What is the
> attraction of "pure Java"?
Java libraries linked with C (via JNI) generally have to run
On Mon, Oct 24, 2005 at 09:58:53PM +0100, Steve O'Hara wrote:
> I've been worn down by my quest for a comparable product to SQLite
> written in pure Java and have come to the conclusion that it doesn't
> exit. I've looked at Derby, QED, Axion, blah blah and I'm not too
> My next port of call is
On 10/24/05, Steve O'Hara <[EMAIL PROTECTED]> wrote:
> I've been worn down by my quest for a comparable product to SQLite
> written in pure Java and have come to the conclusion that it doesn't
> exit. I've looked at Derby, QED, Axion, blah blah and I'm not too
> impressed by any of them.
> None
hsql is pretty smart in java, the storage is editable by texpad it is only
consisted of sql statements. It s an in memory only DB
Benjamin Filippi
Capital Fund Management
6 boulevard Haussmann 75009 Paris
Tel: +33 1 49 49 59 30
Fax: +33 1 47 70 17 40
[EMAIL PROTECTED]
http://www.cfm.fr
I have used SQLite in a whole bundle of applications and I love it.
However, I've got an app that's being written in Java - I've got a JNI
library (Solaris & Windows) for SQLite, but I really want something
platform independent.
I've been worn down by my quest for a comparable product to SQLite
Hi,
As Christian said, probably your heap is corrupted. Your backtrace
clearly indicates that.
The typical errors that lead to this are
- you free() some memory twice
- you free more or less memory than you malloc() ed
- you overrun a buffer on the heap
valgrind is a good tool to detect such
tanx for the advice...but how to avoid heap corruption? and why does it happen?
anyway, finally here is the backtrace:
*** glibc detected *** malloc(): memory corruption: 0x0808e078 ***
Program received signal SIGABRT, Aborted.
[Switching to Thread -1213548864 (LWP 4348)]
0xe410 in
- Original Message -
From: "Peterson Luiz" <[EMAIL PROTECTED]>
I´m using "UTF8Encoding = true" on my conection string in C#, but I
can´t get any special character (like á,ç,ã) in my query results.
If I open the database with any DBTool software, I can see that all the
special
Hi,
I´m using "UTF8Encoding = true" on my conection string in C#, but I can´t
get any special character (like á,ç,ã) in my query results.
If I open the database with any DBTool software, I can see that all the
special caracters are in their right place in the registries, but when I
select then in
Hello,
Just trying sqlLite in Delphi whith the libraries of Tim Anderson. Looks
all extremely good to me :) One question: Am I right that the only
'forbitten' value in a stringfield is a NULL ? Probably because the
parser only know the end of an SQL statement if it is NULL.
I also see I can
On Mon, 24 Oct 2005 [EMAIL PROTECTED] wrote:
>Hi,
>i have a very strange problem using sqlite with a C application...
>i create a database of images, storing image data and other information about
>it.
> ...in all the attempt of new databases i did, but it was frequently 37),
>during data reading
On Sun, Oct 23, 2005 at 09:24:58PM -0700, David M. Cook wrote:
> On Sat, Oct 22, 2005 at 12:19:04PM -0700, Mario Gutierrez wrote:
>
> > CRETE TABLE my_table (
> > id INTEGER PRIMARY KEY,
> > ...
> > )
> >
> > This would meet your criteria, but 'id' is not an autoincremented column.
>
> Sorry,
Kervin L. Pierre wrote:
Lloyd Dupont wrote:
But to my disbelief there is (apparently) no way to get the size of a
blob (other than loading it :-()
I'd like to be corrected if I am wrong, but I
don't think there is anyway to do this in
SQLite, besides simply storing the size of the
blob
David Finlayson wrote:
I'm new to sqlite3 and couldn't find any documentation on the .import
command, so a pointer to the docs may be all that's needed. Sorry if
this is simple...
My problem is that I have been trying to .import null values from a
delimited text file (colon is delimiter) with
Well, I guess I was not clear in my explanations.
I'm already doing my own locking, that's the problem!
But I'm not sure how to improve it.
...
At which stage the data will be saved it and.
that will froze the application because the search/select already get the
database lock.
If
Hi,
i have a very strange problem using sqlite with a C application...
i create a database of images, storing image data and other information about
it.
If i access to a single row (=3Dimage) of the database, with a single execution
of the program, it's all ok, and i see the selected image.
But if
Am 21.10.2005 um 11:58 schrieb Michael J. Sviridov:
Using sqlite 3.2.7 in a multi-threaded C++ application:
I've got two thread's (with unique db handles), each thread does the
following:
BEGIN EXCLUSIVE TRANSACTION;
(60,000 INSERT OR REPLACE statements into the same table)
COMMIT
Juan,
> Can you please provide instructions for this or publish it? Compiling
> with bcc55 has eluded us for quite a while. Please include exact steps
> and versions of each program used.
I've published SQLite327makefiles.zip file on my site, section "Utilities"
as resulting example of quite
Actually, on SQLite, 'INTEGER PRIMARY KEY' does designate a special
type of autoincremented column.
The internal 64 bit rowid is used directly in that case, which is
essentially 'free' storage.
http://www.sqlite.org/faq.html#q1
http://www.sqlite.org/lang_createtable.html
24 matches
Mail list logo