how to import data from Quality Center 9.2 using Java.

Hello
I am getting Class Cast Exception At line no 24(command = (Command) Con.getCommand();)

Con.getCommand(); this statement returns an object of IDispatch and when i am Type Casting to Command type its throwing me Class Cast Exception.

Hope you understand my problem. Looking forward a solution for type casting the IDispatch Object to Command object.

what makes you think its a Command instance?
try the following to see what class it actually is

                  System.out.println(Con.getCommand().getClass());
                  command = (Command) Con.getCommand();

Hello
I want to connect to Quality Center 9.2 and want to import data from it using java.
I am able to do this using VB. I have attached VB Code snippet.
In this VB Code  i have declared a variable (Com) of TDAPIOLELib.Command type and had set this varible to the QCConnection.Command. Now using this Com i have imported data from Quality Center.

Now the same functionality i want to implement with JAVA/JSP.

We are able to conncect to Quality Center using java by creating the jars with the help of jacoZoom software.

import java.lang.String.*;
import jcw.TDAPIOLELib.*;
import com.inzoom.*;
import com.inzoom.comjni.*;
import java.sql.*;
 
public class Hello {
      public static void main(String[] args)throws ComJniException
 
      {
      
            jcw.TDAPIOLELib.TDConnection Con;
            jcw.TDAPIOLELib.TestSetFactory TestFac;
            jcw.TDAPIOLELib.Command command;
            ResultSet rs;
            
        
            Con = new jcw.TDAPIOLELib.TDConnection();
               Con.initConnection("http://sever name/qcbin");
               Con.login("username", "password");
               Con.connect("Domain", "project");
               System.out.println("Connected");

Till this code i am ok... i m able to connect it with quality center.
Next step is we need to import the data with the use of a query.

The VB code is
Set Com = QCConnection.Command
Com.CommandText  = "Sql query to get data"

The same code now i want to write in Java
So that i can pass a query the retrive the required details.

The Java code i have written
command = (Command) Con.getCommand();
 command.setCommandText(" SQl Command to get data ");
  rs= (ResultSet) command.execute();

Its getting complied properly but when i am trying to retrieve the data its throwing class Cast Exception. as con.getCommand() is returning an object of IDispatch Class which is not getting type casted to Command Class.

How to use IDispatch Object in getting the data from Quality center.
Is there any other way to retrive data from Quality Center.
How to pass query to retrieve data from quality Center.

Dim QCConnection As TDAPIOLELib.TDConnection
Dim Com As TDAPIOLELib.Command
Dim rs As Resultset
 
Set QCConnection = CreateObject("TDApiOle80.TDConnection")
QCConnection.InitConnectionEx "http://server/qcbin"
QCConnection.login "username", "password"
QCConnection.Connect "Domain", "Project"
msgbox("Connected")
 
Set Com = QCConnection.Command
Com.CommandText  = "Sql query to get data"
Set rs = Com.Execute
                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:

you haven't answered my earlier question

Hello
Con.getCommand().getClass() is returning me  class com.inzoom.comjni.jcw.IDispatchJCW

Please help me with my pervoius question..

Its returning an instance of IDispatchJCW, not a Command instance.
you should be casting to that instead

The Java code i have written
command = (Command) Con.getCommand();
 command.setCommandText(" SQl Command to get data ");
  rs= (ResultSet) command.execute();

Its getting complied properly but when i am trying to retrieve the data its throwing class Cast Exception. as con.getCommand() is returning an object of IDispatch Class which is not getting type casted to Command Class.

Your are correct . But is there any way to pass a  query to retrieve data from Quality Center... Is there any other way to retrieve data from Quality Center by using java.