Re: psql & java

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.

Not sure what JSSI is. I have heared of Jakarta & Tomcat, but thats all.

> 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?

> Do I also need JDBC?

To access postgres from Java, you will need JDBC.

> Does JDBC require ODBC?

No. There are four types of JDBC driver, and ours is Type 4, which means
its written in pure java, and will run anywhere.

Peter

--      Peter T Mount peter@retep.org.uk     Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgresJava PDF Generator: http://www.retep.org.uk/pdf