JDBC Producer error - table or view does not exist
hi, we are trying to update the table with JDBC producer, however it is giving below error, seems we have all correct configuration. can you please help here
com.streamsets.pipeline.api.base.OnRecordErrorException: JDBC_16 - Table 'abcccc' does not exist or PDB is incorrect. Make sure the correct PDB was specified
Thanks, Anji.
Can you confirm that you have specified Schema Name as well? Also note that Oracle is pretty strict about upper/lower case schema and table names which could cause it to throw that error.
Thank you for your response !!! Yes, we gave schema name as part of JDBC URL and left schema name text areas as blank, FYI.. both schema & table names we have given in lower case. Below is the JDBC URL format that we are trying. jdbc:oracle:thin:@abc.ssss:1234:rtses12