JDBCPreparedStatement.java revision 417deb1db112103aff04231b6ca79772ff7d3a21
1417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughespackage SQLite.JDBC2y; 2417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 3417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughesimport java.sql.*; 4417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughesimport java.math.BigDecimal; 5417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughesimport java.util.*; 6417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 7417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughesclass BatchArg { 8417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes String arg; 9417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes boolean blob; 10417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 11417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes BatchArg(String arg, boolean blob) { 12417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (arg == null) { 13417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes this.arg = null; 14417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 15417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes this.arg = new String(arg); 16417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 17417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes this.blob = blob; 18417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 19417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes} 20417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 21417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughespublic class JDBCPreparedStatement extends JDBCStatement 22417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes implements java.sql.PreparedStatement { 23417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 24417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes private String sql; 25417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes private String args[]; 26417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes private boolean blobs[]; 27417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes private ArrayList<BatchArg> batch; 28417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes private static final boolean nullrepl = 29417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes SQLite.Database.version().compareTo("2.5.0") < 0; 30417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 31417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public JDBCPreparedStatement(JDBCConnection conn, String sql) { 32417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes super(conn); 33417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes this.args = null; 34417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes this.blobs = null; 35417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes this.batch = null; 36417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes this.sql = fixup(sql); 37417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 38417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 39417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes private String fixup(String sql) { 40417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes StringBuffer sb = new StringBuffer(); 41417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes boolean inq = false; 42417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes int nparm = 0; 43417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes for (int i = 0; i < sql.length(); i++) { 44417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes char c = sql.charAt(i); 45417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (c == '\'') { 46417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (inq) { 47417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes char nextChar = 0; 48417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if(i + 1 < sql.length()) { 49417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes nextChar = sql.charAt(i + 1); 50417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 51417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (nextChar == '\'') { 52417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes sb.append(c); 53417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes sb.append(nextChar); 54417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes i++; 55417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 56417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes inq = false; 57417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes sb.append(c); 58417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 59417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 60417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes inq = true; 61417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes sb.append(c); 62417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 63417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else if (c == '?') { 64417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (inq) { 65417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes sb.append(c); 66417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 67417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes ++nparm; 68417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes sb.append(nullrepl ? "'%q'" : "%Q"); 69417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 70417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else if (c == ';') { 71417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (!inq) { 72417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes break; 73417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 74417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes sb.append(c); 75417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else if (c == '%') { 76417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes sb.append("%%"); 77417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 78417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes sb.append(c); 79417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 80417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 81417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args = new String[nparm]; 82417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs = new boolean[nparm]; 83417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes try { 84417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes clearParameters(); 85417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } catch (SQLException e) { 86417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 87417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes return sb.toString(); 88417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 89417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 90417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes private String fixup2(String sql) { 91417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (!conn.db.is3()) { 92417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes return sql; 93417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 94417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes StringBuffer sb = new StringBuffer(); 95417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes int parm = -1; 96417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes for (int i = 0; i < sql.length(); i++) { 97417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes char c = sql.charAt(i); 98417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (c == '%') { 99417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes sb.append(c); 100417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes ++i; 101417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes c = sql.charAt(i); 102417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (c == 'Q') { 103417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes parm++; 104417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (blobs[parm]) { 105417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes c = 's'; 106417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 107417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 108417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 109417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes sb.append(c); 110417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 111417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes return sb.toString(); 112417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 113417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 114417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public ResultSet executeQuery() throws SQLException { 115417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes return executeQuery(fixup2(sql), args, false); 116417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 117417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 118417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public int executeUpdate() throws SQLException { 119417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes executeQuery(fixup2(sql), args, true); 120417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes return updcnt; 121417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 122417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 123417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setNull(int parameterIndex, int sqlType) throws SQLException { 124417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 125417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 126417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 127417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = nullrepl ? "" : null; 128417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 129417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 130417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 131417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setBoolean(int parameterIndex, boolean x) 132417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 133417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 134417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 135417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 136417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = x ? "1" : "0"; 137417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 138417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 139417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 140417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setByte(int parameterIndex, byte x) throws SQLException { 141417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 142417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 143417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 144417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = "" + x; 145417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 146417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 147417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 148417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setShort(int parameterIndex, short x) throws SQLException { 149417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 150417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 151417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 152417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = "" + x; 153417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 154417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 155417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 156417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setInt(int parameterIndex, int x) throws SQLException { 157417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 158417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 159417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 160417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = "" + x; 161417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 162417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 163417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 164417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setLong(int parameterIndex, long x) throws SQLException { 165417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 166417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 167417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 168417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = "" + x; 169417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 170417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 171417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 172417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setFloat(int parameterIndex, float x) throws SQLException { 173417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 174417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 175417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 176417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = "" + x; 177417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 178417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 179417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 180417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setDouble(int parameterIndex, double x) throws SQLException { 181417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 182417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 183417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 184417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = "" + x; 185417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 186417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 187417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 188417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setBigDecimal(int parameterIndex, BigDecimal x) 189417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 190417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 191417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 192417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 193417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (x == null) { 194417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = nullrepl ? "" : null; 195417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 196417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = "" + x; 197417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 198417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 199417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 200417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 201417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setString(int parameterIndex, String x) throws SQLException { 202417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 203417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 204417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 205417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (x == null) { 206417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = nullrepl ? "" : null; 207417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 208417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = x; 209417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 210417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 211417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 212417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 213417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setBytes(int parameterIndex, byte x[]) throws SQLException { 214417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 215417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 216417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 217417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 218417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (x == null) { 219417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = nullrepl ? "" : null; 220417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 221417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (conn.db.is3()) { 222417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = SQLite.StringEncoder.encodeX(x); 223417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = true; 224417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 225417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = SQLite.StringEncoder.encode(x); 226417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 227417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 228417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 229417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 230417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setDate(int parameterIndex, java.sql.Date x) 231417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 232417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 233417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 234417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 235417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (x == null) { 236417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = nullrepl ? "" : null; 237417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 238417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = x.toString(); 239417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 240417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 241417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 242417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 243417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setTime(int parameterIndex, java.sql.Time x) 244417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 245417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 246417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 247417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 248417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (x == null) { 249417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = nullrepl ? "" : null; 250417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 251417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = x.toString(); 252417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 253417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 254417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 255417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 256417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setTimestamp(int parameterIndex, java.sql.Timestamp x) 257417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 258417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 259417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 260417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 261417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (x == null) { 262417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = nullrepl ? "" : null; 263417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 264417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = x.toString(); 265417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 266417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 267417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 268417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 269417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setAsciiStream(int parameterIndex, java.io.InputStream x, 270417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes int length) throws SQLException { 271417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 272417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 273417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 274417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes @Deprecated 275417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setUnicodeStream(int parameterIndex, java.io.InputStream x, 276417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes int length) throws SQLException { 277417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 278417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 279417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 280417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setBinaryStream(int parameterIndex, java.io.InputStream x, 281417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes int length) throws SQLException { 282417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 283417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 284417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 285417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void clearParameters() throws SQLException { 286417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes for (int i = 0; i < args.length; i++) { 287417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[i] = nullrepl ? "" : null; 288417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[i] = false; 289417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 290417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 291417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 292417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setObject(int parameterIndex, Object x, int targetSqlType, 293417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes int scale) throws SQLException { 294417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 295417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 296417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 297417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (x == null) { 298417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = nullrepl ? "" : null; 299417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 300417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (x instanceof byte[]) { 301417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes byte[] bx = (byte[]) x; 302417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (conn.db.is3()) { 303417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = 304417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes SQLite.StringEncoder.encodeX(bx); 305417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = true; 306417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes return; 307417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 308417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = SQLite.StringEncoder.encode(bx); 309417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 310417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = x.toString(); 311417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 312417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 313417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 314417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 315417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 316417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setObject(int parameterIndex, Object x, int targetSqlType) 317417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 318417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 319417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 320417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 321417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (x == null) { 322417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = nullrepl ? "" : null; 323417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 324417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (x instanceof byte[]) { 325417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes byte[] bx = (byte[]) x; 326417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (conn.db.is3()) { 327417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = 328417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes SQLite.StringEncoder.encodeX(bx); 329417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = true; 330417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes return; 331417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 332417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = SQLite.StringEncoder.encode(bx); 333417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 334417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = x.toString(); 335417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 336417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 337417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 338417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 339417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 340417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setObject(int parameterIndex, Object x) throws SQLException { 341417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (parameterIndex < 1 || parameterIndex > args.length) { 342417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("bad parameter index"); 343417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 344417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (x == null) { 345417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = nullrepl ? "" : null; 346417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 347417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (x instanceof byte[]) { 348417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes byte[] bx = (byte[]) x; 349417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (conn.db.is3()) { 350417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = 351417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes SQLite.StringEncoder.encodeX(bx); 352417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = true; 353417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes return; 354417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 355417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = SQLite.StringEncoder.encode(bx); 356417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } else { 357417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[parameterIndex - 1] = x.toString(); 358417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 359417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 360417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[parameterIndex - 1] = false; 361417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 362417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 363417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public boolean execute() throws SQLException { 364417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes return executeQuery(fixup2(sql), args, false) != null; 365417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 366417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 367417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void addBatch() throws SQLException { 368417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (batch == null) { 369417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes batch = new ArrayList<BatchArg>(args.length); 370417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 371417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes for (int i = 0; i < args.length; i++) { 372417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes batch.add(new BatchArg(args[i], blobs[i])); 373417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 374417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 375417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 376417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public int[] executeBatch() throws SQLException { 377417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (batch == null) { 378417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes return new int[0]; 379417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 380417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes int[] ret = new int[batch.size() / args.length]; 381417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes for (int i = 0; i < ret.length; i++) { 382417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes ret[i] = EXECUTE_FAILED; 383417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 384417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes int errs = 0; 385417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes int index = 0; 386417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes for (int i = 0; i < ret.length; i++) { 387417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes for (int k = 0; k < args.length; k++) { 388417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes BatchArg b = (BatchArg) batch.get(index++); 389417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 390417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes args[i] = b.arg; 391417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes blobs[i] = b.blob; 392417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 393417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes try { 394417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes ret[i] = executeUpdate(); 395417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } catch (SQLException e) { 396417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes ++errs; 397417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 398417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 399417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (errs > 0) { 400417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new BatchUpdateException("batch failed", ret); 401417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 402417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes return ret; 403417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 404417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 405417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void clearBatch() throws SQLException { 406417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes if (batch != null) { 407417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes batch.clear(); 408417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes batch = null; 409417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 410417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 411417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 412417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setCharacterStream(int parameterIndex, 413417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes java.io.Reader reader, 414417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes int length) throws SQLException { 415417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 416417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 417417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 418417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setRef(int i, Ref x) throws SQLException { 419417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 420417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 421417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 422417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setBlob(int i, Blob x) throws SQLException { 423417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 424417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 425417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 426417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setClob(int i, Clob x) throws SQLException { 427417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 428417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 429417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 430417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setArray(int i, Array x) throws SQLException { 431417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 432417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 433417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 434417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public ResultSetMetaData getMetaData() throws SQLException { 435417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes return rs.getMetaData(); 436417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 437417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 438417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setDate(int parameterIndex, java.sql.Date x, Calendar cal) 439417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 440417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes setDate(parameterIndex, x); 441417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 442417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 443417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setTime(int parameterIndex, java.sql.Time x, Calendar cal) 444417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 445417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes setTime(parameterIndex, x); 446417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 447417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 448417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setTimestamp(int parameterIndex, java.sql.Timestamp x, 449417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes Calendar cal) throws SQLException { 450417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes setTimestamp(parameterIndex, x); 451417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 452417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 453417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setNull(int parameterIndex, int sqlType, String typeName) 454417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 455417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes setNull(parameterIndex, sqlType); 456417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 457417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 458417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public ParameterMetaData getParameterMetaData() throws SQLException { 459417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 460417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 461417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 462417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void registerOutputParameter(String parameterName, int sqlType) 463417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 464417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 465417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 466417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 467417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void registerOutputParameter(String parameterName, int sqlType, 468417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes int scale) 469417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 470417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 471417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 472417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 473417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void registerOutputParameter(String parameterName, int sqlType, 474417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes String typeName) 475417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 476417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 477417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 478417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 479417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public java.net.URL getURL(int parameterIndex) throws SQLException { 480417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 481417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 482417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 483417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setURL(int parameterIndex, java.net.URL url) 484417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 485417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 486417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 487417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 488417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setNull(String parameterName, int sqlType) 489417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 490417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 491417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 492417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 493417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setBoolean(String parameterName, boolean val) 494417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 495417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 496417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 497417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 498417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setByte(String parameterName, byte val) 499417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 500417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 501417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 502417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 503417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setShort(String parameterName, short val) 504417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 505417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 506417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 507417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 508417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setInt(String parameterName, int val) 509417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 510417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 511417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 512417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 513417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setLong(String parameterName, long val) 514417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 515417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 516417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 517417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 518417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setFloat(String parameterName, float val) 519417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 520417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 521417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 522417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 523417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setDouble(String parameterName, double val) 524417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 525417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 526417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 527417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 528417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setBigDecimal(String parameterName, BigDecimal val) 529417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 530417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 531417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 532417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 533417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setString(String parameterName, String val) 534417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 535417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 536417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 537417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 538417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setBytes(String parameterName, byte val[]) 539417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 540417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 541417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 542417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 543417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setDate(String parameterName, java.sql.Date val) 544417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 545417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 546417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 547417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 548417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setTime(String parameterName, java.sql.Time val) 549417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 550417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 551417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 552417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 553417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setTimestamp(String parameterName, java.sql.Timestamp val) 554417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 555417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 556417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 557417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 558417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setAsciiStream(String parameterName, 559417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes java.io.InputStream s, int length) 560417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 561417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 562417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 563417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 564417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setBinaryStream(String parameterName, 565417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes java.io.InputStream s, int length) 566417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 567417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 568417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 569417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 570417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setObject(String parameterName, Object val, int targetSqlType, 571417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes int scale) 572417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 573417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 574417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 575417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 576417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setObject(String parameterName, Object val, int targetSqlType) 577417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 578417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 579417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 580417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 581417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setObject(String parameterName, Object val) 582417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 583417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 584417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 585417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 586417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setCharacterStream(String parameterName, 587417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes java.io.Reader r, int length) 588417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 589417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 590417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 591417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 592417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setDate(String parameterName, java.sql.Date val, 593417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes Calendar cal) 594417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 595417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 596417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 597417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 598417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setTime(String parameterName, java.sql.Time val, 599417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes Calendar cal) 600417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 601417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 602417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 603417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 604417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setTimestamp(String parameterName, java.sql.Timestamp val, 605417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes Calendar cal) 606417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 607417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 608417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 609417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 610417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public void setNull(String parameterName, int sqlType, String typeName) 611417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 612417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 613417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 614417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 615417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public String getString(String parameterName) throws SQLException { 616417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 617417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 618417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 619417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public boolean getBoolean(String parameterName) throws SQLException { 620417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 621417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 622417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 623417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public byte getByte(String parameterName) throws SQLException { 624417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 625417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 626417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 627417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public short getShort(String parameterName) throws SQLException { 628417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 629417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 630417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 631417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public int getInt(String parameterName) throws SQLException { 632417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 633417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 634417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 635417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public long getLong(String parameterName) throws SQLException { 636417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 637417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 638417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 639417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public float getFloat(String parameterName) throws SQLException { 640417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 641417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 642417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 643417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public double getDouble(String parameterName) throws SQLException { 644417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 645417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 646417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 647417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public byte[] getBytes(String parameterName) throws SQLException { 648417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 649417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 650417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 651417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public java.sql.Date getDate(String parameterName) throws SQLException { 652417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 653417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 654417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 655417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public java.sql.Time getTime(String parameterName) throws SQLException { 656417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 657417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 658417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 659417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public java.sql.Timestamp getTimestamp(String parameterName) 660417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 661417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 662417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 663417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 664417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public Object getObject(String parameterName) throws SQLException { 665417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 666417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 667417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 668417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public Object getObject(int parameterIndex) throws SQLException { 669417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 670417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 671417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 672417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public BigDecimal getBigDecimal(String parameterName) throws SQLException { 673417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 674417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 675417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 676417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public Object getObject(String parameterName, Map map) 677417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 678417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 679417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 680417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 681417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public Object getObject(int parameterIndex, Map map) 682417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 683417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 684417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 685417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 686417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public Ref getRef(int parameterIndex) throws SQLException { 687417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 688417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 689417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 690417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public Ref getRef(String parameterName) throws SQLException { 691417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 692417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 693417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 694417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public Blob getBlob(String parameterName) throws SQLException { 695417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 696417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 697417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 698417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public Blob getBlob(int parameterIndex) throws SQLException { 699417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 700417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 701417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 702417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public Clob getClob(String parameterName) throws SQLException { 703417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 704417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 705417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 706417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public Clob getClob(int parameterIndex) throws SQLException { 707417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 708417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 709417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 710417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public Array getArray(String parameterName) throws SQLException { 711417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 712417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 713417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 714417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public Array getArray(int parameterIndex) throws SQLException { 715417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 716417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 717417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 718417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public java.sql.Date getDate(String parameterName, Calendar cal) 719417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 720417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 721417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 722417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 723417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public java.sql.Date getDate(int parameterIndex, Calendar cal) 724417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 725417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 726417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 727417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 728417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public java.sql.Time getTime(String parameterName, Calendar cal) 729417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 730417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 731417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 732417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 733417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public java.sql.Time getTime(int parameterIndex, Calendar cal) 734417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 735417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 736417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 737417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 738417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public java.sql.Timestamp getTimestamp(String parameterName, Calendar cal) 739417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 740417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 741417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 742417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 743417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public java.sql.Timestamp getTimestamp(int parameterIndex, Calendar cal) 744417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throws SQLException { 745417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 746417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 747417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 748417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes public java.net.URL getURL(String parameterName) throws SQLException { 749417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes throw new SQLException("not supported"); 750417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes } 751417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes 752417deb1db112103aff04231b6ca79772ff7d3a21Elliott Hughes} 753