SQLite and Desktop Application

I have to make a Desktop Application with database ( SQLite )..

How do i setup sqlite?

+ I would like to make a *.db data which contains tables and then in java application i want to operate with this *.db file as a database. Is that ok and possible?

I'm not entirely sure how to set up SQLite but it cant be much different from the other database types out there, just make sure you have a connector for it.

You might also want to look into Apache Derby or db4o :: Java & .NET Object Database ? Open Source Object Database, Open Source Persistence, Oodb

// Json

for sqlite you don't need apache or something

just create a database file and install sqlite driver for java

it's a "db in a file"

Yeah, same goes for Apache Derby or DB4O as well. I was just recommending other ones you could use.

// Json

i have a question.. how to install driver for sqlite?

into which maps i have to put sqlitejdbc-v056.jar?

and what classpaths to i have to setup?

pleease help me:S

You can either put the jar in your webapp/WEB-INF/lib folder or in your application server/lib folder.

// Json

but if i take the application to another computer, it won't work

Ship the jar with your app in the lib folder.

// Json

what exactly do i have to do? i don't understand you (i'm a little bad at english)

damn i'm noob :P

Well I guess you might have other jar files that you pack into your application as well, so you must have a lib folder somewhere, or am I wrong?

// Json

i have
C:\Program Files\Java\jdk1.6.0_16\jre\lib
C:\Program Files\Java\jre6\lib

and Application.java and Application.class on some another place

When you develop your programs I take it you have some sort of source folder and some sort of lib folder to store code and libraries used.

You can just put the jar file of the sqlite connector in the lib folder.

Try googling for some information on how to ship third party jars with your application.

// Json