From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
---|---|
To: | dave(dot)rosckes(at)gmail(dot)com |
Cc: | Dave Cramer <pg(at)fastcrypt(dot)com>, PgJDBC <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Fwd: [GENERAL] Trying to get SSPI/JDBC working |
Date: | 2014-12-03 11:22:30 |
Message-ID: | 547EF276.3060805@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general 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
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2014-12-03 11:40:27 | Re: TRUNCATE and CREATE TABLE LIKE for foreign tables |
Previous Message | sri harsha | 2014-12-03 11:22:17 | TRUNCATE and CREATE TABLE LIKE for foreign tables |
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2014-12-03 11:24:49 | Re: performance question: protocol v2 vs v3 |
Previous Message | Adrian Klaver | 2014-12-02 20:40:41 | Re: Trying to get SSPI/JDBC working |