Member since
06-13-2024
3
Posts
0
Kudos Received
0
Solutions
09-15-2025
10:55 AM
Thank you for replying, that's the exact solution I eventually settled on. Best, Shelly
... View more
09-10-2025
12:29 PM
I am running into a problem with my DBCPConnectionPool service in Nifi and am hoping that someone has some experience with this. I'm using Nifi 2.0.0-M2. My current Database Connection URL is jdbc:postgresql://myurl:5432/mydatabase?currentSchema=public&stringtype=unspecified This works great with no issues. However, I want to add another schema in there so I don't have to specify the new schema in my queries throughout all my nifi flows. For example, I was hoping this would work: jdbc:postgresql://myurl:5432/mydatabase?currentSchema=myschema,public&stringtype=unspecified But when I do a query like "select * from mytable" with ExecuteSQL, I get an error: org.postgresql.util.PSQLException: ERROR: relation "mytable" does not exist If I change the query to "select * from myschema.mytable", it works. Chatgpt recommended I try this, but it also didn't work: jdbc:postgresql://myurl:5432/mydatabase?options=-c%20search_path=myschema,public&stringtype=unspecified Has anyone been able to successfully specify a different schema other than just public? I would just include the schema name in all my queries (which works), but we are going to do a separate prod and dev instance and I don't want to have to change all my queries depending on whether I'm using myschema or myschema-dev.
... View more
Labels:
- Labels:
-
Apache NiFi
01-07-2025
07:26 AM
I am using Nifi 1.23.2. I am using ListSFTP with Tracking Entities listing strategy. I'm using RedisDistributedMapCacheClientService as my Entity Tracking State Cache. The initial listing gets all files (around 500k files). The processor appears to run every minute as scheduled, but it never finds any more files. If I copy the processor and run it again, the initial listing will again get all files (now more than 500k files, since files have been added). But it never gets any more files. What am I missing?
... View more
Labels:
- Labels:
-
Apache NiFi