$$$$$$How many is enough?$$$$$
Hello all,
Now that I've got your attention with the $$$ how about we get down to the fun part :-)
Why is it that I'm getting the following exception?
More importantly (I think)is it because I've open and Not properllly close my n number of ResultSet objects?
Any observations/hints/suggggestttion for the fix are welllllcome :-)
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Cannot open any
more tables.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:2494)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:314)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:2
29)
at sun.jdbc.odbc.JdbcOdbcResultSet.calculateRowCount(JdbcOdbcResultSet.j
ava:6043)
at sun.jdbc.odbc.JdbcOdbcResultSet.initialize(JdbcOdbcResultSet.java:150
)
at sun.jdbc.odbc.JdbcOdbcStatement.getResultSet(JdbcOdbcStatement.java:4
00)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:2
30)
Thnk U
