Solved

Facing issue while loading data into oracle table.

  • 30 July 2023
  • 9 replies
  • 40 views
A
Rank

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.

icon

Best answer by Bikram 31 July 2023, 11:08

View original

9 replies

Rishi
Rank
Userlevel 4
Badge

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.

Bikram
Rank
Userlevel 5
Badge +1

@akshayp2 

The JDBC producer configuration should look like below screen shot.

 

 

 

A
Rank

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.

​​​​

 

Bikram
Rank
Userlevel 5
Badge +1

@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 

 

Bikram
Rank
Userlevel 5
Badge +1

@akshayp2 

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

 

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

A
Rank

@Rishi Below is the screenshot for the connection string

 

JDBC destination configuration

 

schema c##super is having dba privileges. 

A
Rank

@Bikram Its worked. case sensitivity was the problem.


@Bikram @Rishi Thank you for your response.

Bikram
Rank
Userlevel 5
Badge +1

@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.

Bikram
Rank
Userlevel 5
Badge +1

@akshayp2 

 

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

Reply


Terms & Conditions