Hi, I am getting a ORA-00942: table or view does not exist when I query using dbutils api with 2 parameters. My enviroment si WAS 8.5.5 and oracle db 11g
I am using dbutils1.6 to make db calls. The problem occurs if I send two query parameters like SELECT * FROM DIGITAL_CERTIFICATE_CACHE WHERE CERT_SUBJECT_NAME=? AND CERT_STATUS=? Parameters: [70-B3-D5-1F-30-4E-DF-20, I] . If I send only one SELECT * FROM DIGITAL_CERTIFICATE_CACHE WHERE CERT_SUBJECT_NAME=? Parameters: [70-B3-D5-1F-30-4E-DF-20] then query returns and application is working. My dbutils code is as follows QueryRunner run = new QueryRunner(${DataSource}); // getting Query from propertues file to fetchBySubject String sqlquery = PropertyFileUtil .getPropertyValue("fetchbysubject.sql"); [fetchbysubject.sql = SELECT * FROM DIGITAL_CERTIFICATE_CACHE WHERE CERT_SUBJECT_NAME=? AND CERT_STATUS=?] // preparing instance for Custom ResultSetHandler to process // ResultSet ResultSetHandler<List<DigitalCertificateCache>> handler = new DPIServicesDAOResultSetHandler(); results = run.query(sqlquery, handler, new Object[] { subjectname, "I" }); Can somebody please point the problem.