4 Replies Latest reply on Nov 2, 2012 6:49 PM by jorsol

Why is my JDBC4-compliant driver loaded as "non-JDBC-compliant"?

rraposa Oct 18, 2011 6:34 PM

I am slightly confused by something - possibly because I don't understand this correctly. If I deploy the PostgreSQL JDBC4 driver, which contains the META-INF/services/java.sql.Driver file containg the proper driver class name, then when I deploy the JAR I get the following output:

Deploying non-JDBC-compliant driver class org.postgresql.Driver (version 9.0)

If I remove the java.sql.Driver file from the JAR and deploy it again, I do not get any warning and it appears to deploy fine:

Starting deployment of "postgresql-9.0-801.jar"

Deployed "postgresql-9.0-801.jar"

Am I doing something wrong by using the java.sql.Driver file? According to the documentation, the file java.sql.Driver is requried to make the JAR JDBC4-compliant, so why does the output contradict this and tell me that I am deploying a non-JDBC-compliant driver?

Thanks!

Rich

1. Re: Why is my JDBC4-compliant driver loaded as "non-JDBC-compliant"?

jesper.pedersen Oct 19, 2011 10:14 AM (in response to rraposa)

Because org.postgresql.Driver#jdbcCompliant() returns false. So you can ignore that for now, and I'm sure that the PostgreSQL JDBC people would like code contributions

(Go Raiders ! )
Actions
2. Re: Why is my JDBC4-compliant driver loaded as "non-JDBC-compliant"?

rraposa Oct 19, 2011 10:31 AM (in response to jesper.pedersen)

Thanks Jesper - mystery solved! Seems like an easy fix for Postgres - I may checkout the source code and take a look at it.

And I would tell you where I would like the Raiders to go, but this is a G-rated forum!
Actions
3. Re: Why is my JDBC4-compliant driver loaded as "non-JDBC-compliant"?

jesper.pedersen Oct 19, 2011 10:44 AM (in response to rraposa)

Well, there is more to it than changing the method implementation, but the PostgreSQL JDBC people can give you an idea what is missing.

Still feeling the pain from week 1, eh ?
Actions
4. Re: Why is my JDBC4-compliant driver loaded as "non-JDBC-compliant"?

jorsol Nov 2, 2012 6:49 PM (in response to rraposa)
In the postgresql jdbc api:
public boolean jdbcCompliant()
Report whether the driver is a genuine JDBC compliant driver. A driver may only report "true" here if it passes the JDBC compliance tests, otherwise it is required to return false. JDBC compliance requires full support for the JDBC API and full support for SQL 92 Entry Level.

For PostgreSQL, this is not yet possible, as we are not SQL92 compliant (yet).
Specified by:
jdbcCompliant in interface java.sql.Driver
Actions

Go to original post