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.
Best answer by Bikram
Please check the below configuration correctly , its a configuration issue.
Hi
+1Yes, 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.
+1Please check the below configuration correctly , its a configuration issue.
+1Please make sure your jdbc connection for oracle connectivity as below.
jdbc:oracle:<driver_type>:@<host>:<port>:<service_name>
JDBC destination configuration
schema c##super is having dba privileges.
+1The 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
