Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qkSqC-00EXPG-8E for pgsql-general@arkaria.postgresql.org; Sun, 24 Sep 2023 17:24:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qkSq9-009mtn-5z for pgsql-general@arkaria.postgresql.org; Sun, 24 Sep 2023 17:24:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qkSq8-009mtd-LM for pgsql-general@lists.postgresql.org; Sun, 24 Sep 2023 17:24:16 +0000 Received: from mta-244-118.tll07.zoneas.eu ([85.234.244.118]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qkSq4-007Khh-9P for pgsql-general@lists.postgresql.org; Sun, 24 Sep 2023 17:24:15 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=r-systems.ee; q=dns/txt; s=zone; bh=Eo3LAfON0O12elMSYx5SFIpGKB0bNywuIfqpDLBrELw=; h=from:subject:date:message-id:to:mime-version:content-type; b=NKQrob6l/XirytvTzAPlPkbF2HXZ/Tca8v0HdyJcxFMk86hmwKE1YhN+q7YVogWwFHbPWzYSX 5ZFbiTGKEDlpMjpbRebNSMBXez88iFEqKJCjls6Cs72D6WwfyMjX6pN+KZF8UcRT+eldqOA3sqe bao+08UBXfvfkwICcrRi4GEy92cH/CH84nLwuLps8qhQ03C+0mUrqGoMWkSLCd5LW52rcHqRSAb BnQ5jnljXqb7S/na+2s8vnz6DU8gPF2TdsHFXKjK+GUp4ApjdJveIGA2ldecFXQsGGRBdxjo8Cn z85K6fCbNVNyrjLxv+9vBAFWWpRFyfHkPq5R2Pc0wbXQ== Received: from [192.168.8.5] ([87.119.179.171] 87-119-179-171.tll.elisa.ee) (Authenticated sender: zmail607722[raivo@r-systems.ee]) by MTA-244-118.TLL07.ZONEAS.EU (ZoneMTA Forwarder) with ESMTPSA id 18ac8384725000024c.001 for (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384); Sun, 24 Sep 2023 17:24:06 +0000 Content-Type: multipart/alternative; boundary="------------ScUhX4v0iSIpyM7EgzOlJpuS" Message-ID: <5a03afa5-c4d4-3580-e6c2-7f52c93b5f58@r-systems.ee> Date: Sun, 24 Sep 2023 20:24:05 +0300 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.2.2 Content-Language: en-US To: pgsql-general@lists.postgresql.org From: Raivo Rebane Subject: jdbc problem List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------ScUhX4v0iSIpyM7EgzOlJpuS Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hi, I hav postgresql 15 installed in my windows computer. I have maven java project, wich works temporarly in Eclipse, but mvn install did'nt work. Now it works, but I have 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) backendproject.BackendMain.main(BackendMain.java:64) line is following - Timestamp oldest_timestamp= resultSet.getTimestamp("oldest_timestamp"); Query from Java is following - String query= "SELECT timestamp AS oldest_timestamp FROM mushrooms"; PreparedStatement statement= connection.prepareStatement(query); ResultSet resultSet= statement.executeQuery(); And pom.xml contains - org.postgis postgis-jdbc 1.3.3 org.postgresql postgresql 42.2.0 and mvn install gives - [INFO] --- dependency:3.6.0:copy-dependencies (copy-dependencies) @ backendproject --- [INFO] Copying postgis-jdbc-1.3.3.jar to C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgis-jdbc-1.3.3.jar [INFO] Copying postgis-stubs-1.3.3.jar to C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgis-stubs-1.3.3.jar [INFO] Copying postgresql-8.3-603.jdbc4.jar to C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgresql-8.3-603.jdbc4.jar [INFO] Copying postgresql-42.2.0.jar to C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgresql-42.2.0.jar What is reason of this error and how to resolv it ? Regards Raivo --------------ScUhX4v0iSIpyM7EgzOlJpuS Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Hi,

I hav postgresql 15 installed in my windows computer.

I have maven java project, wich works temporarly in Eclipse, but mvn install did'nt work.

Now it works, but I have got error -

Exception in thread "main" java.lang.NoSuchMethodError: 'org.postgresql.core.Encoding org.postgresql.core.BaseConnection.getEncoding()'
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2Result= Set.java:1889)
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2Res= ultSet.java:438)
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2Res= ultSet.java:2406)
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at backendproject.Backen= dMain.main(BackendMain.java:64)

backendproject.BackendMain.main(BackendMain.java:64) line is following -

Timestamp oldest_timestamp =3D resultSet.getTimestamp("oldest_time= stamp");

Query fr= om Java is following -

String query =3D <= span style=3D"color:#2a00ff;">"SELECT timestamp AS oldest_timestamp FROM = mushrooms";

PreparedStatement statement =3D connection.prepareStatement(query);

ResultSet resultSet =3D statement.executeQuery();

And pom.xml= contains -

<dependencies>

<dependency&= gt;

<= groupId>org.postgis</groupId<= /span>>

<artifactId>postgis-jdbc</artifactId>

<version>1.3.3</version>

</dependency>

<= dependency>

<groupId>org.po= stgresql</groupId>

<artifactId>postgresql</artifactId>= ;

<ve= rsion>42.2.0</version&= gt;

</de= pendency>

and mvn install gives -

[INFO] --- dependency:3.6.0:copy-dependencies (copy-dependencies) @ = backendproject --- [INFO] Copying postgis-jdbc-1.3.3.jar to C:\Users\Raivo\eclipse-workspace= \backendproject\target\lib\postgis-jdbc-1.3.3.jar [INFO] Copying postgis-stubs-1.3.3.jar to C:\Users\Raivo\eclipse-workspac= e\backendproject\target\lib\postgis-stubs-1.3.3.jar [INFO] Copying postgresql-8.3-603.jdbc4.jar to C:\Users\Raivo\eclipse-wor= kspace\backendproject\target\lib\postgresql-8.3-603.jdbc4.jar [INFO] Copying postgresql-42.2.0.jar to C:\Users\Raivo\eclipse-workspace\= backendproject\target\lib\postgresql-42.2.0.jar

What is reason of this error and how to resolv= it ?

Regards

Raivo

--------------ScUhX4v0iSIpyM7EgzOlJpuS--