Hi I am going through the work assignment /tutorials at http://www.javapassion.com/portal/java-ee-programming-basics-i-with-passion/java-ee-programming-with-passion#JDBC When I run "GetParamMetaData.java" I am getting this error
java.sql.SQLException: Parameter metadata not available for the given statement at com.mysql.jdbc.SQLError.createSQLException(SQLError.java: 1075) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java: 989) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java: 984) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java: 929) at com.mysql.jdbc.MysqlParameterMetadata.checkAvailable(MysqlParameterMetadata.java: 72) at com.mysql.jdbc.MysqlParameterMetadata.getPrecision(MysqlParameterMetadata.java: 97) at GetParamMetaData.main(GetParamMetaData.java:45) BUILD SUCCESSFUL (total time: 1 second) my MSQL tables has the following data mysql> show tables; +------------------+ | Tables_in_jdbcdb | +------------------+ | COFFEES | | SUPPLIERS | +------------------+ 2 rows in set (0.07 sec) ############################################ mysql> select * from COFFEES; +--------------------+--------+-------+-------+-------+ | COF_NAME | SUP_ID | PRICE | SALES | TOTAL | +--------------------+--------+-------+-------+-------+ | Colombian | 101 | 7.99 | 0 | 0 | | French_Roast | 49 | 8.99 | 0 | 0 | | Espresso | 150 | 9.99 | 0 | 0 | | Colombian_Decaf | 101 | 8.99 | 0 | 0 | | French_Roast_Decaf | 49 | 9.99 | 0 | 0 | | Amaretto | 49 | 9.99 | 0 | 0 | | Hazelnut | 49 | 9.99 | 0 | 0 | | Amaretto_decaf | 49 | 10.99 | 0 | 0 | | Hazelnut_decaf | 49 | 10.99 | 0 | 0 | | Amaretto | 49 | 9.99 | 0 | 0 | | Hazelnut | 49 | 9.99 | 0 | 0 | | Amaretto_decaf | 49 | 10.99 | 0 | 0 | | Hazelnut_decaf | 49 | 10.99 | 0 | 0 | +--------------------+--------+-------+-------+-------+ 13 rows in set (0.00 sec) ##################### mysql> select * from SUPPLIERS; +--------+-----------------+------------------+--------------+------- +-------+ | SUP_ID | SUP_NAME | STREET | CITY | STATE | ZIP | +--------+-----------------+------------------+--------------+------- +-------+ | 49 | Superior Coffee | 1 Party Place | Mendocino | CA | 95460 | | 101 | Acme, Inc. | 99 Market Street | Groundsville | CA | 95199 | | 150 | The High Ground | 100 Coffee Lane | Meadows | CA | 93966 | +--------+-----------------+------------------+--------------+------- +-------+ 3 rows in set (0.04 sec) -- You received this message because you are subscribed to the Google Groups "Java EE (J2EE) Programming with Passion!" group. To post to this group, send email to java-ee-j2ee-programming-with-passion@googlegroups.com To unsubscribe from this group, send email to java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en