Thread: JDBC4 Postgresql Driver

Hello PostgreSQL Global Development Group:

I’m in process of determining an export control tag (ECCN) for JDBC4.  I’d appreciate if you could answer the below questions.

How is JDBC4 different from PostgreSQL, psqlODBC?

Does JDBC4 contain embedded encryption, or special software technology?

Thank you.

Laura M. Boyer
IT Leader SYS, SW, HW & Test Engineering Tools – GE Aviation Systems

T – (616) 241-7702
M – (616) 204-2952
F – (616) 619-5963
laura.boyer@ge.com

3290 Patterson Avenue SE, MS 1B3
Grand Rapids, MI 49512-1991, U.S.A.

Laura,

See my answers inline below.

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca


On Fri, Oct 26, 2012 at 4:03 PM, Boyer, Laura (GE Aviation, US)
<laura.boyer@ge.com> wrote:
> Hello PostgreSQL Global Development Group:
>
> I’m in process of determining an export control tag (ECCN) for JDBC4.  I’d
> appreciate if you could answer the below questions.
>
> How is JDBC4 different from PostgreSQL, psqlODBC?

PostgreSQL is a database server, JDBC4 is strictly speaking an API,
but I presume you are asking about the client library that implements
it and allows java programs to connect to the PostgreSQL database
server.
psqlODBC is very similar client library which implements the ODBC API
as opposed to the JDBC API.

>
> Does JDBC4 contain embedded encryption, or special software technology?
>
No

You're welcome

Dave

On 10/27/2012 04:03 AM, Boyer, Laura (GE Aviation, US) wrote:
> HelloPostgreSQL Global Development Group:
>
> I’min process of determining an export control tag(ECCN)for JDBC4. I’d
> appreciate if you could answer the below questions.
>
> How is JDBC4 different from PostgreSQL, psqlODBC?

Dave covered that one, I'd just like to explain what JDBC is.

JDBC is an access API. PgJDBC provides an implementation of the service
provider side of that API so that applications that use JDBC can use it
to talk to PostgreSQL. It's "glue" code that connects JDBC to PostgreSQL.

In the same way, psqlODBC is "glue" code to connect ODBC API users to
PostgreSQL.

For more on JDBC, see:

  http://en.wikipedia.org/wiki/Java_Database_Connectivity
  http://www.oracle.com/technetwork/java/javase/jdbc/index.html
  http://docs.oracle.com/javase/tutorial/jdbc/index.html

> Does JDBC4 containembedded encryption, or special software technology?

PgJDBC *uses* encryption but it does not contain any crypto
implementations. The cryptography support is provided by the underling
Java runtime environment. It is used for things like SSL sockets and
client certificate authentication.

"Special software technology" is hard to nail down to anything specific.
What are your concerns? Is there a particular definition of that term
that you rely on? I would be surprised if there was anything you'd be
concerned by, but it's impossible to say without knowing what "special
software technology" actually means.

--
Craig Ringer

Also, JDBC is developed under the BSD license.  PgODBC is develop under the GPL License.

http://jdbc.postgresql.org/license.html
http://psqlodbc.projects.pgfoundry.org/

--
Regards,
Richard Broersma Jr.