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