Hello Amol, can you see the query being sent to your database in the query log? Maybe it is different from what you're expecting.
Benedikt 2015-11-17 7:23 GMT+01:00 Amol Kulkarni <[email protected]>: > Yes it does work when done through sql developer command line , also tried > from sql plus it works. The problem occurs only through dbutils. > > On Tue, Nov 17, 2015 at 12:33 AM, Benedikt Ritter <[email protected]> > wrote: > > > Hello Amol, > > > > 2015-11-10 21:03 GMT+01:00 Amol Kulkarni <[email protected]>: > > > > > 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. > > > > > > > Does it work, when you run the query via the command line? > > > > Regards, > > Benedikt > > > > > > -- > > http://people.apache.org/~britter/ > > http://www.systemoutprintln.de/ > > http://twitter.com/BenediktRitter > > http://github.com/britter > > > -- http://people.apache.org/~britter/ http://www.systemoutprintln.de/ http://twitter.com/BenediktRitter http://github.com/britter
