JDBC_16 - Table '' does not exist or PDB is incorrect. Make sure the correct PDB was specified

[unniku...@gmail.com]

Hi, 
     I have a problem while inserting data to mysql from kafka, in the jdbc connection i specified table name and field name of tables correctly. While browsing with this error i got a solution that table name should be given as capital letter like : "PATIENT". But i still getting the error, please help me to resolve this issue.

The error i got from jdbc destination is :-

"com.streamsets.pipeline.api.base.OnRecordErrorException: JDBC_16 - Table '' does not exist or PDB is incorrect. Make sure the correct PDB was specified"

Regards,
Unnikrishnan

[unniku...@gmail.com]

Error is cleared by me, but problem is data not getting to be inserted on the table in mysql. Could anyone help to solve the issue.

[Pat Patterson]

Most likely issue is that the table name in the JDBC Producer is set to something like ${record:attribute('tablename')}, but this attribute isn't in your data. If all of the data in the pipeline is going to the same table, you can just use a literal table name - e.g. PATIENT

If this doesn't fix it, please export your pipeline to JSON, remove any usernames/passwords, post it, and we can take a look.

Cheers,

Pat

--

Pat Patterson | Community Champion | http://about.me/patpatterson

--
You received this message because you are subscribed to the Google Groups "sdc-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdc-user+unsubscribe@streamsets.com.
Visit this group at https://groups.google.com/a/streamsets.com/group/sdc-user/.

[unniku...@gmail.com]

Thank you Pat for your valuable information the issue is solved, i created the table based on the datatype from my json. But while inserting it generates an error like:-

"Pipeline Status: RUNNING_ERROR: com.streamsets.pipeline.api.base.OnRecordErrorException: JDBC_23 - The field 'meanQRS' of type 'DOUBLE' doesn't match the destination column's type."

My datatype for the field is showing double while previewing the data also i created the type as double in the table in such scenario how i get the error like this.

Please find the attached preview details too.

To unsubscribe from this group and stop receiving emails from it, send an email to sdc-user+u...@streamsets.com.

[unniku...@gmail.com]

On Tuesday, February 6, 2018 at 10:09:24 PM UTC+5:30, Pat Patterson wrote:

To unsubscribe from this group and stop receiving emails from it, send an email to sdc-user+u...@streamsets.com.

[unniku...@gmail.com]

Hi Pat,
          The issue regarding the table name is solved by your valuable reply, but got another error as:-

"Pipeline Status: RUNNING_ERROR: com.streamsets.pipeline.api.base.OnRecordErrorException: JDBC_23 - The field 'meanQRS' of type 'DOUBLE' doesn't match the destination column's type."

In my table i set the datatype for the field is double and while previewing the streamsets it also shows the field "meanQRS" as double, So how this error happends while inserting into the table..
Please help me..
Regards,
Unnikrishnan

On Tuesday, February 6, 2018 at 10:09:24 PM UTC+5:30, Pat Patterson wrote:

To unsubscribe from this group and stop receiving emails from it, send an email to sdc-user+u...@streamsets.com.

[unniku...@gmail.com]

Please find the attached preview screenshot of streamsets.

[ravi singh]

Hi pat,

I have to get same error JDBC_16 - Table '' does not exist or PDB is incorrect. Make sure the correct PDB was specified while using ORACLE 12c   

i tryied oracle multiple version

ojdbc7-12.1.0.2.jar
ojdbc7-12.1.0.jar

ojdbc8.jar

my oracle version is oracle 12c

plz help

On Tuesday, February 6, 2018 at 10:09:24 PM UTC+5:30, Pat Patterson wrote:

To unsubscribe from this group and stop receiving emails from it, send an email to sdc-...@streamsets.com.