Re: [HACKERS] Java LISTEN/NOTIFY client library work-around

2011-12-02 Thread Merlin Moncure
On Thu, Dec 1, 2011 at 6:21 AM, Joel Jacobson wrote: > 2011/12/1 Kris Jurka >> >> >> >> On Wed, 30 Nov 2011, Joel Jacobson wrote: >> >> > As you know, LISTEN/NOTIFY is broken in the Java client library. You >> > have to >> > do a SELECT 1 in a while-loop to receive the notifications. >> > >> > ht

Re: [HACKERS] Java LISTEN/NOTIFY client library work-around

2011-12-02 Thread Joel Jacobson
2011/12/1 Kris Jurka > > > On Wed, 30 Nov 2011, Joel Jacobson wrote: > > > As you know, LISTEN/NOTIFY is broken in the Java client library. You > have to > > do a SELECT 1 in a while-loop to receive the notifications. > > > > http://jdbc.postgresql.org/documentation/head/listennotify.html > > Thi

Re: [HACKERS] Java LISTEN/NOTIFY client library work-around

2011-11-30 Thread Kris Jurka
On Wed, 30 Nov 2011, Joel Jacobson wrote: > As you know, LISTEN/NOTIFY is broken in the Java client library. You have to > do a SELECT 1 in a while-loop to receive the notifications. > > http://jdbc.postgresql.org/documentation/head/listennotify.html This documentation is out of date. Current

Re: [HACKERS] Java LISTEN/NOTIFY client library work-around

2011-11-30 Thread Joel Jacobson
On 30 nov 2011, at 13:27, Jan Urbański wrote: > On 30/11/11 13:07, Joel Jacobson wrote: >> Hi, >> >> As you know, LISTEN/NOTIFY is broken in the Java client library. You have >> to do a SELECT 1 in a while-loop to receive the notifications. >> >> http://jdbc.postgresql.org/documentation/head/li

Re: [HACKERS] Java LISTEN/NOTIFY client library work-around

2011-11-30 Thread Andrew Dunstan
On 11/30/2011 07:27 AM, Jan Urbański wrote: On 30/11/11 13:07, Joel Jacobson wrote: Hi, As you know, LISTEN/NOTIFY is broken in the Java client library. You have to do a SELECT 1 in a while-loop to receive the notifications. http://jdbc.postgresql.org/documentation/head/listennotify.html

Re: [HACKERS] Java LISTEN/NOTIFY client library work-around

2011-11-30 Thread Jan Urbański
On 30/11/11 13:07, Joel Jacobson wrote: Hi, As you know, LISTEN/NOTIFY is broken in the Java client library. You have to do a SELECT 1 in a while-loop to receive the notifications. http://jdbc.postgresql.org/documentation/head/listennotify.html Is there some other library with a proper impleme

[HACKERS] Java LISTEN/NOTIFY client library work-around

2011-11-30 Thread Joel Jacobson
Hi, As you know, LISTEN/NOTIFY is broken in the Java client library. You have to do a SELECT 1 in a while-loop to receive the notifications. http://jdbc.postgresql.org/documentation/head/listennotify.html Is there some other library with a proper implementation where you don't have to spam the d

Re: [HACKERS] JAVA Support

2006-09-29 Thread Bruce Momjian
Henry B. Hotz wrote: > Well, that's why I was pushing SASL instead of GSSAPI. There are > multiple mechanisms that are actually in use. > > PAM turned out not to be sufficiently specified for cross-platform > behavioral compatibility, and it only does password checking anyway. > Calling it

Re: [HACKERS] JAVA Support

2006-09-29 Thread Henry B. Hotz
On Sep 29, 2006, at 12:31 AM, Magnus Hagander wrote: However, that doesn't change that some people would like us to support GSSAPI, and there may be some benefit (additional applications, better network authentication, etc.) for doing so. If we can get additional programmers to code the

Re: [HACKERS] JAVA Support

2006-09-29 Thread Henry B. Hotz
On Sep 28, 2006, at 9:35 PM, Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: Is there any reason why we haven't built a generic authentication API? Something like PAM, except cross platform? We're database geeks, not security/crypto/authentication geeks. What makes you think

Re: [HACKERS] JAVA Support

2006-09-29 Thread Magnus Hagander
This being SASL: > > I know I tried to make > > it work on win32 once and failed miserably. (Then again, I've > failed > > on Linux as well, but not quite as bad. And it's not included in > all > > Linux distributions, at least it wasn't when I checked a while > back) > > Well, I know Redhat has

Re: [HACKERS] JAVA Support

2006-09-29 Thread Magnus Hagander
> > However, that doesn't change that some people would like us to > support > > GSSAPI, and there may be some benefit (additional applications, > better > > network authentication, etc.) for doing so. If we can get > additional > > programmers to code the support (i.e. Sun, JPL) I don't see any >

Re: [HACKERS] JAVA Support

2006-09-29 Thread Magnus Hagander
> > I would if we could get some -hackers buy in on the idea. Adding > more > > and more auth methods is something they're not excited about > unless > > there's a good reason (which I think this is). > > Actually, I've been trying to get some of the Sun engineers to > contribute patches for Sola

Re: [HACKERS] JAVA Support

2006-09-28 Thread Joshua D. Drake
Tom Lane wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: >> Is there any reason why we haven't built a generic authentication API? >> Something like PAM, except cross platform? > > We're database geeks, not security/crypto/authentication geeks. What > makes you think we have any particular

Re: [HACKERS] JAVA Support

2006-09-28 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > Is there any reason why we haven't built a generic authentication API? > Something like PAM, except cross platform? We're database geeks, not security/crypto/authentication geeks. What makes you think we have any particular competence to do the abov

Re: [HACKERS] JAVA Support

2006-09-28 Thread Joshua D. Drake
Josh Berkus wrote: > Henry, > >> Sun demonstrated that you could build the existing Kerberos support >> with the current Solaris 11 beta's. They opened the "native" MIT >> Kerberos API for outside use. > > Yes, and this will be available via the supported version in Solaris 10 > Update > 4.

Re: [HACKERS] JAVA Support

2006-09-28 Thread Tom Lane
Josh Berkus writes: > However, that doesn't change that some people would like us to support > GSSAPI, and there may be some benefit (additional applications, better > network authentication, etc.) for doing so. If we can get additional > programmers to code the support (i.e. Sun, JPL) I don't se

Re: [HACKERS] JAVA Support

2006-09-28 Thread Henry B. Hotz
On Sep 28, 2006, at 3:01 PM, Josh Berkus wrote: Kris, I would if we could get some -hackers buy in on the idea. Adding more and more auth methods is something they're not excited about unless there's a good reason (which I think this is). Actually, I've been trying to get some of the Sun e

Re: [HACKERS] JAVA Support

2006-09-28 Thread Josh Berkus
Henry, > Sun demonstrated that you could build the existing Kerberos support > with the current Solaris 11 beta's. They opened the "native" MIT > Kerberos API for outside use. Yes, and this will be available via the supported version in Solaris 10 Update 4. However, that doesn't change that

Re: [HACKERS] JAVA Support

2006-09-28 Thread Henry B. Hotz
On Sep 28, 2006, at 3:03 PM, Josh Berkus wrote: Tom, It would depend in part on the size of the patch, and on whether there are any arguments for supporting GSSAPI besides "Java can't do Kerberos". What would it buy for a libpq user? According to the Solaris Security engineers, GSSAPI is mo

Re: [HACKERS] JAVA Support

2006-09-28 Thread Henry B. Hotz
I cc'ed Tom Lockhart because he *used* to be core, and I know where he works. No response expected. On Sep 28, 2006, at 2:11 PM, Magnus Hagander wrote: f) SASL support is available in current Java as well as C. SASL libraries are included (or at least loadable) on MacOS, Solaris 10+, and Lin

Re: [HACKERS] JAVA Support

2006-09-28 Thread Henry B. Hotz
On Sep 28, 2006, at 2:24 PM, Tom Lane wrote: "Magnus Hagander" <[EMAIL PROTECTED]> writes: As for the other part - will core accept this - I can't answer that. It would depend in part on the size of the patch, and on whether there are any arguments for supporting GSSAPI besides "Java can't d

Re: [HACKERS] JAVA Support

2006-09-28 Thread Josh Berkus
Tom, > It would depend in part on the size of the patch, and on whether > there > are any arguments for supporting GSSAPI besides "Java can't do > Kerberos". > What would it buy for a libpq user? According to the Solaris Security engineers, GSSAPI is more secure than using the Kerberos headers.

Re: [HACKERS] JAVA Support

2006-09-28 Thread Josh Berkus
Kris, > I would if we could get some -hackers buy in on the idea. Adding > more and more auth methods is something they're not excited about > unless there's a good reason (which I think this is). Actually, I've been trying to get some of the Sun engineers to contribute patches for Solaris authe

Re: [HACKERS] JAVA Support

2006-09-28 Thread Magnus Hagander
> > As for the other part - will core accept this - I can't answer that. > > It would depend in part on the size of the patch, and on > whether there are any arguments for supporting GSSAPI besides > "Java can't do Kerberos". > What would it buy for a libpq user? I don't know, really ;-) It see

Re: [HACKERS] JAVA Support

2006-09-28 Thread Tom Lane
"Magnus Hagander" <[EMAIL PROTECTED]> writes: > As for the other part - will core accept this - I can't answer that. It would depend in part on the size of the patch, and on whether there are any arguments for supporting GSSAPI besides "Java can't do Kerberos". What would it buy for a libpq user?

Re: [HACKERS] JAVA Support

2006-09-28 Thread Magnus Hagander
> > As for the other part - will core accept this - I can't > answer that. I > > do beleive that there is a point to it, given that Java will then > > support it natively, but I'm not core. I'm unsure if there > is a clear > > view on the merits of adding more authentication options.. > > Fr

Re: [HACKERS] JAVA Support

2006-09-28 Thread Henry B. Hotz
On Sep 28, 2006, at 12:42 PM, Magnus Hagander wrote: 2) If I were willing to add a GSSAPI or SASL layer as an alternative to the bare Krb 5 support would anyone be willing to help with the supporting mods to the pg_hba.conf parsing, and configure? Sure, I can help out with that. I've done a b

Re: [HACKERS] JAVA Support

2006-09-28 Thread Magnus Hagander
> 2) If I were willing to add a GSSAPI or SASL layer as an > alternative to the bare Krb 5 support would anyone be willing > to help with the supporting mods to the pg_hba.conf parsing, > and configure? Sure, I can help out with that. I've done a bunch of work on the current kerberos stuff (toh

Re: [HACKERS] JAVA Support

2006-09-28 Thread Kris Jurka
On Thu, 28 Sep 2006, Henry B. Hotz wrote: I take it you're not volunteering to help with my second request. ;-) I would if we could get some -hackers buy in on the idea. Adding more and more auth methods is something they're not excited about unless there's a good reason (which I think

Re: [HACKERS] JAVA Support

2006-09-28 Thread Henry B. Hotz
On Sep 28, 2006, at 10:52 AM, Kris Jurka wrote: On Thu, 28 Sep 2006, Henry B. Hotz wrote: It appears that the JDBC client doesn't include the Kerberos support that the C clients do. Java doesn't have accessible Kerberos support. It wraps Kerberos in GSSAPI which requires the server to

Re: [HACKERS] JAVA Support

2006-09-28 Thread Kris Jurka
On Thu, 28 Sep 2006, Henry B. Hotz wrote: It appears that the JDBC client doesn't include the Kerberos support that the C clients do. Java doesn't have accessible Kerberos support. It wraps Kerberos in GSSAPI which requires the server to support GSSAPI instead of plain Kerberos. So, tw

[HACKERS] JAVA Support

2006-09-28 Thread Henry B. Hotz
It appears that the JDBC client doesn't include the Kerberos support that the C clients do. So, two questions: 1) Is there an alternative JDBC client that's just a glue layer instead of a complete re-implementation? 2) If I were willing to add a GSSAPI or SASL layer as an alternative to

Re: [HACKERS] java access to the backend (non jdbc)?

2003-02-13 Thread Bruce Momjian
. > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Bruce Momjian > Sent: Thursday, February 13, 2003 7:18 PM > To: Shahbaz Chaudhary > Cc: [EMAIL PROTECTED] > Subject: Re: [HACK

Re: [HACKERS] java access to the backend (non jdbc)?

2003-02-13 Thread Shahbaz Chaudhary
hbaz C. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bruce Momjian Sent: Thursday, February 13, 2003 7:18 PM To: Shahbaz Chaudhary Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] java access to the backend (non jdbc)? Well, we ha

Re: [HACKERS] java access to the backend (non jdbc)?

2003-02-13 Thread Bruce Momjian
Well, we have jdbc at jdbc.postgresql.org. --- Shahbaz Chaudhary wrote: > Hi All, > I was wondering if there is a libq or libqxx type library written in > java. Even if it is done through jni. I would like to do some > exp

[HACKERS] java access to the backend (non jdbc)?

2003-02-13 Thread Shahbaz Chaudhary
Hi All, I was wondering if there is a libq or libqxx type library written in java. Even if it is done through jni. I would like to do some experiments, perhaps make a utility that reads server information such as currently executing query, current locks, amount of disk/ram taken up by pgsql. Bas

Re: [HACKERS] java virtual machine

2001-10-25 Thread Gunnar Rønning
* tweekie <[EMAIL PROTECTED]> wrote: | | I asked this question a while back but got no response - is there any way of | creating a Java stored procedure in a postgres database ? I can see that | there is a built-in PL/sql type of environment and a python one but it would | be nice if I could m

[HACKERS] java virtual machine

2001-10-25 Thread tweekie
Hello all I asked this question a while back but got no response - is there any way of creating a Java stored procedure in a postgres database ? I can see that there is a built-in PL/sql type of environment and a python one but it would be nice if I could migrate Java stored procedures in an

Re: [HACKERS] java

2001-10-15 Thread Bruce Momjian
> Hello > > Easy question - does Postgres support Java stored procedures ? No, only PL/pgSQL, Perl, TCL, and Python. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Av

[HACKERS] java

2001-10-15 Thread None
Hello Easy question - does Postgres support Java stored procedures ? Chris Posted Via Usenet.com Premium Usenet Newsgroup Services -- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---

[HACKERS] Java Classes

2001-01-11 Thread excalibur
Can PostgreSQL 7.1 store java classes or objects?

[HACKERS] Java and Postgresql

2000-12-29 Thread Mike S. Avelar
Hey... I'm just learning how to do all this db stuff and I'm kinda crippled because I've never used SQL. Here is what I'm doing. I've got pgaccess working, it works greate, I create databases and sql queries with it. I've got JRun running for my servlet engine, it also works great. Now when try