Re: [dbutils] Issue when using more than 1 parameter in query

Thank you all for your response . as we are unable to determine problem, we have moved back to plain jdbc for this. On Wed, Nov 18, 2015 at 5:03 PM, Amol Kulkarni wrote: > I think so, the problem is with dbutils to query this particular table. If > there was something in

Re: [dbutils] Issue when using more than 1 parameter in query

There is an option to disable the use of the metadata command as some DBs (Oracle for example) don't implement it properly. See https://commons.apache.org/proper/commons-dbutils/apidocs/org/apache/commons/dbutils/QueryRunner.html#QueryRunner(javax.sql.DataSource,%20boolean) If that doesn't help,

Re: [dbutils] Issue when using more than 1 parameter in query

Hello Amol, 2015-11-17 9:07 GMT+01:00 Amol Kulkarni : > We tested this code with standalone app.The stmt.getParameterMetaData() > in QueryRunner.java is throwing error. We asked DBA , but he does not see > any query in logs coming. He is the debug. We add QueryRunner.java

Re: [dbutils] Issue when using more than 1 parameter in query

I think so, the problem is with dbutils to query this particular table. If there was something in debug logs to see why getParameterMetaData() is throwing error when used with dbutils , we could pinpoint the issue. On Wed, Nov 18, 2015 at 4:59 PM, Benedikt Ritter wrote: >

Re: [dbutils] Issue when using more than 1 parameter in query

We tested this code with standalone app.The stmt.getParameterMetaData() in QueryRunner.java is throwing error. We asked DBA , but he does not see any query in logs coming. He is the debug. We add QueryRunner.java in classpath so that we can debug / put some sys outs. query coming here is SELECT

Re: [dbutils] Issue when using more than 1 parameter in query

Hello Amol, 2015-11-10 21:03 GMT+01:00 Amol Kulkarni : > 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

Re: [dbutils] Issue when using more than 1 parameter in query

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 wrote: > Hello Amol, > > 2015-11-10 21:03 GMT+01:00 Amol Kulkarni

Re: [dbutils] Issue when using more than 1 parameter in query

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 : > Yes it does work when done through sql developer command line , also tried > from sql

[dbutils] Issue when using more than 1 parameter in query

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