Mysql executeQuery...

From:

"Event Horizon" <event@porvoo24.com>

Newsgroups:

comp.lang.java.programmer

Date:

Mon, 02 Jul 2007 13:47:34 GMT

Message-ID:

<Wl7ii.160$9Q1.3@read3.inet.fi>

I'm stuck with my code :(
I changing from Interbase to mysql but for some reason I cannot make
them work if resultsets should be Map[]

This works with
Interbase:#######################################################

private Map[] information(int OrderID, int nro) throws Exception
{
  String queryFile = "SELECT ORDER_DET.REMOTENAME, ORDER_DET.PID,
ORDER_DET.QTY, ORDER_DET.VARIABLELENGTH FROM ORDER_DET WHERE
(ORDER_DET.ORDID = ?) AND (ORDER_DET.RNBR = ?)";
  String[] argsFile = new String[2];
  argsFile[0] = OrderID + "";
  argsFile[1] = nro + "";
  Map[] retmapFile = null;
  try
  {
   retmapFile = connection.executeQuery(queryFile, argsFile);
  }
  catch (Exception e)
  {
   System.out.println ("Failed to query information ...");
   e.printStackTrace ();
  }
  return retmapFile;
}

This is what I'm
trying#########################################################

private Map[] information(int OrderID, int nro) throws Exception
{
  String queryFile = "SELECT ORDER_DET.REMOTENAME, ORDER_DET.PID,
ORDER_DET.QTY, ORDER_DET.VARIABLELENGTH FROM ORDER_DET WHERE
(ORDER_DET.ORDID = ?) AND (ORDER_DET.RNBR = ?)";
  String[] argsFile = new String[2];
  argsFile[0] = OrderID + "";
  argsFile[1] = nro + "";
  Map[] retmapFile = null;
  try
  {
   Class.forName(DRIVER).newInstance();
   Connection conn=DriverManager.getConnection(URL);
   PreparedStatement smt = conn.prepareStatement(queryFile, argsFile);
   retmapFile = smt.executeQuery(); }
  catch (Exception e)
  {
   System.out.println ("Failed to query information ...");
   e.printStackTrace ();
  }
  return retmapFile;
}

Error:
found : java.sql.ResultSet
required: java.util.Map[]
                        retmapFile = smt.executeQuery();

java.util.Map is imported. What I'm doing wrong?

-Event