(int fsize, boolean scrollable)
| 129 | } // end of JdbcConnect |
| 130 | |
| 131 | protected Statement GetStmt(int fsize, boolean scrollable) throws SQLException, Exception { |
| 132 | Statement stmt = null; |
| 133 | |
| 134 | if (scrollable) |
| 135 | stmt = conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE, java.sql.ResultSet.CONCUR_READ_ONLY); |
| 136 | else |
| 137 | stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY); |
| 138 | |
| 139 | if (DEBUG) |
| 140 | System.out.println("Statement type = " + stmt.getResultSetType() |
| 141 | + " concurrency = " + stmt.getResultSetConcurrency()); |
| 142 | |
| 143 | if (DEBUG) // Get the fetch size of a statement |
| 144 | System.out.println("Default fetch size = " + stmt.getFetchSize()); |
| 145 | |
| 146 | if (fsize != 0) { |
| 147 | // Set the fetch size |
| 148 | stmt.setFetchSize(fsize); |
| 149 | |
| 150 | if (DEBUG) |
| 151 | System.out.println("New fetch size = " + stmt.getFetchSize()); |
| 152 | |
| 153 | } // endif fsize |
| 154 | |
| 155 | return stmt; |
| 156 | } // end of GetStmt |
| 157 | |
| 158 | |
| 159 | public int CreatePrepStmt(String sql) { |
no outgoing calls
no test coverage detected