Re: [sqlite] I need a SQLite3 Wrapper for Java.

[Christian Werner]

"[EMAIL PROTECTED]" wrote:
> 
> Hello,
> 
> and yes I do. I've tried to port, but without success.

Please try out http://www.ch-werner.de/javasqlite/javasqlite-20040919.tar.gz
Right now (since 3.0.7 is out, big thank you to DRH!) it somewhat began to work
on Linux. As usual it is very preliminary experimental pre-alpha and can contain
lots of memory leaks and other kinds of bugs. I'd be happy if somebody hacks
a Makefile for Windoze.

Cheers,
Christian

Re: [sqlite] I need a SQLite3 Wrapper for Java.

[Kurt Welgehausen]

> I wish to get the count of unique entries in a particular field

http://www.sqlite.org/omitted.html

RE: [sqlite] I need a SQLite3 Wrapper for Java.

[Downey, Shawn]

Hello, I am new to sqlite and I wish to get the count of unique entries
in a particular field.  The table is created as follows:

create table tablename
  (
field_id char(10) not null ,
fieldname char(100)
  );
create unique index findex on tablename 
(field_id);

I get an error with the query:
select (distinct fieldname) from tablename;

but this gives me the wrong answer:  
select distinct (fieldname) from tablename;

Sorry for such a novice question and thank you for any help.

Shawn M. Downey
MPR Associates
632 Plank Road, Suite 110
Clifton Park, NY 12065
518-371-3983 x3 (work)
860-508-5015 (cell)

Re: [sqlite] I need a SQLite3 Wrapper for Java.

[[EMAIL PROTECTED]]

Hello,
and yes I do. I've tried to port, but without success.
Best regards
Am Thu, 16 Sep 2004 00:31:54 -0700 hat Randy J. Ray <[EMAIL PROTECTED]>  
geschrieben:

Cory Nelson wrote:
I take it you were too lazy to look at the SQLite Wrappers section?
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
Perhaps he did, and looked closely enough to notice that both Java  
wrappers are for SQLite 2.X only.

Randy

--
###
#
#   alex-t.de
#   Softwareentwicklung & Webentwicklung
#   Alex Tugarev
#   --
#   mobil:  (+49 179) 909 379 2
#   privat: (+49 29 41) 959 702 7
#   --
#   email:  [EMAIL PROTECTED]
#
###

Re: [sqlite] I need a SQLite3 Wrapper for Java.

[Randy J. Ray]

Cory Nelson wrote:
I take it you were too lazy to look at the SQLite Wrappers section?
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
Perhaps he did, and looked closely enough to notice that both Java wrappers are 
for SQLite 2.X only.

Randy
--
"""
Randy J. RayCampbell, CAhttp://www.rjray.org   [EMAIL PROTECTED]
Silicon Valley Scale Modelers: http://www.svsm.org

Re: [sqlite] I need a SQLite3 Wrapper for Java.

[Cory Nelson]

I take it you were too lazy to look at the SQLite Wrappers section?
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers


On Thu, 16 Sep 2004 08:23:42 +0200, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Hello,
> 
> Is there a SQLite3 Wrapper for Java available? Didn't find one. Please
> help me.
> 
> Very best regards
> 
> --
> ###
> #
> #   alex-t.de
> #   Softwareentwicklung & Webentwicklung
> #   Alex Tugarev
> #   --
> #   mobil:  (+49 179) 909 379 2
> #   privat: (+49 29 41) 959 702 7
> #   --
> #   email:  [EMAIL PROTECTED]
> #
> ###
> 



-- 
Cory Nelson
http://www.int64.org