Skip site navigation (1) Skip section navigation (2)

Re: psql & java

From: Guillaume Rousse <Guillaume(dot)Rousse(at)univ-reunion(dot)fr>
To: Peter Mount <peter(at)retep(dot)org(dot)uk>, Frank Bax <fbax(at)execulink(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: psql & java
Date: 2000-04-18 17:46:48
Message-ID: 00041821570400.02734@agathe (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfacespgsql-sql
Le mar, 18 avr 2000, Peter Mount a crit :
> On Tue, 18 Apr 2000, Frank Bax wrote:
> 
> > I want to write a Java applet that retrieves/updates data in a psql
> > database.  I am running Apache and psql on a single OpenBSD server.  I
> > currently use PHP for dynamic pages; which has been fine up to now for
> > presenting data, but I can see the day coming where some processing at the
> > client side would be useful; so I want to take a closer look at java.  I
> > have been told by someone who knows little more than I do, that I need
> > servlets to get at my data with java applets.  When I go to the apache
> > site, I see references to Jakarta, Tomcat, Java-Apache, JSERV and JSSI.
> 
> Ok, I've not played with servlets (had no need) but here goes (and
> someone correct me if I'm wrong):
> 
> Java-Apache is the name of the project to integrate Java with Apache.
> 
> JSERV is a web server that embeds java into web pages which is processed
> on the server. This is not JavaScript, but similar to PHP or ASP.
No. JServ is a servlet engine for Apache. It doesn't support JSP alone, and
it's not compliant with last version of servlet API. Tomcat, a part of Jakarta
project, is its successor : it's both a servlet (2.2 compliant) engine and a
JSP (1.1)  engine.

> Not sure what JSSI is. I have heared of Jakarta & Tomcat, but thats all.
It's Java Server-Side Include, the java equivalent of traditionnal SSI.

> > But I couldn't find summaries that tell what these things are.  Can someone
> > tell me exactly which of the above components (and more?) I need to install
> > to make this work?  How do they fit together?
You'll need PostgreSQL for storing the data, JDBC driver to access them, Tomcat
to process your servlets and JSP pages, Apache eventually if you also have
plain HTML, as Tomcat is stand-alone capable. I don't know for JSSI, but for
accessing data, this already largely enough.


-- 
Guillaume Rousse
Iremia - Universit de la Runion

Sleep doesn't exists. Just lack of cafeine.

In response to

Responses

pgsql-sql by date

Next:From: kaiqDate: 2000-04-18 17:54:14
Subject: Re: Outer joins
Previous:From: Manuel LemosDate: 2000-04-18 17:39:54
Subject: Re: Connecting website with SQL-database.....

pgsql-interfaces by date

Next:From: Joseph ShraibmanDate: 2000-04-18 18:28:16
Subject: Re: where to close statement ?
Previous:From: Manuel LemosDate: 2000-04-18 17:39:54
Subject: Re: Connecting website with SQL-database.....

pgsql-general by date

Next:From: Ron PetersonDate: 2000-04-18 18:14:21
Subject: Re: Win32 Install
Previous:From: Manuel LemosDate: 2000-04-18 17:39:54
Subject: Re: Connecting website with SQL-database.....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group