JDBC Producer error - table or view does not exist

asked 2019-11-25 15:04:41 -0500

Anji
1 ●1 ●1 ●1

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.

edit retag flag offensive close merge delete

Comments

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.

iamontheinet ( 2019-11-25 16:19:16 -0500 )edit

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

Anji ( 2019-11-26 08:56:06 -0500 )edit

add a comment

Comments

Thank you Dash !!! even after specifying schema name also giving same error, i am trying to add my config screen shot not sure how to do it here.

Anji ( 2019-11-26 10:13:04 -0500 )edit

Can you also try upper casing both schema and table name?

iamontheinet ( 2019-11-26 10:16:33 -0500 )edit

seems Schema name is the problem, it worked now, thank you very much for your help !!!!

Anji ( 2019-11-26 11:19:28 -0500 )edit

You're welcome!

iamontheinet ( 2019-11-26 11:22:09 -0500 )edit

add a comment

JDBC Producer error - table or view does not exist

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

JDBC Producer error - table or view does not exist edit

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

JDBC Producer error - table or view does not exist