Re: Right version of jdbc

Dave Cramer
www.postgres.rocks

On Thu, 28 Sept 2023 at 02:18, Raivo Rebane <raivore55(at)gmail(dot)com> wrote:

> Hi,
>
> I made a new Java application Eclipse Dynamic WEB application and want to
> use Postgres - PostgreSQL 10.14 on x86_64-pc-linux-gnu, compiled by gcc
> (Ubuntu 9.3.0-10ubuntu2) 9.3.0, 64-bit and Postgis - 2.4 USE_GEOS=1
> USE_PROJ=1 USE_STATS=1.
>
> I added some jdbc-s in my project webapps/WEB-INF/lib directory which now
> contains - javax.servlet-api.jar postgis-jdbc-2.2.1.jar
> postgresql-42.2.5.jre7.jar.
>

postgresql-42.2.5.jre7.jar. is for java 7.
I suggest you use the latest versions of postgis and postgres jdbc

Dave

>
> But they don't fit the needs and I got from tomcat -
> java.sql.SQLException: No suitable driver found for
> jdbc:postgresql://localhost:5432/mushroom_database
> at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:702)
> at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
> at MushroomAPIs.AddMushrooms.doGet(AddMushrooms.java:30)
>
> What's wrong. Or is better to use more newer postgres. And then which
> jdbc-I need to use ?
>
> Regards
> Raivo
>
>
>
> On Wed, Sep 27, 2023 at 12:43 PM Dave Cramer <davecramer(at)postgres(dot)rocks>
> wrote:
>
>> First of all please use reply all so that everyone sees the answers.
>>
>> Not sure since PgObject is certainly in the jdbc jar. pgjdbc/pgjdbc/src/main/java/org/postgresql/util/PGobject.java
>> at 5709a20fbef453749d2394e11502527e4a3ab5bb · pgjdbc/pgjdbc (github.com)
>> <https://github.com/pgjdbc/pgjdbc/blob/5709a20fbef453749d2394e11502527e4a3ab5bb/pgjdbc/src/main/java/org/postgresql/util/PGobject.java#L19>
>>
>> I suggest at this point you provide a test project on github that you can
>> share.
>>
>> There is something wrong with the classpath
>>
>> Dave Cramer
>> www.postgres.rocks
>>
>>
>> On Wed, 27 Sept 2023 at 01:52, Raivo Rebane <raivore55(at)gmail(dot)com> wrote:
>>
>>> Hi,
>>> Thanks for response, but if I using following dependencies :
>>>
>>> <dependencies>
>>>
>>> <dependency>
>>>
>>> <groupId>net.postgis</groupId>
>>>
>>> <artifactId>postgis-jdbc</artifactId>
>>>
>>> <version>2021.1.0</version>
>>>
>>> </dependency>
>>>
>>> <dependency>
>>>
>>> <groupId>org.postgresql</groupId>
>>>
>>> <artifactId>postgresql</artifactId>
>>>
>>> <version>42.6.0</version> <!-- Kasuta kõige uuemat versiooni -->
>>>
>>> </dependency>
>>>
>>> </dependencies>
>>>
>>> I have error :
>>>
>>> The type org.postgresql.util.PGobject cannot be resolved. It is
>>> indirectly referenced from required type org.postgis.PGgeometry
>>>
>>>
>>> What is wrong with me ?
>>>
>>>
>>> Raivo
>>>
>>