Melissa,
It may not be a solution to your problem but from experience I can say that
Win2000 is very temperamental as far ODBC/JDBC goes. I had troubles with a
very straightforward ODBC link which used to run on on NT and 95. With Java,
the same application sometimes work with JDBC/ODBC bridge and sometimes with
Thin JDBC driver. Move everything to NT and it's fine.
If you can try a different client.
Regds,
Jarek Skreta
> -----Original Message-----
> From: Melissa Matthews [mailto:[EMAIL PROTECTED]]
> Sent: 26 October 2000 14:47
> To: '[EMAIL PROTECTED]'
> Subject: JDBC/MySQL newbie problem with execute Statement
>
>
> This is my first experience with JDBC. I am using the mm.mysql-2.0.1
> driver. (OS is Windows 2000, Tomcat is a 3.2 beta version.) This
> should be
> pretty simple, but it hangs when I call executeQuery.
> I have put some prints in and I know I get past createStatement(), but no
> further. The query works fine when I just type it in a MySQL
> command line.
>
> String query = "SELECT ItemCode, ItemDesc, ListPrice,
> onHand, SupplierName FROM px_products WHERE "
> + where;
> Statement stmt = con.createStatement();
>
> ===> ResultSet rs = stmt.executeQuery(query);
>
> ResultSetMetaData rsmd = rs.getMetaData();
> int columnCount = rsmd.getColumnCount();
>
>
> The last thing it prints in the tomcat window after the create
> statement is:
> JspCompiler: extract class name and version.
>
> I have tried a few versions of the driver, but nothing seems to work. Any
> Suggestions?
>
>
