Eric, Hello there and glad you're finding goodness in NiFi.
So setting this up. First step is making sure you have the proper driver for your JAR available on the classpath. You could for instance grab the necessary postgres JDBC driver jar from the postgres site and put it into the nifi/lib directory then start nifi. Second step as you noticed is getting the DBConnectionPool setup. The properties for that would be something like: database url = jdbc:postgresql://5.5.5.5:5432/database database driver classname = org.postgresql.Driver database user = username database password = password ...edit other properties as desired... Then start up that controller services. Third step is to setup the ExecuteSQL processor. It references whatever your new connection pool controller service is called. Enter your query. And fire up the processor. Does that help? Please do provide logs/errors about any glitches you run into and we can help walk through it. Thanks Joe On Fri, Aug 7, 2015 at 9:27 PM, eric schwarz <[email protected]> wrote: > hi: i'm having trouble getting the executesql processor to run. i'm > attempting to do a simple select from a table in postgres and put it in a > file. i'm quite certain my issue is understanding the details of the > DBPCConnection pool entries. specifically the first three. Database > connection url, database driver class name, and if needed database driver > jar url. > > i'm used to connecting directly to posgres via IP and port, and doing JDBC > pooling connect to postgres via tomcat but can't seem to find examples or > enough details to figure it out for this nifi processor. > > any help would be appreciated. great project and work in nifi! > > thanks > eric
