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" <[email protected]> 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 <[email protected]> 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 <[email protected]> wrote:
> >
> >
> > From: Richard Hipp <[email protected]>
> > Subject: Re: SQlite JDBC driver - need help
> > To: "Dev Movva" <[email protected]>
> > 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 [email protected] you might be able to get
> > somebody there to help you.
> >
> >
> > On Wed, Aug 25, 2010 at 2:47 PM, Dev Movva <[email protected]> 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
> > [email protected]
> >
> >
> >
> >
> > _______________________________________________
> > sqlite-users mailing list
> > [email protected]
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
