Re: Connecting to postgresql using SSPI via JDBC

SSPI is supported only on windows clients. If you try authenticating
from a Linux client against a SSPI requiring server you will get an
error similar to the JDBC driver exception indicating that it is not
supported. Supporting SSPI only on windows for Java would require
linking with native code which we don't want to do. Unless you need
NTLM support, I don't see why you wouldn't use GSSAPI which is supported
on all platforms including the JDBC driver.

Kris Jurka

On 6/28/2010 4:45 PM, Idan Miller wrote:
> postgres supports native sspi support (and not gssapi) in the server
> side, but that support is missing from the client.
> So I would expect an implementation on the client side (right now a not
> supported authentication type exception is thrown when attempting to
> connect with sspi)..
>
> Idan
>
> On Mon, Jun 28, 2010 at 10:06 PM, Kris Jurka <books(at)ejurka(dot)com
> <mailto:books(at)ejurka(dot)com>> wrote:
>
> Implement what? The JDBC driver does support GSSAPI authentication
> although it is a bit cumbersome to setup (and the only documentation
> is in the list archives).
>
> Kris Jurka
>
>
> On 6/27/2010 12:52 AM, Idan Miller wrote:
>
> Is someone willing to implement that?
> It's a really important feature for us since the JDBC-ODBC bridge
> doesn't work well with bytea columns (it truncates them even
> though we
> declared maxlongvarchar and maxvarchar to be very big).
>
> Thanks,
> Idan.
>
> On Thu, Jun 17, 2010 at 9:55 PM, Kris Jurka <books(at)ejurka(dot)com
> <mailto:books(at)ejurka(dot)com>
> <mailto:books(at)ejurka(dot)com <mailto:books(at)ejurka(dot)com>>> wrote:
>
>
>
> On Thu, 17 Jun 2010, Idan Miller wrote:
>
> As far as I know, I an configure gssapi on windows as
> well, right?
> So techincaly, if I manage to do so, I will get the same
> "sspi like"
> authentication, right?
>
>
> Yes.
>
> Kris Jurka
>
>
>
>