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?
