Ask Your Question
0

JDBC Producer error - table or view does not exist

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

Anji gravatar image

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 gravatar imageiamontheinet ( 2019-11-25 16:19:16 -0600 )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 gravatar imageAnji ( 2019-11-26 08:56:06 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2019-11-26 09:38:52 -0600

iamontheinet gravatar image

Hi!

Make sure you specify the schema name separately under Schema Name. What you do include in the JDBC connection string is the DB name. See below.

image description

Cheers, Dash

edit flag offensive delete link more

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 gravatar imageAnji ( 2019-11-26 10:13:04 -0600 )edit

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

iamontheinet gravatar imageiamontheinet ( 2019-11-26 10:16:33 -0600 )edit

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

Anji gravatar imageAnji ( 2019-11-26 11:19:28 -0600 )edit

You're welcome!

iamontheinet gravatar imageiamontheinet ( 2019-11-26 11:22:09 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-11-25 15:04:41 -0600

Seen: 31 times

Last updated: Nov 26