Saji, Could you give the name of the lab, not a link to it (because it goes simply to the home web page).
Michèle Garoche On Nov 2, 7:01 am, Saji <jjk.s...@gmail.com> wrote: > Hi > I am going through the work assignment /tutorials > athttp://www.javapassion.com/portal/java-ee-programming-basics-i-with-p... > 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.j > ava: > 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
