Stack Overflow
Stack Overflow

Questions tagged [pgjdbc-ng]

11 questions
3
votes
2 answers

jOOQ returns offset date time as Z (UTC) even though it's not

I have a simple Postgres test table of id, timestamp with timezone. The test and output below should be self explanatory, but to summarize, I insert a row that has a timestamp with a -6 offset. It is properly inserted into the database, then loaded…
Evan
  • 2,441
  • 23
  • 36
2
votes
0 answers

Implementing SQLData interface for composite rows

I am following official psql user guide on composite types (https://www.postgresql.org/docs/current/rowtypes.html) and trying to implement SQLData for the inventory_item type…
Kirill Salykin
  • 681
  • 6
  • 19
2
votes
1 answer

How do I configure HikariCP correctly to work with connections that have to stay active?

I am using Spring Boot 2.4.0 with Spring Boot Data JPA to connect to PostgreSQL and perform typical read and write operations with JPA based repositories. Since the database is also used by other services, I use the LISTEN/NOTIFY functionality…
tomson
  • 111
  • 2
  • 12
2
votes
1 answer

Use Testcontainers with another Database Driver

I am using Testcontainers (https://www.testcontainers.org/) with the Postgres module in a Spring Boot application with Kotlin and have configured everything as in this tutorial…
tomson
  • 111
  • 2
  • 12
1
vote
0 answers

Spring Boot application using HikariCP and impossibl/pgjdbc-ng driver fails to connect to pgbouncer

we have implemented a spring-boot application using HikariCP and the impossibl/pgjdbc-ng driver. The application is running fine as long as the database connection url refers to a postgres database. However, when the database url contains the…
priderider
  • 21
  • 1
1
vote
0 answers

pgjdbc-ng throws mysterious ServiceLoader error

I'm getting a very weird error in my logs. This just started happening randomly and was not triggered by a version upgrade of anything. 2019-08-23 14:49:41.150 ccleves-mac-mini.local com.zaxxer.hikari.HikariDataSource 7177 INFO HikariPool-2 -…
ccleve
  • 15,239
  • 27
  • 91
  • 157
1
vote
1 answer

"SQLException: Unwrap error" with JDBI and PGJDBC-NG Postgres Driver

I'm using JDBI to connect to my Postgres db. This has been working fine. Today I decided to try replacing the native Postgres driver with PGJDBC-NG driver. Everything is fine until I try my first simple query: jdbi.useExtension(FooDao.class, dao ->…
Madbreaks
  • 19,094
  • 7
  • 58
  • 72
0
votes
0 answers

PGSQLSimpleException: Connection Error: io.netty.util.concurrent.BlockingOperationException: DefaultChannelPromise

I am using com.impossibl.pgjdbc-ng package to listen to postgres channel which notifies on every insert/update of a table. My java code is : PGDataSource dataSource1 = new PGDataSource(); // credentials PGDataSource dataSource2 = new…
dpilwal
  • 361
  • 1
  • 5
  • 14
0
votes
1 answer

Postgresql connecting issue with pgjdbc-ng

I am trying to connect postgresql with pgjdbc-ng(0.8.9) for asynchronous listener. Everything work fine when developing, but I got connect timeout in SIT environment. There is a postgresql 13 server in SIT, force client connect with ssl, use tls…
Bernie.T
  • 11
  • 3
0
votes
0 answers

why PostgreSql Driver PGJDBC-NG giving Error

I am trying to connect using PGJDBC-NG Driver with my Postgres Db. But on sql running it is giving error. org.springframework.web.util.NestedServletException: Handler dispatch failed; nested exception is java.lang.IncompatibleClassChangeError: Class…
Comrade Bansu
  • 1
  • 1
0
votes
1 answer

REF CURSOR is not working with pgjdbc-ng driver

I am trying an example to return REFCURSOR using PGJDBC-NG Driver but getting an exception java.lang.ClassCastException: java.lang.String cannot be cast to java.sql.ResultSet at…
LAKS
  • 1
  • 1