Re: psycopg2 and java gssapi questions

2017-12-21 Thread Dave Cramer
k > slightly different for a Java client, but the principle is the same) > > JDBC docs on GSSAPI can be found https://jdbc.postgresql.org/documentation/head/connect.html Dave Cramer da...@postgresintl.com www.postgresintl.com

Re: Code of Conduct plan

2018-06-04 Thread Dave Cramer
elcome here. > > Also: we *have* had cases where women who had been contributors left > because of harassment, and I'd like to ensure that doesn't happen again. > > +1000 Dave Cramer da...@postgresintl.com www.postgresintl.com

Re: Postgres install

2018-02-05 Thread Dave Cramer
planning to have >> different drive location for my data directory or any important parameter, >> please let me know. >> >> There are lots, but changing the data dir is not particularly difficult. https://www.postgresql.org/docs/9.3/static/runtime-config-file-locations.html Dave Cramer da...@postgresintl.com www.postgresintl.com > >> Thanks in Advance >> >> -- >> >> Regards, >> Azim >> >>

Re: jndi jdbc url with ssl authenticat in tomcat ... fails org.xml.sax.SAXParseException columnNumber: 79; The reference to entity "ssl" must end with the ';' delimiter

2018-08-04 Thread Dave Cramer
Pretty sure this is a tomcat error . The connection string looks fine Dave Cramer da...@postgresintl.com www.postgresintl.com On 30 July 2018 at 11:32, Didier Wiroth wrote: > Hello, > I'm trying to configure a postgres jndi resource in tomcat that needs to > connect via ssl a

Re: Building a notification system.

2018-07-16 Thread Dave Cramer
pretty open ended >> - A reference to the question, e.g. its ID >> - Some lifecycle attribute such as "viewed-on" or "acknowledged-on" >> >> When a user logs in, it should be easy to query that table, providing the >> list of unexamined updates. >> > Also look at Logical Decoding for implementing Change Data Capture Dave Cramer da...@postgresintl.com www.postgresintl.com

Re: very slow largeobject transfers through JDBC

2018-09-01 Thread Dave Cramer
t;> cause is? >> I don't know what a reason of that, but I think it's reasonable and >> quite simple to call lo_import()/lo_export() via JNI. >> > Can't imagine that's any faster. The driver simply implements the protocol Do you have any code to share ? Any other information ? Is the JDBC connection significantly further away network wise ? Dave Cramer da...@postgresintl.com www.postgresintl.com

Re: very slow largeobject transfers through JDBC

2018-09-06 Thread Dave Cramer
Hi Can you be more explicit how you fixed the problem ? Thanks Dave Cramer da...@postgresintl.com www.postgresintl.com On Thu, 6 Sep 2018 at 03:46, Mate Varga wrote: > After inlining the data, performance issues have been solved. Thanks for > the help. > > On Mon, Sep 3, 201

Re: very slow largeobject transfers through JDBC

2018-09-06 Thread Dave Cramer
Hi Mate, Thanks for the detailed response. This will help others in the same situation Dave Cramer da...@postgresintl.com www.postgresintl.com On Thu, 6 Sep 2018 at 05:03, Mate Varga wrote: > Hi, > > summarizing: > we had a table that had an OID column, referenci

Re: JDBC connectivity issue

2018-03-08 Thread Dave Cramer
You should be using the latest version of the driver. What version are you using ? Even though you have a 9.4 database the latest version is the correct version to use. Dave Cramer da...@postgresintl.com www.postgresintl.com On 8 March 2018 at 22:14, David G. Johnston <david.g.jo

Re: JDBC connectivity issue

2018-03-22 Thread Dave Cramer
Chris, At this point I'd write small piece of code to test if the url and failover is working correctly. Sounds like you have a considerably sized stack making it difficult to debug. With a small piece of code it should become clear as to how things work or don't as the case may be Dave Cramer

Re: JDBC connectivity issue

2018-03-23 Thread Dave Cramer
Cool, thanks. I'd love to see this work Dave Cramer da...@postgresintl.com www.postgresintl.com On 23 March 2018 at 10:24, JCMS22 <jeanlavoi...@gmail.com> wrote: > I forgot to say I am trying to investigate how to make it work as we need > specific stuff from the DataS

Re: libpq to JDBC adapter

2018-11-14 Thread Dave Cramer
Looks very interesting, Cheers, Dave Cramer da...@postgresintl.com www.postgresintl.com On Wed, 14 Nov 2018 at 14:57, Konstantin Knizhnik wrote: > If somebody is interested in connection to various JDBC-compatible > databases through postgres_fdw, > please look at my pq2jdbc proje

Re: very slow largeobject transfers through JDBC

2018-09-03 Thread Dave Cramer
encrypted, so their entropy is > very high. > > Any chance you could write a simple non-hibernate test code to time the code ? Dave Cramer dave.cra...@crunchydata.ca www.crunchydata.ca > Mate > > On Sun, Sep 2, 2018 at 12:55 AM Dave Cramer wrote: > >> >> >> >

Re: very slow largeobject transfers through JDBC

2018-09-03 Thread Dave Cramer
the one you have highlighted ~1.69ms Dave Cramer da...@postgresintl.com www.postgresintl.com On Mon, 3 Sep 2018 at 10:38, Mate Varga wrote: > Which frame do you refer to? > > On Mon, Sep 3, 2018 at 3:57 PM Dave Cramer wrote: > >> Not sure why reading from a socket is takin

Re: very slow largeobject transfers through JDBC

2018-09-03 Thread Dave Cramer
Not sure why reading from a socket is taking 1ms ? Dave Cramer da...@postgresintl.com www.postgresintl.com On Mon, 3 Sep 2018 at 09:39, Mate Varga wrote: > Hi, > > https://imgur.com/a/ovsJPRv -- I've uploaded the profiling info (as an > image, sorry). It seems this is a JDBC-leve

Re: very slow largeobject transfers through JDBC

2018-09-03 Thread Dave Cramer
m all but since they are LOB's we could run out of memory. Not sure what to tell you at this point. I'd entertain a PR if you were motivated. Dave Cramer da...@postgresintl.com www.postgresintl.com > > On Mon, Sep 3, 2018 at 6:54 PM Mate Varga wrote: > >> So I have detailed profiling result

Re: very slow largeobject transfers through JDBC

2018-09-03 Thread Dave Cramer
On Mon, 3 Sep 2018 at 10:48, Mate Varga wrote: > That's 1690 msec (1.69 seconds, and that is how long it takes to fetch 20k > (small-ish) rows without LOBs (LOBs are a few lines below on the screenshot) > that sound high as well! Something isn't adding up.. Dave C

Re: loading jdbc Driver in servlet

2018-12-16 Thread Dave Cramer
My guess is it has something to do with your servlet classpath loader. Which servlet engine are you using ? Dave Cramer da...@postgresintl.com www.postgresintl.com On Fri, 14 Dec 2018 at 16:04, Rob Sargent wrote: > > > On Dec 14, 2018, at 2:02 PM, Rob Sargent wrote: > > >

Re: loading jdbc Driver in servlet

2018-12-16 Thread Dave Cramer
So you are starting up tomcat yourself ? Perhaps that is the difference ? I have no idea what the tomcat wrapper does, but I'd be curious if the same thing happens when stared normally Dave Cramer da...@postgresintl.com www.postgresintl.com On Sun, 16 Dec 2018 at 12:20, Rob Sargent wrote

Re: loading jdbc Driver in servlet

2018-12-14 Thread Dave Cramer
Strange, I wouldn't think so, but then I haven't used a raw servlet for so long I have no idea. Dave Cramer da...@postgresintl.com www.postgresintl.com On Fri, 14 Dec 2018 at 13:29, Rob Sargent wrote: > Using java 1.8, postgresql-42.1.4.jar, embedded tomcat 9 > > It appears to

Re: loading jdbc Driver in servlet

2018-12-17 Thread Dave Cramer
river's jar in the classpath. > Servlet classpath issues are legendary. As Thomas points out setting up the classpath for a servlet engine is not trivial. Dave Cramer da...@postgresintl.com www.postgresintl.com > >

Re: jdbc PGCopyOutputStream close() v. endCopy()

2019-01-10 Thread Dave Cramer
Hi Rob, Interesting. I've not looked too much into the copy implementation. The JDBC list or the jdbc github repo https://github.com/pgjdbc/pgjdbc might be a better place to report this. I know Lukas Edar monitors it as well Dave Cramer da...@postgresintl.com www.postgresintl.com On Tue, 8

Re: Forks of pgadmin3?

2019-03-25 Thread Dave Cramer
Thomas, Any chance it would run under graalvm getting rid of the need for the JVM ? Dave Cramer da...@postgresintl.com www.postgresintl.com On Mon, 25 Mar 2019 at 07:06, Thomas Kellerer wrote: > kpi6...@gmail.com schrieb am 22.03.2019 um 17:25: > > 95% of my time I use pgadmi

Re: Async client libraries - not worth it?

2019-06-17 Thread Dave Cramer
On Mon, 17 Jun 2019 at 07:35, Rob Nikander wrote: > > > On Jun 17, 2019, at 1:12 PM, Dave Cramer wrote: > > https://www.techempower.com/benchmarks/#section=data-r17=ph=db > > Seems to be worth it. > > Now it appears that ADBA is going to die on the vine, R2DBC and ver

Re: Async client libraries - not worth it?

2019-06-17 Thread Dave Cramer
On Mon, 17 Jun 2019 at 09:43, Rob Nikander wrote: > > > > On Jun 17, 2019, at 3:57 PM, Dave Cramer wrote: > > […] Postgres can pipeline requests if the client is written correctly so > it is conceivable that this would be much faster. > > Can the JDBC driver do this

Re: Async client libraries - not worth it?

2019-06-17 Thread Dave Cramer
t; https://www.techempower.com/benchmarks/#section=data-r17=ph=db Seems to be worth it. Now it appears that ADBA is going to die on the vine, R2DBC and vertx seem to be pretty good Dave Cramer da...@postgresintl.com www.postgresintl.com

Re: Automatically parsing in-line composite types

2019-10-29 Thread Dave Cramer
? So what are types of fields in the record? > > > > I start the parsing process by looking at types returned in > > RowDescription message and then reading descriptions in pg_type table. > > > > Is there some other way to get full typing information of the result I >

Re: SV: Using Postgres jdbc driver with Oracle SQL Developer

2020-07-06 Thread Dave Cramer
On Mon, 6 Jul 2020 at 09:33, Tom Lane wrote: > Niels Jespersen writes: > > Sorry, "way to provide a default username" should have been "way to > provide a default databasename" > > Not sure, but you'd be more likely to find a knowledgeable answer > on the pgsql-jdbc list. > > Same way, in the

Re: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made?

2020-12-08 Thread Dave Cramer
://stackoverflow.com/a/16119489/843699 , but it is not 100% clear. > > Would it be possible to have an official answer on this? > I can't see how they could possibly be out of order. Dave Cramer www.postgres.rocks > > Thanks in advance! > > >

Re: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made?

2020-12-09 Thread Dave Cramer
So I'm curious. Why does order matter ? Dave Cramer www.postgres.rocks On Wed, 9 Dec 2020 at 03:15, electrotype wrote: > I can't see how they could possibly be out of order. > > Thanks, that what I think too. But, to be honest, I'd really like to see > this written in some d

Re: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made?

2020-12-09 Thread Dave Cramer
On Wed, 9 Dec 2020 at 10:21, electrotype wrote: > So I'm curious. Why does order matter ? > > Dave Cramer > www.postgres.rocks > > > When you have to save multiple new entities with subentities. > > You first save all the parent entities in a single SQL batch insert,

Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...

2020-12-02 Thread Dave Cramer
> Regards, > > Martin. > > -- > Martin Goodson > > Whatever you've got planned, forget it. I'm the Doctor. > I'm 904 years old. I'm from the planet Gallifrey in the > constellation of Kasterborous. I am The Oncoming Storm, > the Bringer of Darkness and you are ... basically just a > rabbit, aren't you? OK, carry on, just a general ... > warning. > > I'm guessing this is now resolved ? Dave Cramer www.postgres.rocks

Re: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made?

2020-12-11 Thread Dave Cramer
uch > non-orderedness is simply a matter of time. With batching it seems best to > combine its use with single inserts in order to avoid this problem. > > David J. > I'd have to agree. Dave Cramer www.postgres.rocks

Re: Christopher Browne

2020-11-04 Thread Dave Cramer
On Wed., Nov. 4, 2020, 8:10 p.m. raf, wrote: > On Wed, Nov 04, 2020 at 06:29:18PM -0500, Steve Singer > wrote: > > > > > It is with much sadness that I am letting the community know that Chris > > Browne passed away recently. > > > > Chris had been a long time community member and was active on

Re: Edb Jdbc Ssl Connection

2021-02-01 Thread Dave Cramer
Please follow the instructions here Configuring the Client (postgresql.org) <https://jdbc.postgresql.org/documentation/head/ssl-client.html> <https://jdbc.postgresql.org/documentation/head/ssl-client.html> Dave Cramer www.postgres.rocks On Mon, 1 Feb 2021 at 01:44, wrote: > &g

Re: SV: Npgsql and the Connection Service File

2021-02-03 Thread Dave Cramer
On Mon, 1 Feb 2021 at 04:51, Niels Jespersen wrote: > >On Sat, 2021-01-30 at 15:56 +, Niels Jespersen wrote: > >> It would be nice if Npgsql (and jdbc and others) emulated the libpq > behaviour. > >> Because in my mind, abstracting hostname, portnumber and databasename > >> away is a really

Re: Notify When Streaming Replication Failover Occurred (slave promoted to master).

2021-06-14 Thread Dave Cramer
On Sun, 13 Jun 2021 at 19:32, Avi Weinberg wrote: > I need to take actions when Postgres streaming replication failover > occurred. Is there a way to be notified when Postgres slave becomes > master? If no such notification possible, what is the best way to actively > monitor which server is

Re: bottom / top posting

2021-06-09 Thread Dave Cramer
> The reason why the old-timers around here are sticky about this is that > we believe we are writing for the mailing list archives. Gmail-style > quoting is indeed the appropriate amount of effort for throwaway threads > that only a few people will read and (probably) none of them will consult >

Re: Insertion time is very high for inserting data in postgres

2021-02-10 Thread Dave Cramer
On Wed, 10 Feb 2021 at 06:11, Niels Jespersen wrote: > >Fra: prachi surangalikar > > > > > >Hello Team, > > >Greetings! > > > > > >We are using Postgres 12.2.1 for fetching per minute data for about 25 > machines but running parallely via a single thread in python. > > >But suddenly the

Re: Is replacing transactions with CTE a good idea?

2021-04-01 Thread Dave Cramer
alent to serializable transactions? So I > guess the downsize is that quarries can’t be run in parallel? > I do not think a CTE changes the isolation level. > > If I decide to replace all my transaction code with CTE, will I shoot > myself in the foot down the road? > Dave Cramer www.postgres.rocks

Re: Is replacing transactions with CTE a good idea?

2021-04-01 Thread Dave Cramer
CTE's don't change the isolation level. I'm not sure what you are getting at here ? Dave Cramer www.postgres.rocks On Thu, 1 Apr 2021 at 11:20, Glen Huang wrote: > Sorry, my mistake. I misunderstood serializable. Are queries in a CTE > equivalent to those in a repeatable read trans

Re: Is replacing transactions with CTE a good idea?

2021-04-01 Thread Dave Cramer
On Thu, 1 Apr 2021 at 11:09, Glen Huang wrote: > No, but are they equivalent to serializable transactions? > No, they are not. Dave Cramer www.postgres.rocks > > On Apr 1, 2021, at 11:04 PM, Dave Cramer > wrote: > >  > > > > On Thu, 1 Apr 2021 at 10:5

Re: Is replacing transactions with CTE a good idea?

2021-04-05 Thread Dave Cramer
On Mon, 5 Apr 2021 at 14:18, Bruce Momjian wrote: > On Sun, Apr 4, 2021 at 10:02:20AM -0400, Dave Cramer wrote: > > On Sun, 4 Apr 2021 at 09:12, Bruce Momjian wrote: > > > OK, that makes sense, but I think it is wrong minded to think that > this > > > ab

Re: Is replacing transactions with CTE a good idea?

2021-04-04 Thread Dave Cramer
On Thu, 1 Apr 2021 at 15:39, Bruce Momjian wrote: > On Thu, Apr 1, 2021 at 11:24:48AM -0400, Dave Cramer wrote: > > CTE's don't change the isolation level. I'm not sure what you are > getting at > > here ? > > I think what he/she means here is that all queries in a CTE

Re: Is replacing transactions with CTE a good idea?

2021-04-04 Thread Dave Cramer
On Sun, 4 Apr 2021 at 09:12, Bruce Momjian wrote: > On Sun, Apr 4, 2021 at 08:35:41AM -0400, Dave Cramer wrote: > > > > > > On Thu, 1 Apr 2021 at 15:39, Bruce Momjian wrote: > > > > On Thu, Apr 1, 2021 at 11:24:48AM -0400, Dave Cramer wrote: > >

Re: Problem with trigger function

2021-02-11 Thread Dave Cramer
FWIW, messing with serial numbers like this is pretty risky.Sequences have transactional semantics for a reason. Dave Cramer www.postgres.rocks On Thu, 11 Feb 2021 at 14:57, Steve Baldwin wrote: > Try ... EXECUTE PROCEDURE customer_num_informix() > > Steve > > On Fri, Feb 12,

Re: postgres disconnects on master after setting up replication

2021-08-17 Thread Dave Cramer
Dave Cramer www.postgres.rocks On Mon, 16 Aug 2021 at 12:32, Andy Hall wrote: > thanks for the very clear explanation much appreciated shall take this > back to the team. > > On Mon, 16 Aug 2021 at 17:14, Tom Lane wrote: > > > > Andy Hall writes: > > > we h

Re: move data repository : server does not restart (windows 10)

2021-08-12 Thread Dave Cramer
It would be helpful to see the logs from the failed start. Dave Cramer www.postgres.rocks On Thu, 12 Aug 2021 at 07:59, celati Laurent wrote: > Good morning, > > I want to move the data folder from default path to another drive/path. > I made an attempt thaks to this li

Re: Issue with PSQL JDBC Driver Null Pointer

2021-07-29 Thread Dave Cramer
On Thu, 29 Jul 2021 at 15:44, Bhavesh Mistry wrote: > Hi Dave, > > It still does not address the NPE issue. If an alias is NULL. What > should be the behavior? > > > public String getTypeForAlias(String alias) { > String type = TYPE_ALIASES.get(alias); > if (type != null) { > return type; > } >

Re: Issue with PSQL JDBC Driver Null Pointer

2021-07-29 Thread Dave Cramer
On Thu, 29 Jul 2021 at 11:04, Bhavesh Mistry wrote: > Hello, > > I am getting an NPE exception in the JDBC driver 42.2.23. > > When the alias is null, NPE results. Is it possible to handle null value > ? I have filled a bug against RCA >

Re: Re: Timestamp with vs without time zone.

2021-09-21 Thread Dave Cramer
re than just > weird. "timestamp without timezone" should be called "local timestamp > with unspecified timezone" and "timestamp with timezone" should be > called "global timestamp without timezone". However, those aren't SQL > names. > > I would say this is a perspective thing. It's a timestamp with a time zone from the client's perspective. > Dave Cramer > www.postgres.rocks > >

Re: Re: Timestamp with vs without time zone.

2021-09-21 Thread Dave Cramer
On Tue, 21 Sept 2021 at 13:40, Peter J. Holzer wrote: > On 2021-09-21 13:34:21 -0400, Dave Cramer wrote: > > On Tue, 21 Sept 2021 at 13:20, Peter J. Holzer wrote: > > On 2021-09-21 20:50:44 +1200, Tim Uckun wrote: > > > It's just that the phrase "timesta

Re: a very naive question about table names in Postgres

2022-01-01 Thread Dave Cramer
On Fri, 31 Dec 2021 at 16:25, Paul Jungwirth wrote: > On 12/31/21 12:27 PM, Martin Mueller wrote: > > I know that on my Mac the tables are kept in the data directory > > /Users/martinmueller/Library/Application Support/Postgres/var-13. If I > > go there I see that internally the tables have

Re: Performance question about using autosave=always and cleanupSavepoints=true

2021-11-16 Thread Dave Cramer
On Tue, 16 Nov 2021 at 11:09, Joel Rabinovitch wrote: > Hi, > > > > Currently, our application supports SQL Server databases and Oracle > schemas. We are updating our application to support PostgreSQL schemas. We > are using version 13.4 of PostgreSQL. > > > > Our application is written in Java

Re: Pg_hba.conf problem after unexpected IP change

2021-11-12 Thread Dave Cramer
On Fri, 12 Nov 2021 at 06:12, Yessica Brinkmann wrote: > Hello. > Thank you very much for your answer. > Yes, I restart the server after making the changes. > Regards, > Yessica Brinkmann > Check the logs for postgres to make sure there were no errors in your new configura

Re: Logical replication from Rds into on-premise

2021-07-27 Thread Dave Cramer
Dave Cramer www.postgres.rocks On Mon, 26 Jul 2021 at 18:43, Cory Nemelka wrote: > > On Mon, Jul 26, 2021 at 12:06 PM Rama Krishnan > wrote: > >> Hi all, >> >> I have a postgres server on Aws RDS no i want to replicate the data or >> logical replication int

Re: How to debug incomplete message on postgres 12.3 docker

2022-01-16 Thread Dave Cramer
Dave Cramer www.postgres.rocks On Sun, 16 Jan 2022 at 10:13, R Batchen wrote: > > Hello, > > I hope i reached the right mailing list, i have psql 12.3 container that > is the db of apache guacamole container is connected to, > the apache guacamole stopped working an

Re: Right version of jdbc

2023-09-25 Thread Dave Cramer
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

Re: Right version of jdbc

2023-09-25 Thread Dave Cramer
It must be a dependency to something. postgis ? Dave Cramer www.postgres.rocks On Mon, 25 Sept 2023 at 09:25, Raivo Rebane wrote: > Hi, > postgresql-8.3-603.jdbc4.jar is added by maven maven install. How to > avoid it ? >

Re: Right version of jdbc

2023-09-28 Thread Dave Cramer
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

Re: Right version of jdbc

2023-09-28 Thread Dave Cramer
The latest version of postgis-jdbc is 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 Thu, 28 Sept 2023 at 14:51, Raivo Rebane wrote: > Hi, > > T

Re: Right version of jdbc

2023-09-29 Thread Dave Cramer
Dave Cramer www.postgres.rocks On Fri, 29 Sept 2023 at 06:19, Raivo Rebane wrote: > Hi, > > The code is : > package MushroomAPIs; > > import java.io.IOException; > import javax.servlet.ServletException; > import javax.servlet.annotation.WebServlet; > import jav

Re: Right version of jdbc

2023-09-28 Thread Dave Cramer
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-

Re: Right version of jdbc

2023-09-30 Thread Dave Cramer
Again, can you please post the solution so others can learn as well ? Dave Cramer www.postgres.rocks On Sat, 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 &g

Re: Right version of jdbc

2023-09-27 Thread Dave Cramer
lob/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,

Re: Right version of jdbc

2023-09-25 Thread Dave Cramer
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 wrote: > Hi, > I use : > PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit > and > PostGIS 3.3 USE_GEOS=1 USE_PRO

Re: Right version of jdbc

2023-09-25 Thread Dave Cramer
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 wrote: > Hi, > > The latest version of the driver is usually the right answer. So 42.5.4 > Dave Cramer > www.postgres.rocks > &

Re: Right version of jdbc

2023-09-25 Thread Dave Cramer
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 wrote: > Hi, > now I using following - > [INFO] Copying postgis-jdbc-2.1.7.jar to > C:\Users\Raivo\eclipse-workspace\ba

Re: Right version of jdbc

2023-09-25 Thread Dave Cramer
remove the postgresql-8.3-603.jdbc4.jar Dave Cramer www.postgres.rocks On Mon, 25 Sept 2023 at 08:43, Raivo Rebane wrote: > And target/lib is s following : > Directory of C:\Users\Raivo\eclipse-workspace\backendproject\target\lib > > 25.09.2023 15:35 . > 25

Re: Right version of jdbc

2023-09-29 Thread Dave Cramer
On Fri, 29 Sept 2023 at 14:22, Raivo Rebane wrote: > Thanks, > > there was really JDK 17 in use. > I changed it to Java 1.8 > PS C:\Program Files\Apache Software Foundation\Tomcat 9.0\bin> java > -version > java version "1.8.0_381" > Java(TM) SE Runtime Environment (build 1.8.0_381-b09) > Java

Re: Driver Postgresql HP-Unix

2023-10-21 Thread Dave Cramer
On Sat, 21 Oct 2023 at 05:50, Justin Clift wrote: > On 2023-10-19 04:45, Abelardo Erazo Lopez wrote: > > Hi, Everyone > > > > I have an Oracle database Oracle 19c and I need to access a PostgreSQL > > database 15.4 that resides on a different server. I see that one > > alternative is to use

Re: The same prepared query yield "-1" the first six times and then "-1.0"

2023-08-21 Thread Dave Cramer
On Mon, 21 Aug 2023 at 15:12, Edoardo Panfili < edoardo.panf...@iisgubbio.edu.it> wrote: > > > Il giorno 21 ago 2023, alle ore 17:45, Adrian Klaver < > adrian.kla...@aklaver.com> ha scritto: > > On 8/21/23 08:27, Edoardo Panfili wrote: > > Hello, > I am using > postgresql version: 15.3 (Debian

Re: The same prepared query yield "-1" the first six times and then "-1.0"

2023-08-21 Thread Dave Cramer
On Mon, 21 Aug 2023 at 14:42, Edoardo Panfili wrote: > > > > Il giorno 21 ago 2023, alle ore 20:13, Peter J. Holzer > ha scritto: > > > > On 2023-08-21 17:27:20 +0200, Edoardo Panfili wrote: > >> The attended result was a sequence of ten equal values but this is the > actual result: > >> p: -1

Re: JDBC + PG-15 but not psql

2023-08-21 Thread Dave Cramer
Hi Amn, Can you help me understand this issue better? I don't see anywhere in the code where you are attempting to create a tablespace ? Dave Cramer On Sun, 20 Aug 2023 at 11:17, Amn Ojee Uw wrote: > Hello. > > I have searched the net in an attempt to find if others

Re: The same prepared query yield "-1" the first six times and then "-1.0"

2023-08-21 Thread Dave Cramer
On Mon, 21 Aug 2023 at 12:46, Tom Lane wrote: > "David G. Johnston" writes: > > Otherwise, I agree this seems like a bug, probably in the JDBC driver, > > though one pertains to style as opposed to semantics since both answers > are > > technically correct. > > I don't see any such behavior

Re: The same prepared query yield "-1" the first six times and then "-1.0"

2023-08-21 Thread Dave Cramer
On Mon, 21 Aug 2023 at 17:17, Ron wrote: > On 8/21/23 14:32, Dave Cramer wrote: > > [snip] > > It has to do with the way the data is being transferred. When the driver > switches to a named statement it also switches to binary mode which means > data will be transferred in b

Re: Looking for PostgreSQL Tuning Workshop Presenter

2023-08-18 Thread Dave Cramer
Hi Rumpi, We do have a Speaker Bureau - PostgreSQL wiki <https://wiki.postgresql.org/wiki/Speaker_Bureau> you can try there. Also if your group qualifies it's possible to get funding for your meetup group if you have one. Dave Cramer On Thu, 17 Aug 2023 at 10:03, Rumpi Gravenstein

Re: The same prepared query yield "-1" the first six times and then "-1.0"

2023-08-22 Thread Dave Cramer
On Tue, 22 Aug 2023 at 01:54, Edoardo Panfili wrote: > > > Il giorno 21 ago 2023, alle ore 21:37, Dave Cramer > ha scritto: > > > > On Mon, 21 Aug 2023 at 14:42, Edoardo Panfili wrote: > >> >> >> > Il giorno 21 ago 2023, alle ore 20:13, P

Re: JDBC + PG-15 but not psql

2023-08-22 Thread Dave Cramer
Hi Amn, What I don't understand is the requirement to set autocommit to true since this is the default ? Either way this is expected behaviour as psql also has autocommit true by default. Thanks, Dave Cramer On Mon, 21 Aug 2023 at 20:57, Amn Ojee Uw wrote: > Thanks Dave for your inter

Re: Right version of jdbc

2023-11-09 Thread Dave Cramer
src/main/java/MushroomAPIs line 47 Java Problem >>> Point cannot be resolved to a type ProcAddMushrooms.java >>> /KatseAPIs/src/main/java/MushroomAPIs line 83 Java Problem >>> Point cannot be resolved to a type Utils.java >>> /KatseAPIs/src/main/java/MushroomAPIs line