We are using Clarity Version 15.2. I have Jaspersoft Studio installed on my local machine. We have got one new database user ID created for technical team in Clarity Production Database, which is different from the user ID used in database connection in CSA. I'm trying to use this new user ID to create a New Data Adapter in Jaspersoft Studio. My purpose is to publish the reports from Studio to Production jaspersoft Reports server.
For New Data Adapter set up, I'm using JDBC Driver: 'tibcosoftware.jdbc.oracle.OracleDriver'. After entering the hostname, port number, SID, username and password, I get this error message:
Caused by: java.sql.SQLInvalidAuthorizationSpecException: [TibcoSoftwareInc][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied
Whereas, the same user ID and Password works fine with Oracle SQL Developer. So, the problem is not with the username and password.
In some online help, I came to know that one of the possibilities is because of the old JDBC driver and needs a proper driver to use with Studio. If this is the case, can you please suggest me which files to change and where?
Else if this is not the issue, can you help me create the Data Adapter successfully to publish the reports?