Skip to main content

I have created simple pipeline, Jdbc consumer(mysql) and at destination JDBC producer (oracle 12c).

It is giving me error like table doesn’t exist. But table is present in oracle DB.

 

To clear a doubt regarding the connection I cross checked by taking the same table in another pipeline JDBC consumer as origin to fetch data andI am able to fetch records. But Issue is destination.

Is anyone have solution on this. Please let me know.

Hi @akshayp2 This error can be shown if you do not specify schema and then table name is not in the correct format. Kindly provide the functional JDBC string that you have utilized for the JDBC origin, along with a screenshot of the JDBC destination connection configuration.


@akshayp2 

The JDBC producer configuration should look like below screen shot.

 

 

 


Yes, I used same configuration.
In below snippet I am loading data into oracle table. It gives me error that table or view does not exist.

But I fetch records from same table same schema it gives me result.

​​​​

 


@akshayp2 

Please check the below configuration correctly , its a configuration issue.

  • jdbc connectivity
  • schema name as per DB , jdbc producer is case sensitivity
  • Table should be as per db 

 


@akshayp2 

Please make sure your jdbc connection for oracle connectivity as below.

 

jdbc:oracle:<driver_type>:@<host>:<port>:<service_name>


@Rishi Below is the screenshot for the connection string

 

JDBC destination configuration

 

schema c##super is having dba privileges. 


@Bikram Its worked. case sensitivity was the problem.


@Bikram @Rishi Thank you for your response.


@akshayp2 

The jdbc URL  for oracle should like below

 

jdbc:oracle:thin:@127.0.0.1:1521:ORCLCDB_localadmin , there shouldn’t be / in the URL.

Please try it and do let me know if it helps.


@akshayp2 

 

Nice to know it works for you  , JDBC is very case sensitive. 


Reply