Horton
Menu

Thread

  1. Right version of jdbc

    Raivo Rebane <raivore55@gmail.com> — 2023-09-25T08:36:27Z

    Hi,
I use :
  PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
and
PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1

What versions of jdbc driver I have to use for proper work ?

Regards,
Raivo

  2. Re: Right version of jdbc

    shammat@gmx.net — 2023-09-25T08:40:08Z

    Raivo Rebane schrieb am 25.09.2023 um 10:36:
> I use :
>   PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
> and
> PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
>
> What versions of jdbc driver I have to use for proper work ?

Use the latest, i.e. 42.6.0

  3. Re: Right version of jdbc

    Dave Cramer <davecramer@postgres.rocks> — 2023-09-25T11:27:35Z

    Hi,

The latest version of the driver is usually the right answer. So 42.5.4
Dave Cramer
www.postgres.rocks


On Mon, 25 Sept 2023 at 07:03, Raivo Rebane <raivore55@gmail.com> wrote:

> Hi,
> I use :
>   PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
> and
> PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
>
> What versions of jdbc driver I have to use for proper work ?
>
> Regards,
> Raivo
>
>
>
>

  4. Re: Right version of jdbc

    Dave Cramer <davecramer@postgres.rocks> — 2023-09-25T11:29:29Z

    Sorry 42.6.0

Interesting that github still has 42.5.4 as the release

Dave Cramer
www.postgres.rocks


On Mon, 25 Sept 2023 at 07:27, Dave Cramer <davecramer@postgres.rocks>
wrote:

> Hi,
>
> The latest version of the driver is usually the right answer. So 42.5.4
> Dave Cramer
> www.postgres.rocks
>
>
> On Mon, 25 Sept 2023 at 07:03, Raivo Rebane <raivore55@gmail.com> wrote:
>
>> Hi,
>> I use :
>>   PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
>> and
>> PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
>>
>> What versions of jdbc driver I have to use for proper work ?
>>
>> Regards,
>> Raivo
>>
>>
>>
>>

  5. Re: Right version of jdbc

    Raivo Rebane <raivore55@gmail.com> — 2023-09-25T12:26:21Z

    Hi,
now I using following -
[INFO] Copying postgis-jdbc-2.1.7.jar to
C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgis-jdbc-2.1.7.jar
[INFO] Copying postgresql-42.6.0.jar to
C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgresql-42.6.0.jar
[INFO] Copying checker-qual-3.31.0.jar to
C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\checker-qual-3.31.0.jar
but on executions I got -
Exception in thread "main" java.lang.NoClassDefFoundError:
org/postgis/PGgeometry
        at
backendproject.ProcQueryMushrooms.ProcQuery(ProcQueryMushrooms.java:41)
        at backendproject.BackendMain.main(BackendMain.java:81)
Caused by: java.lang.ClassNotFoundException: org.postgis.PGgeometry
        at
java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
        at
java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
        at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520)

What I have to do ?

I use following -
PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
Regards
Raivo

On Mon, Sep 25, 2023 at 2:29 PM Dave Cramer <davecramer@postgres.rocks>
wrote:

> Sorry 42.6.0
>
> Interesting that github still has 42.5.4 as the release
>
> Dave Cramer
> www.postgres.rocks
>
>
> On Mon, 25 Sept 2023 at 07:27, Dave Cramer <davecramer@postgres.rocks>
> wrote:
>
>> Hi,
>>
>> The latest version of the driver is usually the right answer. So 42.5.4
>> Dave Cramer
>> www.postgres.rocks
>>
>>
>> On Mon, 25 Sept 2023 at 07:03, Raivo Rebane <raivore55@gmail.com> wrote:
>>
>>> Hi,
>>> I use :
>>>   PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
>>> and
>>> PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
>>>
>>> What versions of jdbc driver I have to use for proper work ?
>>>
>>> Regards,
>>> Raivo
>>>
>>>
>>>
>>>

  6. Re: Right version of jdbc

    Dave Cramer <davecramer@postgres.rocks> — 2023-09-25T12:27:48Z

    The missing class is from the postgis jar. Are you sure it is on your
classpath ?

Dave Cramer
www.postgres.rocks


On Mon, 25 Sept 2023 at 08:26, Raivo Rebane <raivore55@gmail.com> wrote:

> Hi,
> now I using following -
> [INFO] Copying postgis-jdbc-2.1.7.jar to
> C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgis-jdbc-2.1.7.jar
> [INFO] Copying postgresql-42.6.0.jar to
> C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgresql-42.6.0.jar
> [INFO] Copying checker-qual-3.31.0.jar to
> C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\checker-qual-3.31.0.jar
> but on executions I got -
> Exception in thread "main" java.lang.NoClassDefFoundError:
> org/postgis/PGgeometry
>         at
> backendproject.ProcQueryMushrooms.ProcQuery(ProcQueryMushrooms.java:41)
>         at backendproject.BackendMain.main(BackendMain.java:81)
> Caused by: java.lang.ClassNotFoundException: org.postgis.PGgeometry
>         at
> java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
>         at
> java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
>         at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520)
>
> What I have to do ?
>
> I use following -
> PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
> PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
> Regards
> Raivo
>
> On Mon, Sep 25, 2023 at 2:29 PM Dave Cramer <davecramer@postgres.rocks>
> wrote:
>
>> Sorry 42.6.0
>>
>> Interesting that github still has 42.5.4 as the release
>>
>> Dave Cramer
>> www.postgres.rocks
>>
>>
>> On Mon, 25 Sept 2023 at 07:27, Dave Cramer <davecramer@postgres.rocks>
>> wrote:
>>
>>> Hi,
>>>
>>> The latest version of the driver is usually the right answer. So 42.5.4
>>> Dave Cramer
>>> www.postgres.rocks
>>>
>>>
>>> On Mon, 25 Sept 2023 at 07:03, Raivo Rebane <raivore55@gmail.com> wrote:
>>>
>>>> Hi,
>>>> I use :
>>>>   PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
>>>> and
>>>> PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
>>>>
>>>> What versions of jdbc driver I have to use for proper work ?
>>>>
>>>> Regards,
>>>> Raivo
>>>>
>>>>
>>>>
>>>>

  7. Re: Right version of jdbc

    Raivo Rebane <raivore55@gmail.com> — 2023-09-25T12:38:30Z

    Hi, now I use -
  <dependencies>
    <dependency>
        <groupId>org.postgis</groupId>
        <artifactId>postgis-jdbc</artifactId>
        <version>1.3.3</version>
    </dependency>
    <dependency>
        <groupId>org.postgresql</groupId>
        <artifactId>postgresql</artifactId>
        <version>42.5.4</version> <!-- Kasuta kõige uuemat versiooni -->
    </dependency>
  </dependencies>
But I got error -
Exception in thread "main" java.lang.NoSuchMethodError:
'org.postgresql.core.Encoding
org.postgresql.core.BaseConnection.getEncoding()'
        at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:1889)
        at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2ResultSet.java:438)
        at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2ResultSet.java:2406)
        at backendproject.BackendMain.main(BackendMain.java:64)

Whats wrong ?

Raivo

On Mon, Sep 25, 2023 at 3:26 PM Raivo Rebane <raivore55@gmail.com> wrote:

> Hi,
> now I using following -
> [INFO] Copying postgis-jdbc-2.1.7.jar to
> C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgis-jdbc-2.1.7.jar
> [INFO] Copying postgresql-42.6.0.jar to
> C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgresql-42.6.0.jar
> [INFO] Copying checker-qual-3.31.0.jar to
> C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\checker-qual-3.31.0.jar
> but on executions I got -
> Exception in thread "main" java.lang.NoClassDefFoundError:
> org/postgis/PGgeometry
>         at
> backendproject.ProcQueryMushrooms.ProcQuery(ProcQueryMushrooms.java:41)
>         at backendproject.BackendMain.main(BackendMain.java:81)
> Caused by: java.lang.ClassNotFoundException: org.postgis.PGgeometry
>         at
> java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
>         at
> java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
>         at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520)
>
> What I have to do ?
>
> I use following -
> PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
> PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
> Regards
> Raivo
>
> On Mon, Sep 25, 2023 at 2:29 PM Dave Cramer <davecramer@postgres.rocks>
> wrote:
>
>> Sorry 42.6.0
>>
>> Interesting that github still has 42.5.4 as the release
>>
>> Dave Cramer
>> www.postgres.rocks
>>
>>
>> On Mon, 25 Sept 2023 at 07:27, Dave Cramer <davecramer@postgres.rocks>
>> wrote:
>>
>>> Hi,
>>>
>>> The latest version of the driver is usually the right answer. So 42.5.4
>>> Dave Cramer
>>> www.postgres.rocks
>>>
>>>
>>> On Mon, 25 Sept 2023 at 07:03, Raivo Rebane <raivore55@gmail.com> wrote:
>>>
>>>> Hi,
>>>> I use :
>>>>   PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
>>>> and
>>>> PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
>>>>
>>>> What versions of jdbc driver I have to use for proper work ?
>>>>
>>>> Regards,
>>>> Raivo
>>>>
>>>>
>>>>
>>>>

  8. Re: Right version of jdbc

    Raivo Rebane <raivore55@gmail.com> — 2023-09-25T12:43:37Z

    And target/lib is s following :
Directory of C:\Users\Raivo\eclipse-workspace\backendproject\target\lib

25.09.2023  15:35    <DIR>          .
25.09.2023  15:33    <DIR>          ..
25.09.2023  15:33           214 381 checker-qual-3.5.0.jar
25.09.2023  13:14            75 847 postgis-jdbc-1.3.3.jar
25.09.2023  13:14             2 833 postgis-stubs-1.3.3.jar
25.09.2023  15:33         1 049 651 postgresql-42.5.4.jar
25.09.2023  13:14           474 746 postgresql-8.3-603.jdbc4.jar

Raivo


On Mon, Sep 25, 2023 at 3:38 PM Raivo Rebane <raivore55@gmail.com> wrote:

> Hi, now I use -
>   <dependencies>
>     <dependency>
>         <groupId>org.postgis</groupId>
>         <artifactId>postgis-jdbc</artifactId>
>         <version>1.3.3</version>
>     </dependency>
>     <dependency>
>         <groupId>org.postgresql</groupId>
>         <artifactId>postgresql</artifactId>
>         <version>42.5.4</version> <!-- Kasuta kõige uuemat versiooni -->
>     </dependency>
>   </dependencies>
> But I got error -
> Exception in thread "main" java.lang.NoSuchMethodError:
> 'org.postgresql.core.Encoding
> org.postgresql.core.BaseConnection.getEncoding()'
>         at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:1889)
>         at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2ResultSet.java:438)
>         at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2ResultSet.java:2406)
>         at backendproject.BackendMain.main(BackendMain.java:64)
>
> Whats wrong ?
>
> Raivo
>
> On Mon, Sep 25, 2023 at 3:26 PM Raivo Rebane <raivore55@gmail.com> wrote:
>
>> Hi,
>> now I using following -
>> [INFO] Copying postgis-jdbc-2.1.7.jar to
>> C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgis-jdbc-2.1.7.jar
>> [INFO] Copying postgresql-42.6.0.jar to
>> C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgresql-42.6.0.jar
>> [INFO] Copying checker-qual-3.31.0.jar to
>> C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\checker-qual-3.31.0.jar
>> but on executions I got -
>> Exception in thread "main" java.lang.NoClassDefFoundError:
>> org/postgis/PGgeometry
>>         at
>> backendproject.ProcQueryMushrooms.ProcQuery(ProcQueryMushrooms.java:41)
>>         at backendproject.BackendMain.main(BackendMain.java:81)
>> Caused by: java.lang.ClassNotFoundException: org.postgis.PGgeometry
>>         at
>> java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
>>         at
>> java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
>>         at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520)
>>
>> What I have to do ?
>>
>> I use following -
>> PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
>> PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
>> Regards
>> Raivo
>>
>> On Mon, Sep 25, 2023 at 2:29 PM Dave Cramer <davecramer@postgres.rocks>
>> wrote:
>>
>>> Sorry 42.6.0
>>>
>>> Interesting that github still has 42.5.4 as the release
>>>
>>> Dave Cramer
>>> www.postgres.rocks
>>>
>>>
>>> On Mon, 25 Sept 2023 at 07:27, Dave Cramer <davecramer@postgres.rocks>
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> The latest version of the driver is usually the right answer. So 42.5.4
>>>> Dave Cramer
>>>> www.postgres.rocks
>>>>
>>>>
>>>> On Mon, 25 Sept 2023 at 07:03, Raivo Rebane <raivore55@gmail.com>
>>>> wrote:
>>>>
>>>>> Hi,
>>>>> I use :
>>>>>   PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
>>>>> and
>>>>> PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
>>>>>
>>>>> What versions of jdbc driver I have to use for proper work ?
>>>>>
>>>>> Regards,
>>>>> Raivo
>>>>>
>>>>>
>>>>>
>>>>>

  9. Re: Right version of jdbc

    Dave Cramer <davecramer@postgres.rocks> — 2023-09-25T12:50:17Z

    remove the postgresql-8.3-603.jdbc4.jar
Dave Cramer
www.postgres.rocks


On Mon, 25 Sept 2023 at 08:43, Raivo Rebane <raivore55@gmail.com> wrote:

> And target/lib is s following :
> Directory of C:\Users\Raivo\eclipse-workspace\backendproject\target\lib
>
> 25.09.2023  15:35    <DIR>          .
> 25.09.2023  15:33    <DIR>          ..
> 25.09.2023  15:33           214 381 checker-qual-3.5.0.jar
> 25.09.2023  13:14            75 847 postgis-jdbc-1.3.3.jar
> 25.09.2023  13:14             2 833 postgis-stubs-1.3.3.jar
> 25.09.2023  15:33         1 049 651 postgresql-42.5.4.jar
> 25.09.2023  13:14           474 746 postgresql-8.3-603.jdbc4.jar
>
> Raivo
>
>
> On Mon, Sep 25, 2023 at 3:38 PM Raivo Rebane <raivore55@gmail.com> wrote:
>
>> Hi, now I use -
>>   <dependencies>
>>     <dependency>
>>         <groupId>org.postgis</groupId>
>>         <artifactId>postgis-jdbc</artifactId>
>>         <version>1.3.3</version>
>>     </dependency>
>>     <dependency>
>>         <groupId>org.postgresql</groupId>
>>         <artifactId>postgresql</artifactId>
>>         <version>42.5.4</version> <!-- Kasuta kõige uuemat versiooni -->
>>     </dependency>
>>   </dependencies>
>> But I got error -
>> Exception in thread "main" java.lang.NoSuchMethodError:
>> 'org.postgresql.core.Encoding
>> org.postgresql.core.BaseConnection.getEncoding()'
>>         at
>> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:1889)
>>         at
>> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2ResultSet.java:438)
>>         at
>> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2ResultSet.java:2406)
>>         at backendproject.BackendMain.main(BackendMain.java:64)
>>
>> Whats wrong ?
>>
>> Raivo
>>
>> On Mon, Sep 25, 2023 at 3:26 PM Raivo Rebane <raivore55@gmail.com> wrote:
>>
>>> Hi,
>>> now I using following -
>>> [INFO] Copying postgis-jdbc-2.1.7.jar to
>>> C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgis-jdbc-2.1.7.jar
>>> [INFO] Copying postgresql-42.6.0.jar to
>>> C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgresql-42.6.0.jar
>>> [INFO] Copying checker-qual-3.31.0.jar to
>>> C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\checker-qual-3.31.0.jar
>>> but on executions I got -
>>> Exception in thread "main" java.lang.NoClassDefFoundError:
>>> org/postgis/PGgeometry
>>>         at
>>> backendproject.ProcQueryMushrooms.ProcQuery(ProcQueryMushrooms.java:41)
>>>         at backendproject.BackendMain.main(BackendMain.java:81)
>>> Caused by: java.lang.ClassNotFoundException: org.postgis.PGgeometry
>>>         at
>>> java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
>>>         at
>>> java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
>>>         at
>>> java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520)
>>>
>>> What I have to do ?
>>>
>>> I use following -
>>> PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
>>> PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
>>> Regards
>>> Raivo
>>>
>>> On Mon, Sep 25, 2023 at 2:29 PM Dave Cramer <davecramer@postgres.rocks>
>>> wrote:
>>>
>>>> Sorry 42.6.0
>>>>
>>>> Interesting that github still has 42.5.4 as the release
>>>>
>>>> Dave Cramer
>>>> www.postgres.rocks
>>>>
>>>>
>>>> On Mon, 25 Sept 2023 at 07:27, Dave Cramer <davecramer@postgres.rocks>
>>>> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> The latest version of the driver is usually the right answer. So 42.5.4
>>>>> Dave Cramer
>>>>> www.postgres.rocks
>>>>>
>>>>>
>>>>> On Mon, 25 Sept 2023 at 07:03, Raivo Rebane <raivore55@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Hi,
>>>>>> I use :
>>>>>>   PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
>>>>>> and
>>>>>> PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
>>>>>>
>>>>>> What versions of jdbc driver I have to use for proper work ?
>>>>>>
>>>>>> Regards,
>>>>>> Raivo
>>>>>>
>>>>>>
>>>>>>
>>>>>>

  10. Re: Right version of jdbc

    Rob Sargent <robjsargent@gmail.com> — 2023-09-25T16:03:28Z

    On 9/25/23 06:38, Raivo Rebane wrote:
> Hi, now I use -
>   <dependencies>
>     <dependency>
>         <groupId>org.postgis</groupId>
>         <artifactId>postgis-jdbc</artifactId>
>         <version>1.3.3</version>
>     </dependency>
>     <dependency>
>         <groupId>org.postgresql</groupId>
>         <artifactId>postgresql</artifactId>
>         <version>42.5.4</version> <!-- Kasuta kõige uuemat versiooni -->
>     </dependency>
>   </dependencies>
> But I got error -
> Exception in thread "main" java.lang.NoSuchMethodError: 
> 'org.postgresql.core.Encoding 
> org.postgresql.core.BaseConnection.getEncoding()'
>         at 
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:1889)
>         at 
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2ResultSet.java:438)
>         at 
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2ResultSet.java:2406)
>         at backendproject.BackendMain.main(BackendMain.java:64)
>
> Whats wrong ?

Show your application CLASSPATH.

  11. Re: Right version of jdbc

    Dave Cramer <davecramer@postgres.rocks> — 2023-09-25T16:42:51Z

    You should probably be using the latest version of postgis-jdbc

Maven Repository: net.postgis » postgis-jdbc » 2021.1.0 (mvnrepository.com)
<https://mvnrepository.com/artifact/net.postgis/postgis-jdbc/2021.1.0>

Dave Cramer
www.postgres.rocks


On Mon, 25 Sept 2023 at 08:43, Raivo Rebane <raivore55@gmail.com> wrote:

> And target/lib is s following :
> Directory of C:\Users\Raivo\eclipse-workspace\backendproject\target\lib
>
> 25.09.2023  15:35    <DIR>          .
> 25.09.2023  15:33    <DIR>          ..
> 25.09.2023  15:33           214 381 checker-qual-3.5.0.jar
> 25.09.2023  13:14            75 847 postgis-jdbc-1.3.3.jar
> 25.09.2023  13:14             2 833 postgis-stubs-1.3.3.jar
> 25.09.2023  15:33         1 049 651 postgresql-42.5.4.jar
> 25.09.2023  13:14           474 746 postgresql-8.3-603.jdbc4.jar
>
> Raivo
>
>
> On Mon, Sep 25, 2023 at 3:38 PM Raivo Rebane <raivore55@gmail.com> wrote:
>
>> Hi, now I use -
>>   <dependencies>
>>     <dependency>
>>         <groupId>org.postgis</groupId>
>>         <artifactId>postgis-jdbc</artifactId>
>>         <version>1.3.3</version>
>>     </dependency>
>>     <dependency>
>>         <groupId>org.postgresql</groupId>
>>         <artifactId>postgresql</artifactId>
>>         <version>42.5.4</version> <!-- Kasuta kõige uuemat versiooni -->
>>     </dependency>
>>   </dependencies>
>> But I got error -
>> Exception in thread "main" java.lang.NoSuchMethodError:
>> 'org.postgresql.core.Encoding
>> org.postgresql.core.BaseConnection.getEncoding()'
>>         at
>> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:1889)
>>         at
>> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2ResultSet.java:438)
>>         at
>> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2ResultSet.java:2406)
>>         at backendproject.BackendMain.main(BackendMain.java:64)
>>
>> Whats wrong ?
>>
>> Raivo
>>
>> On Mon, Sep 25, 2023 at 3:26 PM Raivo Rebane <raivore55@gmail.com> wrote:
>>
>>> Hi,
>>> now I using following -
>>> [INFO] Copying postgis-jdbc-2.1.7.jar to
>>> C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgis-jdbc-2.1.7.jar
>>> [INFO] Copying postgresql-42.6.0.jar to
>>> C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgresql-42.6.0.jar
>>> [INFO] Copying checker-qual-3.31.0.jar to
>>> C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\checker-qual-3.31.0.jar
>>> but on executions I got -
>>> Exception in thread "main" java.lang.NoClassDefFoundError:
>>> org/postgis/PGgeometry
>>>         at
>>> backendproject.ProcQueryMushrooms.ProcQuery(ProcQueryMushrooms.java:41)
>>>         at backendproject.BackendMain.main(BackendMain.java:81)
>>> Caused by: java.lang.ClassNotFoundException: org.postgis.PGgeometry
>>>         at
>>> java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
>>>         at
>>> java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
>>>         at
>>> java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520)
>>>
>>> What I have to do ?
>>>
>>> I use following -
>>> PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
>>> PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
>>> Regards
>>> Raivo
>>>
>>> On Mon, Sep 25, 2023 at 2:29 PM Dave Cramer <davecramer@postgres.rocks>
>>> wrote:
>>>
>>>> Sorry 42.6.0
>>>>
>>>> Interesting that github still has 42.5.4 as the release
>>>>
>>>> Dave Cramer
>>>> www.postgres.rocks
>>>>
>>>>
>>>> On Mon, 25 Sept 2023 at 07:27, Dave Cramer <davecramer@postgres.rocks>
>>>> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> The latest version of the driver is usually the right answer. So 42.5.4
>>>>> Dave Cramer
>>>>> www.postgres.rocks
>>>>>
>>>>>
>>>>> On Mon, 25 Sept 2023 at 07:03, Raivo Rebane <raivore55@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Hi,
>>>>>> I use :
>>>>>>   PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
>>>>>> and
>>>>>> PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
>>>>>>
>>>>>> What versions of jdbc driver I have to use for proper work ?
>>>>>>
>>>>>> Regards,
>>>>>> Raivo
>>>>>>
>>>>>>
>>>>>>
>>>>>>