Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

executeLargeUpdate not implemented #540

Open
tlf30 opened this issue Dec 1, 2021 · 1 comment
Open

executeLargeUpdate not implemented #540

tlf30 opened this issue Dec 1, 2021 · 1 comment

Comments

@tlf30
Copy link

tlf30 commented Dec 1, 2021

Hello,
I'm using pgjdbc-ng and hikari to connect to a postgresql 14 database.
Without P6Spy my application works great, but when I implemented the P6DataSource wrapper around my pgjdbc-ng datasource before handing it to hikari, I receive the following error that executeLargeUpdate is not implemented.

java.lang.UnsupportedOperationException: executeLargeUpdate not implemented
	at java.sql/java.sql.PreparedStatement.executeLargeUpdate(PreparedStatement.java:1320)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeLargeUpdate(HikariProxyPreparedStatement.java)
        ... <stack trace censored>

I use two executeLargeUpdate on a prepared statement in two places due to selecting a massive number of rows. (yes, this takes a while) It would be great to get this implemented in P6Spy.

@tlf30
Copy link
Author

tlf30 commented Dec 7, 2021

I found another one, setObject is not implemented.

java.sql.SQLFeatureNotSupportedException: setObject not implemented
	at java.sql/java.sql.PreparedStatement.setObject(PreparedStatement.java:1293)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.setObject(HikariProxyPreparedStatement.java)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant