Обсуждение: 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
On Sun, Oct 28, 2012 at 4:31 PM, Craig Ringer <ringerc@ringerc.id.au> wrote:
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.
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.