AnsweredAssumed Answered

JDBC query "where" doesnt work with introscope db ?

Question asked by pisces7 on Nov 7, 2012
Latest reply on Nov 7, 2012 by Guenter_Grossberger
Hello

I am using jdbc to query introscope db to get data.
DriverManager.registerDriver(new com.wily.introscope.jdbc.IntroscopeDriver());
con = DriverManager.getConnection("jdbc:introscope:net//project@hpc-wily-aus-dev-01:9001 ");
On firing select * from metric_data I am able to get data but using where clause fails select * from metric_data where Max=50

I am getting this exception on using where clause :

java.sql.SQLException: An error occurred executing this query : select * from metric_data where Max in (50)
at com.wily.introscope.server.beans.jdbc.Parser.execute(Parser.java:90)
at com.wily.introscope.server.beans.jdbc.JDBCDataBean.executeQuery(JDBCDataBean.java:110)
at com.wily.introscope.server.beans.jdbc.JDBCDataBean.executeQuery(JDBCDataBean.java:104)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.wily.isengard.messageprimitives.MethodCallUtilities.callInterface(MethodCallUtilities.java:75)
at com.wily.isengard.messageprimitives.MethodCallUtilities.callInterface(MethodCallUtilities.java:29)
at com.wily.isengard.messageprimitives.service.MessageService.attemptMethodCall(MessageService.java:182)
at com.wily.isengard.messageprimitives.service.MessageService.handleMethodCallMessage(MessageService.java:134)
at com.wily.isengard.messageprimitives.service.MessageService.receiveMessage(MessageService.java:160)
at com.wily.isengard.postoffice.Mailbox.handleMessage(Mailbox.java:252)
at com.wily.isengard.postoffice.PostOffice.deliverInternal(PostOffice.java:450)
at com.wily.isengard.postoffice.PostOffice.access$1(PostOffice.java:422)
at com.wily.isengard.postoffice.PostOffice$DeliveryItem.run(PostOffice.java:726)
at com.wily.EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:728)
at java.lang.Thread.run(Unknown Source)


Could you please explain how can we correct this.

A quick reply would really be appreciated !

Thanks,
Aman

Outcomes