shp2pgsql generates fake fail full of zeroes

I am usingPS F:\3D-data\Kataster> shp2pgsql -g piirid SHP_KATASTRIYKSUS kataster > kataster.sql under Windows 10 And it’s output is  full of zeroe Cygwin helps to find them out, Raivo@DESKTOP-69FUU49 /cygdrive/f/3D-data/Kataster$ cat kataster.sql | less S^@E^@T^@ ^@C^@L^@I^@E^@N^@T^@_^@E^@N^@C^@O^@

shp2pgsql error under windows

Hi I am usingPS F:\3D-data\Kataster> shp2pgsql -g piirid SHP_KATASTRIYKSUS kataster > kataster.sql under Windows 10 And it’s output is full of zeroe Cygwin helps to find them out, Raivo@DESKTOP-69FUU49 /cygdrive/f/3D-data/Kataster $ cat kataster.sql | less S^@E^@T^@ ^@C^@L^@I^@E^@N

Binary large object processing problems

Hi I am novice in pogres C API user and I want to store Binary Large Object into database from C language program. I am using following source : Oid nloid = lo_import(conn, FileFUllName.c_str()); if (nloid == 0) { std::cerr << "Error importing large object: " << PQerrorMessage(conn) << std::endl

Re: Binary large object processing problems

26 PM Christoph Moench-Tegeder wrote: > ## Raivo Rebane (raivor...@gmail.com): > > > Can anybody help me find where is my mistake an what is working solution > ? > > The documentation clearly states "All large object manipulation using > these functions must take pla

Re: Binary large object processing problems

Ok, I will do that. ANd it works now in both way Regards Raivo On Mon, Mar 13, 2023 at 6:18 PM Tom Lane wrote: > Raivo Rebane writes: > > Thank for answer, but I was also readed this manual and found there : > > 35.3.2. Importing a Large Object > > You need to read the

How to behive if I remove password from postgres role

HI I wanted to install PostGIS Bundle so that it builds a sample spatial database, but got error - createdb: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "postgres" Then I altered role of postgres so, that password = NULL. Now

jdbc problem

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

jdbc problem

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.Base

Right version of jdbc

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

Re: Right version of jdbc

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 wrote: >> >>> Hi, >>> I use : >>> PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit >>> and &g

Re: Right version of jdbc

sultSet.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 wrote: > Hi, > now I using following - > [INFO] Copying postgis-jdbc-2.1.7.jar to > C:\Users\Raivo\eclipse-workspace\b

Re: Right version of jdbc

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 wrote: > Hi, now I use - > > >

Re: Right version of jdbc

omething wrong with the classpath > > Dave Cramer > www.postgres.rocks > > > On Wed, 27 Sept 2023 at 01:52, Raivo Rebane wrote: > >> Hi, >> Thanks for response, but if I using following dependencies : >> >> >> >> >> >> net.postgis >

Re: Right version of jdbc

. Or must I downgrade my postgres version ? Regards Raivo On Thu, Sep 28, 2023 at 12:32 PM Dave Cramer wrote: > > Dave Cramer > www.postgres.rocks > > > On Thu, 28 Sept 2023 at 02:18, Raivo Rebane wrote: > >> Hi, >> >> I made a new Java application Ecli

Re: Right version of jdbc

Or may be I am using wrong version of Java - java version "17.0.8" 2023-07-18 LTS Raivo On Thu, Sep 28, 2023 at 6:41 PM Raivo Rebane wrote: > Now I changed the Postgres Server to version 15 and making Tomcat 9.0 > project. > Now I am using postgresql-42.6.0.jar driver, but

Right version of jdbc

Hi, The same problem of postgres-jdbc compatibility remains and I pushed it to github - https://github.com/raaivore/APIexperiment. I am using Postgres 15 and Java 1.8 and Tomcat9. Maybe somebody can help me to solve the problem. Regards Raivo

Re: Right version of jdbc

; > Dave Cramer > www.postgres.rocks > > > On Thu, 28 Sept 2023 at 14:51, Raivo Rebane wrote: > >> Hi, >> >> The same problem of postgres-jdbc compatibility remains and I pushed it >> to github - https://github.com/raaivore/APIexperiment. >> >> I am u

Re: Right version of jdbc

It goes better, if I add postgis-geometry-2.5.0.jar and Eclipse founds import org.postgis.Point; Raivo On Fri, Sep 29, 2023 at 7:18 AM Raivo Rebane wrote: > If I use this jar i give errors - Description Resource Path Location Type > PGgeometry cannot be resolved to

Re: Right version of jdbc

But goes worst if I am using postgis-geometry-2021.1.0.jar Raivo On Fri, Sep 29, 2023 at 8:14 AM Raivo Rebane wrote: > It goes better, if I add postgis-geometry-2.5.0.jar and Eclipse founds > > import org.postgis.Point; > > > Raivo > > On Fri, Sep 29, 2023 at 7:1

Re: Right version of jdbc

https://github.com/raaivore/APIexperiment May be somebody can help me to solve the problem ? Raivo On Fri, Sep 29, 2023 at 6:44 AM Ron wrote: > On 9/28/23 01:18, Raivo Rebane wrote: > > [snip] > > I made a new Java application Eclipse Dynamic WEB application and want to > use Pos

Re: Right version of jdbc

7) at MushroomAPIs.AddMushrooms.doGet(AddMushrooms.java:30) why java.sql gives that error ? Raivo On Fri, Sep 29, 2023 at 4:03 PM Raivo Rebane wrote: > I removed this recommended jar. > I am using Eclipse and there Java 1.8 is setted. > What I have to do ? > > Raivo > > On Fri, Sep 29, 20

Re: Right version of jdbc

Hi, I copied the postgres driver to Tomcat/lib. PS C:\Program Files\Apache Software Foundation\Tomcat 9.0\lib> dir post* Directory: C:\Program Files\Apache Software Foundation\Tomcat 9.0\lib Mode LastWriteTime Length Name - --

Re: Right version of jdbc

May be I have to copy PostGis draiver also to tomcat/lib ? Raivo On Sat, Sep 30, 2023 at 8:01 AM Raivo Rebane wrote: > Hi, > I copied the postgres driver to Tomcat/lib. > PS C:\Program Files\Apache Software Foundation\Tomcat 9.0\lib> dir post* > Directory: C:\Program Files\

Re: Right version of jdbc

Sorry. I accidentally usin postgres 16, which was empty Many thanks for advise !!! Raivo On Sat, Sep 30, 2023 at 8:18 AM Raivo Rebane wrote: > May be I have to copy PostGis draiver also to tomcat/lib ? > > Raivo > > On Sat, Sep 30, 2023 at 8:01 AM Raivo Rebane wrote: > >

Re: Right version of jdbc

be it's easy for me to use normal statement ? Raivo On Sat, Sep 30, 2023 at 8:27 AM Raivo Rebane wrote: > Sorry. I accidentally usin postgres 16, which was empty > Many thanks for advise !!! > > Raivo > > On Sat, Sep 30, 2023 at 8:18 AM Raivo Rebane wrote: > &g

Re: Right version of jdbc

ltset ? Is it related to postgis driver ? Regards Raivo On Sat, Sep 30, 2023 at 9:33 AM Raivo Rebane wrote: > Hi, > sometimes I am lucky and don't get the old error, but sometime not. > > I tried to use PreparedStatement, but I got error - > org.postgresql.util.PSQLExceptio

Re: Right version of jdbc

It seems so, that if my WEB-INF/lib contains postgres driver then Tomcat gives - No suitable driver found Raivo On Sat, Sep 30, 2023 at 10:18 AM Raivo Rebane wrote: > I fix previous error what was my bad knowledge, > But new error occur which is related to postgres postgis jars. > I

Re: Right version of jdbc

Thanks for very much for help. It seems that I can do the test project for new job. In future I use help of chat.gpt Regards Raivo On Sat, Sep 30, 2023 at 11:15 AM wrote: > Am 30.09.23 um 08:33 schrieb Raivo Rebane: > > Hi, > > sometimes I am lucky and don't get the old err

Re: Right version of jdbc

30 Sept 2023 at 06:49, Raivo Rebane wrote: > >> Thanks for very much for help. >> It seems that I can do the test project for new job. >> In future I use help of chat.gpt >> >> Regards >> Raivo >> >> On Sat, Sep 30, 2023 at 11:15 AM wrote: >>