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:18 AM Raivo Rebane wrote: > >>

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 a type

Re: Right version of jdbc

If I use this jar i give errors - Description Resource Path Location Type PGgeometry cannot be resolved to a type ProcAddMushrooms.java /KatseAPIs/src/main/java/MushroomAPIs line 22 Java Problem PGgeometry cannot be resolved to a type ProcAddMushrooms.java /KatseAPIs/src/main/java/MushroomAPIs

Re: Right version of jdbc

On 9/28/23 01:18, Raivo Rebane wrote: [snip] I made a new Java application Eclipse Dynamic WEB application and want to use Postgres - PostgreSQL 10.14 [snip] What's wrong. Or is better to use more newer postgres. And then which jdbc-I need to use ?

Re: cast bytea to macaddr

Hi Matt, > > 1. What do the double parenthesis '(( Values ))' mean? Nothing, it was easier to continue typing and close one more on the phone. Single parenthesis are enough. > > 2. What is the 'x(field)' in the column alias? X(field) is just to make the example more readable. And name

Re: Right version of jdbc

The latest version of postgis-jdbc is Maven Repository: net.postgis » postgis-jdbc » 2021.1.0 (mvnrepository.com) Dave Cramer www.postgres.rocks On Thu, 28 Sept 2023 at 14:51, Raivo Rebane wrote: > Hi, > > The same problem

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: cast bytea to macaddr

Hi Boris, [bringing this email back to the mailing list] A couple of questions: 1. What do the double parenthesis '(( Values ))' mean? 2. What is the 'x(field)' in the column alias? Thanks for educating me! -m On Thu, Sep 28, 2023 at 10:34 AM Boris Zentner wrote: > Hi matt, > > This

Re: Right version of jdbc

Please put this project on github so we can see it. Thanks Dave Cramer www.postgres.rocks On Thu, 28 Sept 2023 at 11:53, Raivo Rebane wrote: > 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:

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 Tomcat gives error :

Re: Right version of jdbc

On 9/28/23 09:41, 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 Tomcat gives error : java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/mushroom_database

Re: Right version of jdbc

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 Tomcat gives error : java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/mushroom_database What driver I have to use for suitable driver.

cast bytea to macaddr

Greetings Pg folks, I have a database schema (not mine) that uses bytea to represent a MAC address. I'd like to create a view that casts that field into a MACADDR type. # \d lease4 Table "public.lease4" Column │ Type │ Collation │ Nullable

Re: valid casts to anyarray

> Per the comments for check_generic_type_consistency: > > * 2) All arguments declared ANYARRAY must have the same datatype, > *which must be a varlena array type. > This must be exactly the bit that I missed during my reading - thanks! > It has to not only have an element type, but

Re: Right version of jdbc

Dave Cramer www.postgres.rocks On Thu, 28 Sept 2023 at 02:18, Raivo Rebane 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 -

Re: debugger from superuser only.... why?

On Wed, Sep 27, 2023 at 1:30 PM Alexander Petrossian wrote: > > > 25 сент. 2023 г., в 17:28, Tom Lane написал(а): > > Alexander Petrossian writes: > I am wondering why is this, why not allow debugging for non-privileged > users? > > Even if there's a way to restrict > > debugging

Re: Right version of jdbc

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