pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedpsql & java
5+ messages / 5 participants
[nested] [flat]
* psql & java
@ 2000-04-18 16:18 Frank Bax <fbax@execulink.com>
0 siblings, 1 reply; 5+ messages in thread
From: Frank Bax @ 2000-04-18 16:18 UTC (permalink / raw)
To: pgsql-interfaces
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.
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? Does
JDBC require ODBC?
Frank
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: psql & java
@ 2000-04-18 17:18 Peter Mount <peter@retep.org.uk>
parent: Frank Bax <fbax@execulink.com>
0 siblings, 1 reply; 5+ messages in thread
From: Peter Mount @ 2000-04-18 17:18 UTC (permalink / raw)
To: Frank Bax <fbax@execulink.com>; +Cc: pgsql-interfaces
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/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: psql & java
@ 2000-04-18 17:46 Guillaume Rousse <Guillaume.Rousse@univ-reunion.fr>
parent: Peter Mount <peter@retep.org.uk>
0 siblings, 1 reply; 5+ messages in thread
From: Guillaume Rousse @ 2000-04-18 17:46 UTC (permalink / raw)
To: Peter Mount <peter@retep.org.uk>; Frank Bax <fbax@execulink.com>; +Cc: pgsql-interfaces
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 Réunion
Sleep doesn't exists. Just lack of cafeine.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: psql & java
@ 2000-04-19 01:11 Joe Shevland <shevlandj@kpi.com.au>
parent: Guillaume Rousse <Guillaume.Rousse@univ-reunion.fr>
0 siblings, 0 replies; 5+ messages in thread
From: Joe Shevland @ 2000-04-19 01:11 UTC (permalink / raw)
To: Guillaume Rousse <Guillaume.Rousse@univ-reunion.fr>; +Cc: Peter Mount <peter@retep.org.uk>; Frank Bax <fbax@execulink.com>; pgsql-interfaces
The only thing I'd add to all of this is that applets can do your
client-side processing for you if you like... your applet needs
to open a URLConnection to a servlet on the webserver, and this
way you can communicate via SSL, plain ol' TCP/IP, object input/output
streams etc. But effectively the servlet you can think of like
a CGI application running on the server. JDBC can also take place
from the applet to the server, but there's issues between how IE's
VM and Netscape's VM instantiate JDBC driver's (IE does not, as
per usual, follow the standard).
Regards,
Joe
Guillaume Rousse wrote:
>
> 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 Réunion
>
> Sleep doesn't exists. Just lack of cafeine.
--
Joe Shevland
Principal Consultant
KPI Logistics Pty Ltd
http://www.kpi.com.au
mailto:shevlandj@kpi.com.au
"I'm not under the alkafluence of inkahol that some thinkle peep I am.
It's just the drunker I sit here the longer I get."
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: psql & java
@ 2000-04-19 06:45 Peter Mount <petermount@it.maidstone.gov.uk>
0 siblings, 0 replies; 5+ messages in thread
From: Peter Mount @ 2000-04-19 06:45 UTC (permalink / raw)
To: 'Guillaume Rousse' <Guillaume.Rousse@univ-reunion.fr>; Peter Mount (Home) <peter@retep.org.uk>; Frank Bax <fbax@execulink.com>; +Cc: pgsql-interfaces
Thanks for the corrections ;-)
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
-----Original Message-----
From: Guillaume Rousse [mailto:Guillaume.Rousse@univ-reunion.fr]
Sent: Tuesday, April 18, 2000 6:47 PM
To: Peter Mount; Frank Bax
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] psql & java
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 Réunion
Sleep doesn't exists. Just lack of cafeine.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2000-04-19 06:45 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-04-18 16:18 psql & java Frank Bax <fbax@execulink.com>
2000-04-18 17:18 ` Peter Mount <peter@retep.org.uk>
2000-04-18 17:46 ` Guillaume Rousse <Guillaume.Rousse@univ-reunion.fr>
2000-04-19 01:11 ` Joe Shevland <shevlandj@kpi.com.au>
2000-04-19 06:45 RE: psql & java Peter Mount <petermount@it.maidstone.gov.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox