Hi,
I am currently writing a processor to write OpenAI embeddings to Postgres.
I am using DBCPConnectionPool for this.
I use Maven to integrate PGVector (https://github.com/pgvector/pgvector).
With pure JDBC this works fine. With the database classes from NiFi I
get the error:
*Cannot infer the
Hey Uwe,
The DBCPConnectionPool returns a java.sql.Connection. From that you’d create a
Statement. So I’m a little confused when you say that you’ve got it working in
Pure JDBC but not with NiFi, as the class returned IS pure JDBC. Perhaps you
can share a code snippet of what you’re doing in th
This means the JDBC driver you're using does not support the use of
the two-argument setObject() call when the object is a PGVector. Did
you register the Vector type by calling:
PGvector.addVectorType(conn);
The documentation [1] says that the two-argument setObject() should
work if you have regi
+1 (binding)
Verified signature, hashes.
Built on debian and mac.
Executed all tests successfully, verified c2 functionality, designed
multiple flows, verified those.
Thanks,
Arpad
On Wed, Aug 30, 2023 at 7:11 PM Gábor Gyimesi wrote:
> +1 (non-binding)
>
> Went through the verification proce
Mark & Matt,
Thanks for the quick help. I really appreciate it.
PGvector.addVectorType(con) returns the following:
*java.sql.SQLException: Cannot unwrap to org.postgresql.PGConnection*
Could this be a connection pool issue?
Interestingly, I didn't call addVectorType() at all in my test java co
Maybe this [1]? Perhaps you have to call unwrap() yourself in this
case. IIRC you don't have access to the DataSource but you can check
it directly on the connection.
Regards,
Matt
[1]
https://stackoverflow.com/questions/36986653/cast-java-sql-connection-to-pgconnection
On Thu, Aug 31, 2023 at