Thread: jdbc "proxy" server ...
have a database behind a firewall ... we'd like to make connections available to that machine through a machine outside of the firewall, so that its a secure connection to the "proxy", and in-secure from proxy->database ... the 'clients' will be written in java ...
I've got a pile of RMI/JDBC code that does something damn close if not exactly what you want. Client & server ends. I wrote it to allow interactive queries & display the results in a Java applet or application then extended it to allow interactive and/or batch insert/update/delete functionality with (optionally) an email back telling you what happened to your batch SQL. It's known to work against Informix, Oracle 8i and I think PostgreSQL - certainly there's no reason why it won't asit just loads the appropriate JDBC driver. Email me if you're interested. Peter Wiley On Wed, 22 Aug 2001, Marc G. Fournier wrote: > > have a database behind a firewall ... we'd like to make connections > available to that machine through a machine outside of the firewall, so > that its a secure connection to the "proxy", and in-secure from > proxy->database ... > > the 'clients' will be written in java ... > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
something maybe that would fit into contrib? :) On Thu, 23 Aug 2001, Peter Wiley wrote: > > I've got a pile of RMI/JDBC code that does something damn close if not > exactly what you want. Client & server ends. I wrote it to allow > interactive queries & display the results in a Java applet or application > then extended it to allow interactive and/or batch insert/update/delete > functionality with (optionally) an email back telling you what happened to > your batch SQL. > > It's known to work against Informix, Oracle 8i and I think PostgreSQL - > certainly there's no reason why it won't asit just loads the appropriate > JDBC driver. > > Email me if you're interested. > > Peter Wiley > > On Wed, 22 Aug 2001, Marc G. Fournier wrote: > > > > > have a database behind a firewall ... we'd like to make connections > > available to that machine through a machine outside of the firewall, so > > that its a secure connection to the "proxy", and in-secure from > > proxy->database ... > > > > the 'clients' will be written in java ... > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > > >
I don't mind. Wrote it to do one particular job, extended its functionality a couple times, most recently to implement a crude pooling system. The code needs work (what doesn't when it gets genericised... ) but it'd be a good starting point at least. I own the IP (as much as anyone owns IP to stuff built on top of other peoples' work) so there's no hassle releasing it as GPL code or whatever. I'm leaving this job in 2 weeks and going to another one so - how fast do you need the code? Another alternative for you is RmiJdbc. I looked at this but decided to 'roll my own' as I wanted the ability to submit batch jobs and do a couple other unusual things like crosstab datasets - in effect turn a 'deep' table structure into a 'wide' one for easy display in a JTable etc. The batch stuff is pretty generic but not the crosstab code; never needed to. > > something maybe that would fit into contrib? :) > > On Thu, 23 Aug 2001, Peter Wiley wrote: > > > > > I've got a pile of RMI/JDBC code that does something damn close if not > > exactly what you want. Client & server ends. I wrote it to allow > > interactive queries & display the results in a Java applet or application > > then extended it to allow interactive and/or batch insert/update/delete > > functionality with (optionally) an email back telling you what happened to > > your batch SQL. > > > > It's known to work against Informix, Oracle 8i and I think PostgreSQL - > > certainly there's no reason why it won't asit just loads the appropriate > > JDBC driver.
Quoting "Marc G. Fournier" <scrappy@hub.org>: > > have a database behind a firewall ... we'd like to make connections > available to that machine through a machine outside of the firewall, so > that its a secure connection to the "proxy", and in-secure from > proxy->database ... > > the 'clients' will be written in java ... Marc, in the past I used sucessfully the proxygw tool from the fwtk toolkit. Although it wasn't that secure (pg_hba.conf was effectively useless as it saw just the firewall ip), it worked. Peter -- Peter Mount peter@retep.org.uk PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
* "Marc G. Fournier" <scrappy@hub.org> wrote: | | have a database behind a firewall ... we'd like to make connections | available to that machine through a machine outside of the firewall, so | that its a secure connection to the "proxy", and in-secure from | proxy->database ... | | the 'clients' will be written in java ... What about tunneling your connections through ssh ? -- Gunnar Rønning - gunnar@polygnosis.com Senior Consultant, Polygnosis AS, http://www.polygnosis.com/