Обсуждение: Re: Postgresql jdbc driver for PG version 9.5

Poul Kristensen wrote:
> I am trying to use the jdbc driver in eclipse but get the following 
> How come?
> if the driver is not org.postgresql.Driver,
> which should I then use. 
> 
> PostgreSQL JDBC Driver 42.2.5
> Found in: jar:file:/home/me/lib/postgresql-42.2.5.jar!/org/postgresql/Driver.class
> 
> The PgJDBC driver is not an executable Java program.

I have redirected the question to the JDBC list.

What does your code look like?

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

Poul Kristensen wrote:
> Thank you. Yes and it says:
> 
> DB.DRIVER    The fully qualified class name of the JDBC driver. For Java DB, this is
org.apache.derby.jdbc.EmbeddedDriver.For MySQL, this is com.mysql.jdbc.Driver.
 
> 
> How do I get org.postgresql.Driver to put in db.driver(e.g: db.driver=org.postgresql.Driver)? That is my problem! 

The documentation
(https://jdbc.postgresql.org/documentation/head/load.html)
has it:

  Prior to Java 1.6, the driver had to be loaded by the application - either by calling

  Class.forName("org.postgresql.Driver");

  or by passing the driver class name as a JVM parameter.

  java -Djdbc.drivers=org.postgresql.Driver example.ImageViewer

  These older methods of loading the driver are still supported but they are no longer necessary.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

Poul Kristensen wrote:
> Hi and thank you for responding but I have to put a class as db.driver value into  String driver and
> then  loaded this way Class.forName(driver);
> It works with the oracle driver. 
> I am using Postgresql JDBC Driver 42.2.25 and Driver.class eg:_ db.driver=Driver.class 
> but is rejected as not executable. It should be very simple. Does anyone use the Driver.class?

I do it all the time, and it works just fine.

Just use "org.postgresql.Driver" as the driver class name and make
sure the JAR file is on your class path.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com