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
