Examples of java.sql.Connection.createArrayOf()

java.sql.Connection.createArrayOf()
Factory method for creating Array objects.
Note: When createArrayOf is used to create an array object that maps to a primitive data type, then it is implementation-defined whether the Array object is an array of that primitive data type or an array of Object.
Note: The JDBC driver is responsible for mapping the elements Object array to the default JDBC SQL type defined in java.sql.Types for the given class of Object. The default mapping is specified in Appendix B of the JDBC specification. If the resulting JDBC type is not the appropriate type for the given typeName then it is implementation defined whether an SQLException is thrown or the driver supports the resulting conversion. @param typeName the SQL name of the type the elements of the array map to. The typeName is adatabase-specific name which may be the name of a built-in type, a user-defined type or a standard SQL type supported by this database. This is the value returned by Array.getBaseTypeName @param elements the elements that populate the returned object @return an Array object whose elements map to the specified SQL type @throws SQLException if a database error occurs, the JDBC type is notappropriate for the typeName and the conversion is not supported, the typeName is null or this method is called on a closed connection @throws SQLFeatureNotSupportedException if the JDBC driver does not support this data type @since 1.6

            
            // create character array
            String[] charArr =  new String[2];
            charArr[0] = "a";
            charArr[1] = "b";
            array = conn.createArrayOf("CHAR", charArr);
            stmt.setArray(5, array);
            stmt.execute();
                
            conn.commit();
        } finally {

View Full Code Here

                if (spy)
                    spyLogger.debugf("%s [%s] createArrayOf(%s, %s)",
                            jndiName, Constants.SPY_LOGGER_PREFIX_CONNECTION,
                            typeName, Arrays.toString(elements));


                return c.createArrayOf(typeName, elements);
            } catch (Throwable t) {
                throw checkException(t);
            }
        } finally {
            unlock();

View Full Code Here

      } else {
        strArr[1] = "CEDF";
      }
             strArr[2] = "XYZWER";
             strArr[3] = "AB";
             Array array = conn.createArrayOf("VARCHAR", strArr);
             stmt.setArray(3, array);
             stmt.setString(4, B_VALUE);
             stmt.setInt(5, 1);
             stmt.setDate(6, date);
             stmt.setBigDecimal(7, null);

View Full Code Here

             stmt.setBigDecimal(7, null);
             // Need to support primitive
             Long[] longArr =  new Long[2];
             longArr[0] = 25l;
             longArr[1] = 36l;
             array = conn.createArrayOf("BIGINT", longArr);
             stmt.setArray(8, array);
             stmt.setNull(9, Types.INTEGER);
             // Need to support primitive
             Byte[] byteArr =  new Byte[2];
             byteArr[0] = 25;

View Full Code Here

             stmt.setNull(9, Types.INTEGER);
             // Need to support primitive
             Byte[] byteArr =  new Byte[2];
             byteArr[0] = 25;
             byteArr[1] = 36;
             array = conn.createArrayOf("TINYINT", byteArr);
             stmt.setArray(10, array);
             stmt.setShort(11, (short) 128);
             stmt.setFloat(12, 0.01f);
             // Need to support primitive
             Double[] doubleArr =  new Double[4];

View Full Code Here

             Double[] doubleArr =  new Double[4];
             doubleArr[0] = 25.343;
             doubleArr[1] = 36.763;
             doubleArr[2] = 37.56;
             doubleArr[3] = 386.63;
             array = conn.createArrayOf("DOUBLE", doubleArr);
             stmt.setArray(13, array);
             stmt.setFloat(14, 0.01f);
             stmt.setDouble(15, 0.0001);
             stmt.execute();

View Full Code Here

      String[] strArr = new String[4];
      strArr[0] = "ABC";
      strArr[1] = "CEDF";
      strArr[2] = "XYZWER";
      strArr[3] = "AB";
      Array array = conn.createArrayOf("VARCHAR", strArr);
      statement.setArray(2, array);
      ResultSet rs = statement.executeQuery();
      assertTrue(rs.next());
      // Need to support primitive
      Double[] doubleArr = new Double[4];

View Full Code Here

      Double[] doubleArr = new Double[4];
      doubleArr[0] = 25.343;
      doubleArr[1] = 36.763;
        doubleArr[2] = 37.56;
            doubleArr[3] = 386.63;
      array = conn.createArrayOf("DOUBLE", doubleArr);
      Array resultArray = rs.getArray(1);
      assertEquals(resultArray, array);
      assertEquals(rs.getString("B_string"), B_VALUE);
      assertTrue(Floats.compare(rs.getFloat(3), 0.01f) == 0);
      assertFalse(rs.next());

View Full Code Here

      String[] strArr = new String[4];
      strArr[0] = "ABC";
      strArr[1] = "CEDF";
      strArr[2] = "XYZWER";
      strArr[3] = "AB";
      Array array = conn.createArrayOf("VARCHAR", strArr);
      PhoenixArray resultArray = (PhoenixArray) rs.getArray(1);
      assertEquals(resultArray, array);
      assertFalse(rs.next());
    } finally {
      conn.close();

View Full Code Here

      ResultSet rs = statement.executeQuery();
      assertTrue(rs.next());
      // Need to support primitive
      Double[] doubleArr = new Double[1];
      doubleArr[0] = 36.763;
      conn.createArrayOf("DOUBLE", doubleArr);
      Double result =  rs.getDouble(1);
      assertEquals(doubleArr[0], result);
      assertFalse(rs.next());
    } finally {
      conn.close();

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.