How to connect to a database with all privileges as in the database with talend 7.1.1
I am trying to insert some data into an oracle database using talend 7.1.1. I keep having RA-16000 error (base de données ouverte pour accès en lecture seule) upon insert, this error messages indicated the job is connected to the database in a read only mode. I am able to connect to the same database with same credentials using TOAD oracle client and add, update and delete data from this same table.
So my question is how do I connect to the database with the privileges as assigned in the database? Or am I supposed to reconfigure this version of Talend before running the job?
Could you please share a screenshot of the Oracle connection component after masking the server name, name and password?
I am interested to know whether you are adding any additional parameters in your connection.
Also could you please ask DBA to monitor the DB from DBA tools when Talend is making a connection. In ideal scenario, it should work with read-write mode.
Find attached the database configuration screen together with a test connection result. I don't really know why I can't connect to the database with a write privilege as assigned by the DBA.
Another information I think could be vital in resolving this issue is that I am not an administrator on my desktop. I can't install applications by myself. There are a couple of thinks that I am not able to do on the company's desktop I am using but I am able to on my laptop. For example, I cannot use the tSendMail component to mails using my gmail's smtp credentials, passing parameters from a parent(from a flow) to a child job on my PC, but I can on my laptop.
This information is interesting. I believe all the jars needed for Oracle components are not available in your laptop. Could you please try to connect to Oracle database through Talend from your laptop?
When you are using the Oracle component for first time, it will show whether all the jars are present with a orange label at the top of component tab.
Since you are able to connect the database from SQL Assistant from same machine, we can rule out firewall related issues.
