Thread: 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
Hi Poul,
The jdbc driver is a library, if you run the jar file like java -jar postgresql-42.2.5.jar, it will output that is not an executable Java program.
You should use it following the conventions of JDBC API (https://docs.oracle.com/javase/tutorial/jdbc/).
Regards,
On Fri, Sep 7, 2018 at 9:37 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
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
Hi Jorge
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!
TIA
Poul
Den fre. 7. sep. 2018 kl. 11.33 skrev Jorge Solórzano <jorsol@gmail.com>:
Hi Poul,The jdbc driver is a library, if you run the jar file like java -jar postgresql-42.2.5.jar, it will output that is not an executable Java program.You should use it following the conventions of JDBC API (https://docs.oracle.com/javase/tutorial/jdbc/).Regards,On Fri, Sep 7, 2018 at 9:37 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote: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
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA
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
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?
TIA
Poul
Den fre. 7. sep. 2018 kl. 15.36 skrev Laurenz Albe <laurenz.albe@cybertec.at>:
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
--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA
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