Ask Your Question

Revision history [back]

check : 1)default port number 5432 for PostgreSQL is open 2)place the PostgreSQL connector jar in /streamsets/lib/streamsets-jdbc-connector-lib/

check :

 1)default port number 5432 for PostgreSQL is open
          2)place the PostgreSQL connector jar in /streamsets/lib/streamsets-jdbc-connector-lib/

/streamsets/lib/streamsets-jdbc-connector-lib/

check :

         1)default port number 5432 for PostgreSQL is open
         2)place the PostgreSQL connector jar in /streamsets/lib/streamsets-jdbc-connector-lib/
the path 
          streamsets-datacollector-3.3.0/streamsets-libs/streamsets-datacollector-jdbc-lib/lib/

check :

         1)default port number 5432 for PostgreSQL is open
          2)place the PostgreSQL connector jar in the path 
  streamsets-datacollector-3.3.0/streamsets-libs/
 streamsets-datacollector-3.3.0/streamsets-libs/streamsets-datacollector-jdbc-lib/lib/
        streamsets-datacollector-jdbc-lib/lib/

check :

         1)default port number 5432 for PostgreSQL is open

         2)place the PostgreSQL connector jar in the path 

         streamsets-datacollector-3.3.0/streamsets-libs/
         streamsets-datacollector-jdbc-lib/lib/

         3)check the exact schema name.(example public)

check :

         1)default port number 5432 for PostgreSQL is open

         2)place the PostgreSQL connector jar in the path 

         streamsets-datacollector-3.3.0/streamsets-libs/
         streamsets-datacollector-jdbc-lib/lib/

         3)check the exact schema name.(example public)
           You can use the command :
           select schema_name from information_schema.schemata 
           and check what is the schema name for your db.
           Specify the name in  the schema tab.

check :

         1)default port number 5432 for PostgreSQL is open

         2)place the PostgreSQL connector jar in the path 

         streamsets-datacollector-3.3.0/streamsets-libs/
         streamsets-datacollector-jdbc-lib/lib/

         3)check the exact schema name.(example public)
           You can use the command :
           select schema_name from information_schema.schemata 
           and check what is the schema name for your db.
           Specify the same name in  the schema tab.

check :

         1)default port number 5432 for PostgreSQL is open

         2)place the PostgreSQL connector jar in the path 

         streamsets-datacollector-3.3.0/streamsets-libs/
         streamsets-datacollector-jdbc-lib/lib/

         3)check the exact schema name.(example public)
           You can use the command :
           select schema_name from information_schema.schemata 
           and check what is the schema name for your db.
           Specify the same name in  the schema tab.

         4)Check the exact case of you table name.It might be case sensitive.
            check using \d

check :

         1)default port number 5432 for PostgreSQL is open

         2)place the PostgreSQL connector jar in the path 

         streamsets-datacollector-3.3.0/streamsets-libs/
         streamsets-datacollector-jdbc-lib/lib/

         3)check the exact schema name.(example public)
           You can use the command :
           select schema_name from information_schema.schemata 
           and check what is the schema name for your db.
           Specify the same name in  the schema tab.
tab .
           Database name should be mentioned in JDBC connection URL

         4)Check the exact case of you your table name.It might be case sensitive.
            check using \d