Thread: jdbc "proxy" server ...

jdbc "proxy" server ...

From
"Marc G. Fournier"
Date:
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 ...


Re: jdbc "proxy" server ...

From
Peter Wiley
Date:
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
>


Re: jdbc "proxy" server ...

From
"Marc G. Fournier"
Date:
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
> >
>
>


Re: jdbc "proxy" server ...

From
Peter Wiley
Date:
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.


Re: jdbc "proxy" server ...

From
Peter T Mount
Date:
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/

Re: jdbc "proxy" server ...

From
Gunnar Rønning
Date:
* "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/