I want to finish that confusion! 1st point: JSP means Java Server Pages and runs on an Apache TomCat server. The java code runs ON server and NOT in client!
2nd: Then the db files don't need be directed accessed by the web client, this is unsafe. Exemple: DriverManager.getConnection("jdbc:sqlite:[DB_PATH]"); Where DB_PATH is the path ON the server like "jdbc:sqlite:./test.db", and the data will be created if doesn't exists in the same path of current jsp page, if you don't want this you can put somethink like "jdbc:sqlite:C:/www/[my_site]/data/test.db", you need ensure that directory exists the sqlite only create the database! ----- "Pavel Ivanov" <paiva...@gmail.com> escreveu: > Dev, > > Do you understand that SQLite is not a server application and it has > no access control facilities? It is just some library code that helps > accessing files that have some well-defined internal format. So your > application will be able to access any database accessible by the user > running your executable. In case of JSP page it will be whatever user > account your IIS server is running under. And database path like > '//ipaddress/spiceworks/db/spiceworks_prod.db' most probably means > that you try to access a file located in the network at a shared > folder spiceworks of the server ipaddress. So is that path accessible > to the user running IIS? I'm not sure though what "out of memory" > errors mean. Probably just badly written jdbc driver. > > > Pavel > > On Wed, Aug 25, 2010 at 3:14 PM, Dev Movva <mov...@yahoo.com> wrote: > > Hello, > > > > Can some one please help me how do I connect to SQLite from a JSP page with > > windows authentication mode? > > > > Thank you, > > > > Dev > > > > --- On Wed, 8/25/10, Richard Hipp <d...@sqlite.org> wrote: > > > > > > From: Richard Hipp <d...@sqlite.org> > > Subject: Re: SQlite JDBC driver - need help > > To: "Dev Movva" <mov...@yahoo.com> > > Date: Wednesday, August 25, 2010, 3:02 PM > > > > > > jdbc is maintained separately by Chris Werner. I don't know anything about > > it. If you post on sqlite-users@sqlite.org you might be able to get > > somebody there to help you. > > > > > > On Wed, Aug 25, 2010 at 2:47 PM, Dev Movva <mov...@yahoo.com> wrote: > > > > > > > > > > > > > > Dear Richard, > > > > I am trying to connect to SQLite from my JSP page and not sure where I am > > not doing it right but no luck with it. I posted it on the google forums at > > http://groups.google.com/group/sqlitejdbc/browse_thread/thread/841538d7b3679678# > > > > > > I am wondering if you can shed some light on my issue and help me wiht > > this. > > > > All I need is how do I connect to SQLite from a JSP page using windows > > authentication (like integratedSecurity=true while connecting to a SQL > > server). All our users should be able to see view the data with their > > windows authentication. Any help is greately appreciated. > > > > Thank you in advance, > > > > Dev > > > > > > > > -- > > D. Richard Hipp > > d...@sqlite.org > > > > > > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvolvimento/Development Polibrás Brasil Software Ltda. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users