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 <brit...@apache.org>
wrote:
> Hello Amol,
>
> 2015-11-10 21:03 GMT+01:00 Amol Kulkarni <amolkul...@gmail.com>:
>
> > 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
>
