[sqlite] Probleme with Java SQLite Wrapper

2005-07-04 Thread majed chatti 
my problem is a litel stange.
Firstly I work with eclipse and Java SQLite Wrapper dounloaded at this site and 
that normally works well http://www.ch-werner.de
 
I open a sqlite DB and I execute the query
I do same think like this
 
query = "select name from sqlite_master where type=table";
DataBase DB;
TableResult TR;
 
DB.open(file.db);
TR = DB.GetTable(query);
System.out.println(TR);
 
 
in my DB I have 15 tables but after the System.out I found same times 15, 12, 
10
 
I really dont know why if there is a problem it will be wrrong evry time no
is same one know same think about this???
 
 thanks for help
 
Majed CHATTI.
 
 


-
 Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
 Téléchargez le ici !

RE: [sqlite] all of tables of a DB

2005-05-17 Thread majed chatti 
Thanks for help 

--- "Downey, Shawn" <[EMAIL PROTECTED]> a écrit:
> 
> SELECT name FROM sqlite_master WHERE type = 'table';
> 
> Shawn M. Downey
> MPR Associates
> 632 Plank Road, Suite 110
> Clifton Park, NY 12065
> 518-371-3983 x3 (work)
> 860-508-5015 (cell)
> 
> 
> -Original Message-
> From: majed chatti [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, May 17, 2005 8:00 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] all of tables of a DB
> 
> Houw can I get all of tables of a data base
> 
> I think its same think like
> 
> >select * from sysobjects;
> 
> but it dose not work 
> 
> 
>   
> 
>   
>   
>
_
> 
> Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de
> stockage pour vos mails, photos et vidéos ! 
> Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com
> 






_ 
Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos mails, 
photos et vidéos ! 
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com

[sqlite] all of tables of a DB

2005-05-17 Thread majed chatti 
Houw can I get all of tables of a data base

I think its same think like

>select * from sysobjects;

but it dose not work 






_ 
Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos mails, 
photos et vidéos ! 
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com

Re: [sqlite] SQLite Java Wrapper?

2005-05-14 Thread majed chatti 
I tried this version javasqlite-20050514.tar.gz I think it's the newest one.
 
If there is a newest one send me the url pleas
 
thanks for help

Christian Werner <[EMAIL PROTECTED]> a écrit:
majed chatti wrote:
> 
> I tried to use the SQLite Java Wrapper wich I
> download froh here http://www.ch-werner.de/javasqlite/
> I extract it
> I do
> 
> $./configure
> $make
> 
> but I have this errors
> 

Please try out the new version from the above mentioned
website. It should now compile with SQLite versions 3.0.7
up to the latest (and greatest) 3.2.1.

Cheers,
Christian


-
 Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos mails, 
photos et vidéos !
Créez votre Yahoo! Mail

[sqlite] SQLite Java Wrapper?

2005-05-13 Thread majed chatti 
I tried to use the SQLite Java Wrapper  wich I
download froh here http://www.ch-werner.de/javasqlite/
I extract it
I do 

$./configure
$make

but I have this errors

./libtool gcc -I -o native/mkconst native/mkconst.c \
/usr/local/lib/libsqlite3.la
gcc -I -o native/mkconst native/mkconst.c 
/usr/local/lib/libsqlite3.so -Wl,--rpath
-Wl,/usr/local/lib -Wl,--rpath -Wl,/usr/local/lib
gcc: native/mkconst: No such file or directory
native/mkconst.c:1:20: sqlite.h: No such file or
directory
native/mkconst.c: In function `main':
native/mkconst.c:29: error: `SQLITE_OK' undeclared
(first use in this function)
native/mkconst.c:29: error: (Each undeclared
identifier is reported only once
native/mkconst.c:29: error: for each function it
appears in.)
native/mkconst.c:30: error: `SQLITE_ERROR' undeclared
(first use in this function)
native/mkconst.c:31: error: `SQLITE_INTERNAL'
undeclared (first use in this function)
native/mkconst.c:32: error: `SQLITE_PERM' undeclared
(first use in this function)
native/mkconst.c:33: error: `SQLITE_ABORT' undeclared
(first use in this function)
native/mkconst.c:34: error: `SQLITE_BUSY' undeclared
(first use in this function)
native/mkconst.c:35: error: `SQLITE_LOCKED' undeclared
(first use in this function)
native/mkconst.c:36: error: `SQLITE_NOMEM' undeclared
(first use in this function)
native/mkconst.c:37: error: `SQLITE_READONLY'
undeclared (first use in this function)
native/mkconst.c:38: error: `SQLITE_INTERRUPT'
undeclared (first use in this function)
native/mkconst.c:39: error: `SQLITE_IOERR' undeclared
(first use in this function)
native/mkconst.c:40: error: `SQLITE_CORRUPT'
undeclared (first use in this function)
native/mkconst.c:41: error: `SQLITE_NOTFOUND'
undeclared (first use in this function)
native/mkconst.c:42: error: `SQLITE_FULL' undeclared
(first use in this function)
native/mkconst.c:43: error: `SQLITE_CANTOPEN'
undeclared (first use in this function)
native/mkconst.c:44: error: `SQLITE_PROTOCOL'
undeclared (first use in this function)
native/mkconst.c:45: error: `SQLITE_EMPTY' undeclared
(first use in this function)
native/mkconst.c:46: error: `SQLITE_SCHEMA' undeclared
(first use in this function)
native/mkconst.c:47: error: `SQLITE_TOOBIG' undeclared
(first use in this function)
native/mkconst.c:48: error: `SQLITE_CONSTRAINT'
undeclared (first use in this function)
native/mkconst.c:49: error: `SQLITE_MISMATCH'
undeclared (first use in this function)
native/mkconst.c:50: error: `SQLITE_MISUSE' undeclared
(first use in this function)
make: *** [native/mkconst] Erreur 1

Thanks for help







_ 
Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos mails, 
photos et vidéos ! 
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com

RE: [sqlite] java class to connect to an sqlite DB

2005-05-13 Thread majed chatti 
thank you but I'm sory I'm on linux.
any one have a java class to connect to an an sqlite
data base. Working on linux.

thaks for help

--- Steve O'Hara <[EMAIL PROTECTED]> a
écrit :

> 
> Assuming you're on Windows, try this for size.
> Put the this DLL and the latest sqlite3.dll from the
> web site in the path
> and away you go.
> The Java source should be self explainatory.
> 
> Steve
> 
> -Original Message-
> From: majed chatti [mailto:[EMAIL PROTECTED]
> Sent: 12 May 2005 18:34
> To: sqlite-users@sqlite.org
> Subject: [sqlite] java class to connect to an sqlite
> DB
> 
> 
> Hi all
> any one have a java class to connect to an an sqlite
> data base.
> 
> thaks for help
> 
> 
> 
> 
> 
> 
>

> _
> Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de
> stockage pour vos mails,
> photos et vidéos !
> Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com
> 
> 
> 







__
Découvrez le nouveau Yahoo! Mail : 250 Mo d'espace de stockage pour vos mails ! 
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com/

[sqlite] java class to connect to an sqlite DB

2005-05-12 Thread majed chatti 
Hi all
any one have a java class to connect to an an sqlite
data base.

thaks for help






_ 
Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos mails, 
photos et vidéos ! 
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com