java.sql.SQLXML Java Examples

/** Check that the "get" conversion table looks like Table B-5 in JDBC 4.1
 * specification */
@Test void testTableB6() {
  SqlType[] columns = {
      SqlType.TINYINT, SqlType.SMALLINT, SqlType.INTEGER, SqlType.BIGINT,
      SqlType.REAL, SqlType.FLOAT, SqlType.DOUBLE, SqlType.DECIMAL,
      SqlType.NUMERIC, SqlType.BIT, SqlType.BOOLEAN, SqlType.CHAR,
      SqlType.VARCHAR, SqlType.LONGVARCHAR, SqlType.BINARY, SqlType.VARBINARY,
      SqlType.LONGVARBINARY, SqlType.DATE, SqlType.TIME, SqlType.TIMESTAMP,
      SqlType.CLOB, SqlType.BLOB, SqlType.ARRAY, SqlType.REF,
      SqlType.DATALINK, SqlType.STRUCT, SqlType.JAVA_OBJECT, SqlType.ROWID,
      SqlType.NCHAR, SqlType.NVARCHAR, SqlType.LONGNVARCHAR, SqlType.NCLOB,
      SqlType.SQLXML
  };
  final PrintWriter out =
      CalciteSystemProperty.DEBUG.value()
          ? Util.printWriter(System.out)
          : new PrintWriter(new StringWriter());
  for (SqlType.Method row : SqlType.Method.values()) {
    out.print(pad(row.methodName));
    for (SqlType column : columns) {
      out.print(SqlType.canGet(row, column) ? "x " : ". ");
    }
    out.println();
  }
}
 

@Override
public void setSQLXML(
    final int parameterIndex,
    final SQLXML xmlObject
) throws SQLException {
    this.origin.setSQLXML(parameterIndex, xmlObject);
}
 

@Override
public Object getValue(final String columnLabel, final Class<?> type) throws SQLException {
    if (Blob.class == type || Clob.class == type || Reader.class == type || InputStream.class == type || SQLXML.class == type) {
        throw new SQLFeatureNotSupportedException();
    }
    return currentResultSetRow.getCell(labelAndIndexMap.get(columnLabel));
}
 

public SQLXML createSQLXML()
      throws SQLException {
      try
      {
  		checkForNullPhysicalConnection();
          return physicalConnection_.createSQLXML();
} catch (SQLException sqle) {
	notifyException(sqle);
	throw sqle;
}
  }
 

@Override
public Source getXmlAsSource(ResultSet rs, String columnName, Class<? extends Source> sourceClass) throws SQLException {
	SQLXML xmlObject = rs.getSQLXML(columnName);
	if (xmlObject == null) {
		return null;
	}
	return (sourceClass != null ? xmlObject.getSource(sourceClass) : xmlObject.getSource(DOMSource.class));
}
 

private InputStream handleResult(String charSet, Object result) {
    if (result == null) {
        return null; // or should this be an empty result?
    }
    try {
        if (result instanceof SQLXML) {
            if (charSet != null) {
                XMLSerialize serialize = new XMLSerialize();
                serialize.setTypeString("blob"); //$NON-NLS-1$
                serialize.setDeclaration(true);
                serialize.setEncoding(charSet);
                serialize.setDocument(true);
                return ((BlobType) XMLSystemFunctions.serialize(serialize, new XMLType((SQLXML) result)))
                        .getBinaryStream();
            }
            return ((SQLXML) result).getBinaryStream();
        } else if (result instanceof Blob) {
            return ((Blob) result).getBinaryStream();
        } else if (result instanceof Clob) {
            return new ReaderInputStream(((Clob) result).getCharacterStream(),
                    charSet == null ? Charset.defaultCharset() : Charset.forName(charSet));
        }
        return new ByteArrayInputStream(
                result.toString().getBytes(charSet == null ? Charset.defaultCharset() : Charset.forName(charSet)));
    } catch (SQLException | TransformationException e) {
        throw new ResponseStatusException(HttpStatus.INTERNAL_SERVER_ERROR, e.getMessage(), e);
    }
}
 

@Override
@Nullable
public Source getXmlAsSource(ResultSet rs, int columnIndex, @Nullable Class<? extends Source> sourceClass)
		throws SQLException {

	SQLXML xmlObject = rs.getSQLXML(columnIndex);
	if (xmlObject == null) {
		return null;
	}
	return (sourceClass != null ? xmlObject.getSource(sourceClass) : xmlObject.getSource(DOMSource.class));
}
 

@Override
public void updateSQLXML(String columnLabel, SQLXML xmlObject) throws SQLException {
    throw new UnsupportedOperationException("Not supported yet.");
}
 

@Override
public SQLXML getSQLXML(String parameterName) throws SQLException {
    // TODO Auto-generated method stub
    return null;
}
 

@Override
public SQLXML getSQLXML(int columnIndex) throws SQLException {
    throw new UnsupportedOperationException("Not supported yet.");
}
 

@Override
public void setSQLXML(int parameterIndex, SQLXML xmlObject)
throws SQLException
{
  throw new SQLFeatureNotSupportedException();
}
 

@Override
public SQLXML getSQLXML(int columnIndex) throws SQLException {
    throw new UnsupportedOperationException("Not supported yet.");
}
 

@Override
public void setSQLXML(String parameterName, SQLXML xmlObject) throws SQLException {
    throw new UnsupportedOperationException("Not supported yet.");
}
 

@Test(expected = SQLFeatureNotSupportedException.class)
public void assertGetValueForSQLXML() throws SQLException {
    memoryMergedResult.getValue(1, SQLXML.class);
}
 

@Override
public SQLXML createSQLXML() throws SQLException {
    // Stub Only
    return null;
}
 

@Override
public SQLXML getSQLXML(String columnLabel) throws SQLException {
    throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
}
 

@Override
public void setSQLXML(int parameterIndex, SQLXML xmlObject) throws SQLException {
  AssertionUtil.notYetImplemented();
}
 

@Override
public void updateSQLXML(String columnLabel, SQLXML xmlObject) throws SQLException {
	rset.updateSQLXML(columnLabel, xmlObject);
}
 

@Override
public SQLXML createSQLXML() throws SQLException {
    return connection.createSQLXML();
}
 

@Override
public void updateSQLXML(String columnLabel, SQLXML xmlObject) throws SQLException {
	throw new UnsupportedOperationException("Zebra unsupport updateSQLXML");
}
 

public SQLXML getSQLXML(int columnIndex) throws SQLException {
    throw SQLExceptionFactory.notImplemented ("getSQLXML (int)");
}
 

public void updateSQLXML(int columnIndex, SQLXML xmlObject)
    throws SQLException {
  noUpdateException(columnIndex);
}
 

@Override
public SQLXML createSQLXML() throws SQLException {
    return connection.createSQLXML();
}
 

public SQLXML getSQLXML(String parametername) throws SQLException {
    throw Util.notImplemented();
}
 

@Override
public SQLXML getSQLXML(int columnIndex) throws SQLException {
    throw new UnsupportedOperationException("Not supported yet.");
}
 

@Override
public SQLXML getSQLXML(int columnIndex) throws SQLException {
    throw new UnsupportedOperationException("Not supported yet.");
}
 

public void updateSQLXML(String columnLabel, SQLXML xmlObject)
        throws SQLException {
    rs.updateSQLXML(columnLabel, xmlObject);
}
 

public void setSQLXML(int arg0, SQLXML arg1)
        throws SQLException {
     getPhysPs().setSQLXML(arg0, arg1);
}
 

@Override
public SQLXML getSQLXML(String parameterName) throws SQLException {
	// TODO Auto-generated method stub
	return null;
}
 

@Override
public void updateSQLXML(final int index, final SQLXML value) throws SQLException {
    this.origin.updateSQLXML(index, value);
}