Re: Fwd: [GENERAL] Trying to get SSPI/JDBC working - Mailing list pgsql-jdbc

From Craig Ringer
Subject Re: Fwd: [GENERAL] Trying to get SSPI/JDBC working
Date
Msg-id 547EF276.3060805@2ndquadrant.com
Whole thread Raw
In response to Fwd: [GENERAL] Trying to get SSPI/JDBC working  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
> JDBC connection url:
> "jdbc:postgresql://localhost/postgresDB?integratedSecurity=true"

I don't know where you got "integratedSecurity=true". The only reference
I can find to that is in Microsoft's documentation for MS SQL server.
There is no such parameter in PgJDBC, nor in core PotsgreSQL.

Until very recently (i.e. last week) PgJDBC did not support SSPI
natively. It was potentially possible to use it via direct access to the
Kerberos ticket, but it required lots of setup and was generally painful
and impractical.

I implemented SSPI support for PgJDBC a few weeks ago, and merged it
into the core driver this week. If you download the latest git tree of
PgJDBC and compile it, you will be able to use SSPI. No additional
parameters should be required.

There is not yet a binary release of the driver with SSPI support, but
it's pretty easy to compile PgJDBC if you've used git before. Just clone
the repository from https://github.com/pgjdbc/pgjdbc and then "ant -lib
lib all" in the source tree. You can also "ant -lib lib dist" if you
want to make a distribution zip file. See the README shown at the bottom
of https://github.com/pgjdbc/pgjdbc for more details.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Fwd: [GENERAL] Trying to get SSPI/JDBC working
Next
From: Craig Ringer
Date:
Subject: Re: performance question: protocol v2 vs v3